Data is not loaded to Hive

[24]

Hi,

I am creating a workflow to load data to the Hive data source.

When I run the workflow, table is created in the Hive data source but insert values are not populated.

I am getting below error:

Error: Output Data (6): DataWrap2ODBC::SendBatch: [Simba][Hardy] (80)

Syntax or semantic analysis error thrown in server while executing query. Error message from server:

Error while compiling statement: FAILED: ParseException line

Kindly guide me to sort out this issue.

Thanks in advance.

Thanks & Regards,

Thiru Murugan U

[lepome · Accepted solution]

@24 

Is the error message you posted the complete message?  If you hover over the message in the Results window, you should be able to see the whole message.  Another option would be to right-click in the Results window and save all the messages to a text file.  

Another question is what kind of connection are you making with your hive instance?  If it's an ODBC with a DSN, you can set the DSN to collect trace logs which might shed more light on the situation.

Do you have a paid license for Alteryx?  If so, we could pursue this as a regular Support Case.

[ntobon]

@24 Please try the following: Go to the advanced options of your Hive ODBC connection and turn the parameter "Use Native Query" off. Test it and let us know if it works.

[NathanMcCleaf]

I turned this off in my ODBC driver and still get an error:  

[susan3344]

i have the same error. filed not found in the output record. 

how did you solve this problem? 

[Edu_XGomes]

Hi Dear,

Coul you please help me to get the solve to this issue?

I am facing the same issue and already send to Alteryx support but they didn´t replay me back.

Thanks.

[Edu_XGomes]

Hi

Even with this ODBC configuration the error persists....

thanks.

[lepome]

@Edu_XGomes I understand you have resolved your issue.  The Support team is not always able to respond immediately, so posting in Community, as you did, is very often helpful.  To close the loop, would you please post what you've learned so that others can also benefit?

[ntobon]

@lepome  The error that @Edu_XGomes was getting was:

 [Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException Line 1:83 Table not found 'table_name'

He responded and resolved this way: "What I just did was insert a summarize tool because if there were any invalid caracter in column names I would be able to manage them but it was not needed. For now it seems that it is working as weel, after inserting a summarize in-db tool."

[Edu_XGomes]

Hi everyone,

To test it inserting a summarize in-db tool I had created a dummy database with 100,000 records and now It is running in a real DB with  more than 150 millions of records so I´ll back soon to you with updates about it.

Thanks.