Toad World® Forums

Toad datapoint ODBC insert error IMPORT wizard

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

Hi,
we will try to reproduce the issue but can you give me also information what HIVE do you use and what version of Toad do you have?
Filip

hey filip
cloudera ODBC HIVE connection.
toad data point 4.3