MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
The CSV storage engine does not support indexing.
CSV
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.
NOT NULL