In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Writing Data to Hive

riteshparmar21
5 - Atom

I am trying to write data to Hive using ODBC DSN and in DB Write tool.

But getting error as

"[Simba][Hardy] (35) Error from server: error code '1' error message: "Error while processing statement: Failed: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask  "

 

Can you please help me in resolving the issue.

7 REPLIES 7
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@riteshparmar21 are you using Kerberos for security?

Do you get an error when just trying to read data?

riteshparmar21
5 - Atom

yes, created dsn with Knox gateway and able to read the data

patrick_mcauliffe
14 - Magnetar
14 - Magnetar

And this might be a stoopid question, but have you confirmed with the db admin that you have write permission?

riteshparmar21
5 - Atom

Yes, write permission is there. I think some issue while creating the table just verifying that. Trying with new table. Will update if this works.

patrick_mcauliffe
14 - Magnetar
14 - Magnetar

Might also want to destroy and recreate the Kerberos ticket too.  When there's a blip in function, that's a common quick fix.

riteshparmar21
5 - Atom

Issue is resolved now. There was some issue with Knox host. Got is resolved with the help of Hive DBA.

HarryBott
5 - Atom

Hi,

I meet the same issue, however, have limit knowledge on Knox host, could you please share the solution experience?

Labels
Top Solution Authors