I'm trying to import and create a new table using the IMPORT WIZARD for an ODBC connection to the HIVE/ hadoop system. My file is very simple 2 columns a less than 10 rows of data. This is the error I'm receiving and i have no clue why.
1:40:11 AM Thread (1) Connecting to :testing datalake(t890).
1:40:11 AM Thread (3) Import Started [06/09/2019 1:40:11 AM]
1:40:11 AM Thread (3) Processing "22.xlsx" into a new table workspace_t890.test123
1:40:13 AM Thread (3) Dropping Table
1:40:13 AM Thread (3) Drop table workspace_t890.test123 failed, error: ODBC Database Error
1:40:13 AM Thread (3) Creating table workspace_t890.test123
1:40:13 AM Thread (3) CREATE TABLE workspace_t890.test123 (Move_Title
VARCHAR(50),
Get_Out
VARCHAR(50))
1:40:17 AM Thread (3) Importing 1 out of 1 files
1:40:17 AM Thread (3) Reading from file 22.xlsx
1:40:17 AM Thread (3) Change Schema to workspace_t890
1:40:18 AM Thread (3) Row 1 failed to insert, error: ODBC Database Error
1:40:20 AM Thread (3) Inserting data into table workspace_t890.test123 generated an error. ODBC Database Error
ODBC Database Error
[Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:91 cannot recognize input near '?' ',' '?' in value row constructor
1:40:20 AM Thread (3) Import canceled, some rows may have been inserted. Change AutoCommit to Off to be able to rollback errors.
1:40:20 AM Thread (3) Error importing data, please check file format options: Inserting data into table workspace_t890.test123 generated an error. ODBC Database Error
1:40:20 AM Thread (3) Import Finished [06/09/2019 1:40:20 AM]
1:40:21 AM Thread (3) Import time: 00:00:09.7106315