Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to debug Hive2 beeline ?

Highlighted

How to debug Hive2 beeline ?

New Contributor

Hi,

I've succeed to create hive table by reflection from druid datasource . after restarting the hdp cluster I'm not able to query anymore this hive table I get

	Error: Error while compiling statement: FAILED: RuntimeException java.lang.RuntimeException: java.lang.reflect.InvocationTargetException

Now I would like to understand what the problem where can I check log file or something to understand what the problem.

Inneractive query is enable and running as expected, druid also work as expected

Thanks for help @Slim


4 REPLIES 4
Highlighted

Re: How to debug Hive2 beeline ?

New Contributor

Hi


I've tried to check all the possible logs and I can't get any clue on what's going on

I only get this in all log beeline and hive-server2-interactive.err

Do you know what else I can check ?

Here the hive-server2-interative.err

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null
Added [/usr/hdp/2.6.4.0-91/hive2/lib/hive-druid-handler.jar] to class path
Added resources: [/usr/hdp/2.6.4.0-91/hive2/lib/hive-druid-handler.jar]
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null
OK
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. null

Thanks

Highlighted

Re: How to debug Hive2 beeline ?

Expert Contributor

i believe HS2 logs are under /var/log/hive/hiveserver2.log

Highlighted

Re: How to debug Hive2 beeline ?

Guru

Hello @Richard Grossman,

Please follow this article to enable debug for Beeline. That might help you. Please paste the relevant debug log here if you want us to have a look.

Hope this helps!

Re: How to debug Hive2 beeline ?

Contributor

For full stack of error message from hive you could look into hiveserver log like @Slim was mentioning. Since hive interactive is enabled I believe you should look into hsihiveserver log on the node where HiveServer2 Interactive is running

Don't have an account?
Coming from Hortonworks? Activate your account here