About EricL

EricL · ‎09-16-2019

@ChineduLB No you can't, you can only save data into temp tables, or simply use sub-query instead. Cheers Eric

yukti · ‎09-11-2019

@EricL Hi Eric it was pointing to wrong spark conf so I replaced it with the new one. But now its giving me another error. I will open anew thread for another error.

AnthonyMz · ‎09-10-2019

Thanks again @zoltanx_intel , much appreciated

EricL · ‎09-10-2019

@DataMike, I am afraid that there is no such option that I am aware of, you would have to stop and start one by one manually. Cheers Eric

EricL · ‎09-04-2019

@ Vinit_Kratin, If low response time is a must, then Hive is not an option, Impala should be faster. HBase designed tables require a row key, which means, all data you want to retrieve will need this key to be queried against HBase. So for your event based data, if you need to use an event id to store and retrieve data, then hbase might be suitable. I still suggest you to go through details of differences between HBase and Hive and Impala to get a better understanding. Google is your friend. Cheers Eric

EricL · ‎09-01-2019

Hi @tuk, It will only get backported into CDH after it has been fixed upstream. Since it is still open, and no solution is provided, CDH won't have the fix either. Cheers Eric

EricL · ‎08-30-2019

@iamabug The principal names are generated based on host's actual FULL qualified domain name, so it has to match with actual hostname, otherwise Kerberos will not work. So what you want in my opinion will not work, as kerberos is quite fuzzy about DNS resolutions. Cheers Eric

EricL · ‎08-28-2019

@ChineduLB If you go to CM > Sentry > Configuration > search for "database", you should be able to see those database options, the one you need is "Sentry Server Database Password". Plus, you also need to make sure that the username and password you used here can connect to Sentry database. Cheers Eric

nanda_bigdata · ‎08-14-2019

Hi Andre, Your solution is right. But my situation was little different. Below are the checks and fix I did with cloudera support helping me in the process: 1. From Hive-server2 logs we found that one of the Hiveserver2 instance is not talking to zookeeper quorum(only in case of querying Hbase data) 2. Installed Hbase-gateway services on all the Hue instances and Hiveserver2 instances. 3. restart Hbase services and Deploy client configuration. 4. Restart the Hiveserver2 instance which had the problem of trying to connect to localhost:2181 as zookeeper quorum Then tried to submit the query from beeline and Hue . All worked as expected this time.

EricL · ‎08-14-2019

For number 2, ANY changes outside of Impala, you will need INVALIDATE METADATA, or if new data added, then REFRESH will do. Work is underway to improve it: https://issues.apache.org/jira/browse/IMPALA-3124 Cheers Eric

Online	Offline
Last Visited	‎08-12-2020 03:17 AM

Member Since	‎03-23-2015 01:24 PM
Last Visited	‎08-12-2020 03:17 AM
Posts	1,288
Kudos received	113

Cloudera Community

Re: max() function generating an error in sqoop

Re: Hive Server 2 failing to start CDP ,Cloudera M...

Re: Cloudera Hadoop internal workings

Re: Cloudera Manager APIs

Re: HDFS folder permission denied, but the user is...

Re: Store intermediate Query Result to variable in...

Re: SparkContext giving error in initialization : ...

Re: username autofills in search fields

Re: Exclude Kafka Service from Cluster Start/Stop?

Re: Which is better for performance? hive 3 or hba...

Re: Is upstream issue HDFS-8298 fixed ?

Re: How do I change hostname shown in Cloudera Man...

Re: Upgrade Sentry Database Tables fails after upg...

Re: Zookeeper client connecting to localhost:2181 ...

Re: When I have to Refresh / Invalidate Metadata a...