community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Not able to write data to HIVE using Alteryx

I am not able to create a new table in HIVE or transfer data from SQL server to HIVE. I am getting the following error :

 

Error: Output Data (2): DataWrap2ODBC::SendBatch: [Hortonworks][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:86 cannot recognize input near '?' ',' '?' in expression specification Insert into `cn_ec_mrm_dl_secure`.`test1_0`(`table_name`,`last_updated_date`) Values (?,?)

Whereas there is no input as `?` or `,`. I am just executing a simple query like select * from tablename and trying to output the and save results in HIVE.

 

HIVE driver used is Hortonworks Hive ODBC driver .

 

 

 

 

Alteryx
Alteryx

Hi,

 

Please try using the Simba ODBC driver and let me know if this error persists.

 

The driver can be downloaded from the following link:

https://pages.alteryx.com/alteryx-driver-downloads-lp.html

Can u please let me know why this error is occurring using Hortonworks driver?

Alteryx
Alteryx

Hi,

 

Alteryx is not validated on the HW Hive ODBC Driver.

 

https://help.alteryx.com/current/DataSources/Hive.htm

 

Thanks,

Andrew

ok thanks, but still i am able to create tables but no values are being inserted

Alteryx
Alteryx

I would recommend you email Alteryx Support, support@alteryx.com, so they can look into this in greater detail.

Labels