Hi All, I have a query here. How to assign a seperate yarn queue when i submit query for hive-hbase integration table ? By default it goes to default queue. Appreciate your help please. thanks, Rishit Shah ... View more

All, Just adding for knowledge gain , if my source is kerberos enabled while target is not , then the command to be executed will be hadoop distcp -D ipc.client.fallback-to-simple-auth-allowed=true webhdfs://source-ip webhdfs://target-ip hadoop distcp -D ipc.client.fallback-to-simple-auth-allowed=true : this command overrides values present in the hive-site.xml. thanks, Rishit Shah ... View more

Yes it fails with select queries. i checked above that but i dont know how to make us of the patch? thanks, Rishit Shah ... View more

Hi @Pardeep i think this is not a seperate issue but it is on same line. the above resolution just solved a partial query. Hope this is fine. Let me know your input for resolving my query. thanks, Rishit Shah ... View more

Hi Sindhu, the above just resolved the issue for normal function. Now when i am trying to run frunction for hive as a UDF hplsql, it throws error. Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: Error evaluating hplsql Below steps followed: add jar /usr/hdp/current/hive-server2-hive2/lib/antlr4-runtime-4.5.jar; add jar /usr/hdp/2.6.0.3-8/hive2/lib/hive-hplsql-2.1.0.2.6.0.3-8.jar; add jar /home/devRht/hplsql/hplsql-0.3.17/hplsql-0.3.17.jar; CREATE TEMPORARY FUNCTION hplsql AS 'org.apache.hive.hplsql.Udf'; add file /home/devRht/hplsql/hplsql-0.3.17/hplsql-site.xml; add file /home/devRht/hplsql/hplsql-0.3.17/hplsql; thanks, Rishit Shah ... View more

Hi Sindhu, i could solve it with this: java -cp $SCRIPTPATH:$HADOOP_CLASSPATH:/home/devRht/hplsql/hplsql-0.3.17/hplsql-0.3.17.jar:/home/devRht/hplsql/hplsql-0.3.17/antlr-runtime-4.5.jar $H ADOOP_OPTS org.apache.hive.hplsql.Hplsql "$@" ... View more

hi Sindhu, Thanks for the reply. I tried to change as per your suggestion : java -cp /home/devRht/hplsql/hplsql-0.3.17/hplsql-0.3.17.jar:/home/devRht/hplsql/hplsql-0.3.17/antlr-runtime-4.5.jar:$HADOOP_OPTS org.apache.hive.hpl sql.Hplsql "$@" but now its showing below error Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/cli/ParseException at org.apache.hive.hplsql.Exec.<init>(Exec.java:87) at org.apache.hive.hplsql.Hplsql.main(Hplsql.java:23) Caused by: java.lang.ClassNotFoundException: org.apache.commons.cli.ParseException at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 2 more thanks, Rishit Shah ... View more

Hi, i also came across following directories sudo rm -rf /var/spool/mail/hive sudo rm -rf /var/spool/mail/zookeeper sudo rm -rf /var/spool/mail/oozie sudo rm -rf /var/spool/mail/ams sudo rm -rf /var/spool/mail/tez sudo rm -rf /var/spool/mail/livy sudo rm -rf /var/spool/mail/ambari-qa sudo rm -rf /var/spool/mail/flume sudo rm -rf /var/spool/mail/kafka sudo rm -rf /var/spool/mail/yarn sudo rm -rf /var/spool/mail/mapred sudo rm -rf /var/spool/mail/hcat sudo rm -rf /var/spool/mail/slider sudo rm -rf /var/spool/mail/sqoop sudo rm -rf /var/spool/mail/zeppelin ... View more

Hi @Bernhard Walter thanks for the reply. As i mentioned in other post above i even tried with date1 but got same error as key not found. is it possible that loading from oracle directly is creating any prob? thanks, Rishit Shah ... View more