Writing Data to Hive

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.

Error Message

Database Connection

Accepted answers

All comments

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?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280