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.
@riteshparmar21 are you using Kerberos for security?
Do you get an error when just trying to read data?
yes, created dsn with Knox gateway and able to read the data
And this might be a stoopid question, but have you confirmed with the db admin that you have write permission?
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.
Might also want to destroy and recreate the Kerberos ticket too. When there's a blip in function, that's a common quick fix.
Issue is resolved now. There was some issue with Knox host. Got is resolved with the help of Hive DBA.
Hi,
I meet the same issue, however, have limit knowledge on Knox host, could you please share the solution experience?