Exasol is (in contrast to MySQL) a column-oriented, relational database management system and is therefore particularly suitable for large data sets (more than ~1,500 columns). So, this database system is significantly more powerful with large data sets.
The following points should be considered when importing CSV datasets into an Exasol project:
- Decimal separator: point instead of comma
- No spaces in numeric columns
- No duplicate column names
- No umlauts in column names
- No special characters, like '$' or '-', in a column name
- No period in the column names
- No special characters like _ at the beginning of the column name
For example, the Exasol error message "simple identifier expected" indicates that one or more column names contain periods (.).
If you use a weight variable, make sure that the variable type of the weight variable is "decimal". You can set the variable type in the project backend under DataSources in the corresponding data source. To open the editor for the setting, click on the variable's blue edit icon.
Also make sure to enter the correct decimal precision of the variable in the "Scale" field.