MySQL 5.7 Release Notes
The CSV storage engine does not support
indexing.
Partitioning is not supported for tables using the
CSV storage engine.
All tables that you create using the CSV
storage engine must have the NOT NULL attribute
on all columns. However, for backward compatibility, you can
continue to use tables with nullable columns that were created in
previous MySQL releases. (Bug #32050)