Hi I am trying to execute a query in Hive through WebHcat services of Knox using below (Kerberos enabled) curl -i -u testuser:abcdef -d execute="select+*+from+test_table;" \ -d statusdir="pokes.output" \ 'https://knox.testserver.com:8443/gateway/sample/templeton/v1/hive?user.name=testuser' But this does not work, This fails with following message HTTP/1.1 500 Server Error Set-Cookie: JSESSIONID=18unyi37n3omieug23ruoetn0;Path=/gateway/sample;Secure;HttpOnly Expires: Thu, 01 Jan 1970 00:00:00 GMT Server: Jetty(7.6.0.v20120127) Content-Type: application/json Content-Length: 93 {"error":"File /user/hadoop/2.3.4.0-3485/hive/lib/hive-common.jar/zookeeper.jar does not exist."} in the first place.. instead of hive-common.jar I have hive-common-1.2.1.2.3.4.0-3485.jar and this does not include zookeeper.jar in it. Any idea how to solve this? ... View more

I am using Tableau V8.2. I am able to connect to Hive from Tableau and query Hive managed tables. But When I try to query the Hive external table with actual table in Hbase, I am getting permission denied error when trying to select data. But when I drag and drop the external table to query window, I am able to get the external table metadata without issues. Its just that the read is not working even though I have all the permissions. Mine is kerberized cluster. Does this have something to do with this? Any idea how to access this? Note: I created a ODBC driver connection and TDC file for tableau connectivity and connected to Hive using "Other ODBC sources" from Tableau. I was unable to connect using Hortonworks Hive Driver. ... View more

Hi, I am using TDCH 1.3 to export data from Hive to Teradata. I added HADOOP_CLASSPATH and HIve home, Hcat home and Sqoop home and HCAT_LIB_JARS and passed this in TDCH command. export HCAT_LIB_JARS=${HCAT_HOME}/share/hcatalog/hive-hcatalog-core.jar,$HIVE_HOME/lib/hive-cli.jar,$HIVE_HOME/lib/hive-exec.jar,$HIVE_HOME/lib/hive-metastore.jar,$HIVE_HOME/lib/libfb303-0.9.2.jar,$HIVE_HOME/lib/libthrift-0.9.2.jar,$HIVE_HOME/lib/jdo-api-3.0.1.jar I get the following error. I added all the jars I found the HcatInputFormat class also (the one that is said as missing) in the hive-hcatalog jars ${HCAT_HOME}/share/hcatalog/hive-hcatalog-core.jar. But the path is slightly different in this. org/apache/hive/hcatalog/mapreduce/HCatInputFormat.class --> highlighted the difference. But this class is reported as missing when it is in different path. How to fix this? 16/03/23 17:33:41 INFO tool.ConnectorExportTool: java.lang.NoClassDefFoundError: org/apache/hcatalog/mapreduce/HCatInputFormat at com.teradata.connector.hcat.processor.HCatInputProcessor.inputPreProcessor(HCatInputProcessor.java:41) ... View more