# Toad datapoint ODBC insert error IMPORT wizard

**URL:** <https://forums.toadworld.com/t/toad-datapoint-odbc-insert-error-import-wizard/47535>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [September 6, 2019, 5:43am UTC](https://forums.toadworld.com/t/toad-datapoint-odbc-insert-error-import-wizard/47535 "2019-09-06T05:43:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![agemo](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@agemo](https://forums.toadworld.com/u/agemo)\
**Post date:** [September 6, 2019, 5:43am UTC](https://forums.toadworld.com/t/toad-datapoint-odbc-insert-error-import-wizard/47535/1 "2019-09-06T05:43:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\
**Post date:** [September 6, 2019, 6:52am UTC](https://forums.toadworld.com/t/toad-datapoint-odbc-insert-error-import-wizard/47535/2 "2019-09-06T06:52:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![agemo](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@agemo](https://forums.toadworld.com/u/agemo)\
**Post date:** [September 8, 2019, 9:30pm UTC](https://forums.toadworld.com/t/toad-datapoint-odbc-insert-error-import-wizard/47535/3 "2019-09-08T21:30:23Z")

</div>

hey filip  
cloudera ODBC HIVE connection.  
toad data point 4.3