Writing Data to Hive

[riteshparmar21]

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.

[patrick_mcauliffe]

@riteshparmar21 are you using Kerberos for security?

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

[riteshparmar21]

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

[patrick_mcauliffe]

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

[riteshparmar21]

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]

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]

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

[HarryBott]

Hi,

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