Data is not loaded to Hive

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

Accepted answers

LisaL

@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.

All comments

LisaL

@24

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.

LisaL

@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

@LisaL 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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703