Member since
02-02-2021
116
Posts
2
Kudos Received
5
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 1313 | 08-13-2021 09:44 AM | |
| 5997 | 04-27-2021 04:23 PM | |
| 2346 | 04-26-2021 10:47 AM | |
| 1533 | 03-29-2021 06:01 PM | |
| 4210 | 03-17-2021 04:53 PM |
07-02-2021
11:19 AM
Hello @ryu , Refer below link for Enabling PQS via ambari ++++++++++++ https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.5.3/bk_data-access/content/ch_using-phoenix.html#enabling-phoenix </snippet from the link> To enable Phoenix with Ambari: Open Ambari. Select Services tab > HBase > Configs tab. Scroll down to the Phoenix SQL settings. (Optional) Reset the Phoenix Query Timeout. Click the Enable Phoenix slider button. ++++++++++++ Also would recommend to review below doc for installing phoenix via command line https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.5.3/bk_command-line-installation/content/ch_install_phoenix_chapter.html
... View more
06-03-2021
03:54 PM
Also Squirrel seems to be connecting to the dev cluster. It just times out when running a query such as "show databases". If squirrel stays connected for a long time, I noticed that the query will eventually return results instead of timing out. Per cloudera "https://docs.cloudera.com/documentation/enterprise/latest/topics/cdh_ig_hive_metastore_configure.html#concept_jsw_bnc_rp" It says that minimum 4 dedicated cores to HS2 and 4 for hive metastore. The server that hosts hs2 and metastore only has a total of 8 cores. Can this be a reason for the performance issue? Any help on this is much appreciated. Thanks,
... View more
05-12-2021
10:26 PM
Hi, You can go to this below link: https://docs.cloudera.com/documentation/enterprise/6/6.2.html Choose the CDH version you need to check -> Then choose "Release Notes" for more details. Below is the CDP "Release Notes: https://docs.cloudera.com/cdp-private-cloud/latest/release-guide/topics/cdpdc-release-notes-links.html
... View more
04-27-2021
04:23 PM
1 Kudo
Here is an update. So I finally was able to use ambari to get Hive installed and services started using the apache bigtop repo. Also was able to connect via hiveCLI as well as beeline(hiveserver2) and ran a simple "show databases;" which ran successfully. So after symlinking the following directories, hiveserver2 finally was able to start successfully. [root@test ~]# ll /usr/bgtp/current/ total 32 lrwxrwxrwx 1 root root 13 Apr 23 19:38 hive-client -> /usr/lib/hive lrwxrwxrwx 1 root root 13 Apr 23 19:37 hive-metastore -> /usr/lib/hive lrwxrwxrwx 1 root root 13 Apr 27 16:28 hive-server2 -> /usr/lib/hive lrwxrwxrwx 1 root root 22 Apr 27 16:29 hive-webhcat -> /usr/lib/hive-hcatalog I did not find any documentation on how to install hive with the apache bigtop packages using ambari. There was some documentation on how to install hive with the apache bigtop package using the command line. If anyone finds any documentation on how to install the different components in the apache bigtop package, please let me know. Thanks,
... View more
04-26-2021
10:47 AM
ok so I finally figured out how to have ambari run the command /usr/bin/yum -d 0 -e 0 -y install hive-hcatalog I had to modify the file: /var/lib/ambari-server/resources/common-services/HIVE/0.12.0.2.0/metainfo.xml under the <osSpecifics> tag. Restarted ambari and then ambari was able to run the correct command to have hive installed.
... View more
03-29-2021
06:01 PM
ok sorry I just found the issue. Noticed the LLAP daemons were being run by the user hive whereas the AMs were being run by the user root. Now I have the AM and the daemons both being run by hive and now the Hive LLAP UI is being updated and working.
... View more
03-25-2021
09:05 AM
Thanks @Daming Xue for the response. So i tried installing Hive 2.2 and it worked. Do you know how I can test hive LLAP vs regular hiveserver2 to see the difference? Any good hiveserver2 queries or something so I can test the LLAP setup vs hiveserver2? Thanks,
... View more
03-23-2021
03:50 AM
Please find more about the "pros and cons to having hive jobs run as the hive user or the end user" vs. Ranger in our public Cloudera documentation for CDP: Enabling or disabling impersonation (doas)
... View more
03-23-2021
02:28 AM
To see more on Hive Managed and External tables, please see our public documentation for CDP Hive.
... View more
03-17-2021
04:53 PM
Ok seems like I had hive.security.authoization.enabled to true in the hiveserver2-site.xml but had not enabled the ranger hive plugin yet. Once I set this property to false, I was able to see the hive databases with "show databases".
... View more
- « Previous
-
- 1
- 2
- Next »