Member since
05-07-2018
331
Posts
45
Kudos Received
35
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
7041 | 09-12-2018 10:09 PM | |
2736 | 09-10-2018 02:07 PM | |
9326 | 09-08-2018 05:47 AM | |
3080 | 09-08-2018 12:05 AM | |
4103 | 08-15-2018 10:44 PM |
08-07-2018
09:43 PM
Hi @Michele Proverbio! Guess you're having issues with your DB used for Hive Metastore, could you check if the service it's up? And check if you can connect and access hive metastore tables. To confirm this, let's first check if you're able to connect through beeline without ZK. beeline -u 'jdbc:hive2://sandbox-hdp.hortonworks.com:10000/default' Otherwise, I'd say to check your DB setup. Ps: if you're not aware of your DB parameters for Hive, you can follow this steps: Go to Ambari > Hive > Configurations > Hive Metastore or you can try to run the following commands: #Example using hiveCLI hive -e "set; " > /tmp/hive.properties cat /tmp/hive.properties | grep -i "javax.jdo.option."
#Example using beeline
beeline -u 'jdbc:hive2://localhost:10000/default' -e "set;" > /tmp/beeline.properties
cat /tmp/beeline.properties | grep -i "javax.jdo.option." Hope this helps!
... View more
08-07-2018
03:19 PM
Hello @X M! Yeah, makes sense. It seems you're hitting this issue: https://github.com/apache/hive/blob/e867d1c693e966706d3b7c6fe18e039a85928f51/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/events/ListenerEvent.java#L164 To figure out if there's any misconfiguration you can check on both (hiveCLI and beeline) configs. Would be like this: hive -e "set;" > /tmp/hivecli.properties beeline -u 'jdbc:hive2:<HS2>:10000/default' -e "set;" > /tmp/beeline.properties And if the issue got solved, I'd kindly ask to you to accept as an answer, this will engage other HCC users to keep doing a good job. And will facilitate the search for the best answer. 🙂 Hope this helps!
... View more
08-06-2018
10:33 PM
I'm glad to know @Harjit Singh! 🙂 Please, if the issue got solved, I'd kindly ask you to accept this as an answer. This will engage other HCC users to keep doing a good job. Thanks.
... View more
08-06-2018
10:11 PM
Hey @X M! What do you get when you try to connect through beeline?
... View more
08-06-2018
10:07 PM
Hi @Krishnaraj V! I'm not sure if I get it, but are you trying to kill the consumer that you're creating right? If so, then I'd try to grep the kafka.tools.ConsoleConsumer + the topic name. Would be like: sleep 0.5m for line in $(cat /root/backup/listtopics.txt) do echo $line sleep 1m ps -ef | grep -i kafka.tools.ConsoleConsumer | grep -i $line| grep -v grep | awk '{print $2}' | xargs kill - 9 done Hope this helps!
... View more
08-06-2018
09:47 PM
Hi @Harjit Singh! Could you confirm if you already have something running on 7777 port? netstat -tulpn | grep -i 7777 Hope this helps!
... View more
08-06-2018
09:43 PM
Hello @Gnanasoundari Soundarajan! Sorry for the huge delay. Just a quick question, did you try to do a rolling restart on these brokers? Hope this helps!
... View more
07-31-2018
09:23 PM
Hi @Deepak SANAGAPALLI! Glad to hear that! Keep it up with your HiveServer and let us know if you find any other issues 🙂 Thanks
... View more
07-31-2018
09:07 PM
@Deepak SANAGAPALLI, now you should see the mysql-connector-java.jar under the libmysql-java. You can try to find it with the following command: find / -name "mysql-connector*" -type f -exec ls -ltrah {} \; If you are able to see it, then just follow the instruction inside that documentation link.
... View more
07-31-2018
08:57 PM
Hi @Deepak SANAGAPALLI. Try to install using this command: apt-get install libmysql-java Hope this helps!
... View more