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.