I generated Users.csv where I have simple ID and AGE fields. By default importing detects this fields like STRING but when I change type to INT importing fails.
8 | 10:17:13 IMPORT_DATA Import of tables failed: Type mismatch of column ‘id’ in table ‘Users’. Database column type ‘STRING’. Column type in file ‘INT’. |
---|---|
9 | 10:17:13 IMPORT_DATA Importing failed. Exception:java.lang.RuntimeException: Type mismatch of column ‘id’ in table ‘Users’. Database column type ‘STRING’. Column type in file ‘INT’. |