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.

NIFI selecthive3ql Error

Highlighted

NIFI selecthive3ql Error

New Contributor

I got the below exception when I use selecthive3ql, nifi user have full access to hive

 ERROR [Timer-Driven Process Thread-1] o.a.nifi.processors.hive.SelectHive3QL SelectHive3QL[id=4c924b44-939a-119a-ffff-ffffbea130fa] Unable to execute HiveQL select query select * from XXXXX for StandardFlowFileRecord[uuid=3e618441-dd2c-482a-84f6-4607a31c7c0f,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1574089612400-1545, container=default, section=521], offset=95995, length=653],offset=0,name=86dece8f-0747-427a-91d1-be40c56e47d6,size=653] due to java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask; routing to failure: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
at org.apache.hive.jdbc.HiveStatement.waitForOperationToComplete(HiveStatement.java:401)
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:266)
at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:497)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.nifi.processors.hive.SelectHive3QL.onTrigger(SelectHive3QL.java:381)
at org.apache.nifi.processors.hive.SelectHive3QL.lambda$onTrigger$0(SelectHive3QL.java:286)
at org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:114)
at org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:106)
at org.apache.nifi.processors.hive.SelectHive3QL.onTrigger(SelectHive3QL.java:286)
at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1162)
at org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:205)
at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:117)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

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