Writing Data to Hive
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Database Connection
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@riteshparmar21 are you using Kerberos for security?
Do you get an error when just trying to read data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes, created dsn with Knox gateway and able to read the data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
And this might be a stoopid question, but have you confirmed with the db admin that you have write permission?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Might also want to destroy and recreate the Kerberos ticket too. When there's a blip in function, that's a common quick fix.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Issue is resolved now. There was some issue with Knox host. Got is resolved with the help of Hive DBA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I meet the same issue, however, have limit knowledge on Knox host, could you please share the solution experience?
