Member since
12-30-2015
68
Posts
16
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1992 | 06-14-2016 08:56 AM | |
1749 | 04-25-2016 11:59 PM | |
2183 | 03-25-2016 06:50 PM |
04-26-2016
12:08 AM
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
Labels:
- Labels:
-
Apache Hive
-
Apache Knox
04-25-2016
11:59 PM
Hi, Thanks for your reply. I tried to query the same table today. And I was able to query it. Not sure why it was an issue earlier. I queried using the same ID again and it worked. Earlier it was an issue only from Tableau. I was able to query the hive external table and also Hbase table directly using command line without issues. Now this works fine.
... View more
04-22-2016
07:29 PM
1 Kudo
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
Labels:
- Labels:
-
Apache HBase
-
Apache Hive
03-25-2016
06:50 PM
Hi I just tried again the next day. I didnt change anything. Same variables for hadoop home hive home, hcat home and Hcat lib jars. Today it worked with both 1.3 and 1.4 TDCH.. Not sure why it didnt work the first time. Thanks for your time and help!
... View more
03-23-2016
10:45 PM
2 Kudos
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
Labels:
- Labels:
-
Apache HCatalog
-
Apache Hive
03-09-2016
09:03 PM
1 Kudo
I just logged into Ambari and found the hiveserver2 under summary tab. There are five hiveserver2 processes listed there. And each of them are running in different hosts. Why would there be so many hiveserver2 components? Isnt hiveserver2 a server process for processing client requests from cli? so shouldnt there be only one hiveserver2? Thanks!
... View more
03-09-2016
08:33 PM
1 Kudo
Sorry, I just started learning hadoop. Not sure where you want me look for this summary. I checked from hue. I could not see this detail. Can you please elaborate a little?
... View more
03-08-2016
10:54 PM
1 Kudo
I found the port information under the property hive.server2.thrift.port. But the only properties where server names are listed are under hive.zookeeper.quorum hive.metastore.uris. Can you please let me know which property I should be looking at to find the host that runs hiveserver2 service?
... View more
03-08-2016
10:23 PM
2 Kudos
Hi, how to get the host name and port number where the hiveserver2 process is running? I am working on a cluster environment and usually we login into edge node. Is it possible to get the hive server details from this edge node? I need this to connect to hive from tableau.
... View more
Labels:
- Labels:
-
Apache Hive
02-19-2016
09:35 PM
Hi Artem, Thanks for the info! I will go through those links. Yes, pig -useHCatalog is easier, but I am just curious to find out what I am doing wrong with other method. I think I missed to setup the PIG_OPTS properly. Now I setup that again and I am getting a different issue connecting to Hive metastore URI. Below is the error. 2016-02-19 15:07:43,839 [main] INFO hive.metastore - Trying to connect to metastore with URI
2016-02-19 15:08:49,718 [main] WARN hive.metastore - set_ugi() not successful, Likely cause: new client talking to old server. Continuing without it. Thank you!
... View more
- « Previous
- Next »