Member since
04-17-2018
14
Posts
1
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
27115 | 07-25-2018 04:43 PM | |
722 | 04-30-2018 02:27 AM |
07-25-2018
04:43 PM
1 Kudo
Your response is a bit overcomplicated. I resolved my own question. Below is a type of a query from HIVE Metastore I was looking for: SELECT DBS.NAME AS OWNER, TBLS.TBL_NAME as OBJECT_NAME, TBL_COMMENTS.TBL_COMMENT as OBJECT_DESCRIPTION, TBLS.TBL_ID as OBJECT_ID, TBLS.TBL_TYPE as OBJECT_TYPE, 'VALID' as OBJECT_STATUS, COLUMNS_V2.COLUMN_NAME, COLUMNS_V2.COMMENT as COLUMN_DESCRIPTION, COLUMNS_V2.TYPE_NAME AS DATA_TYPE COLUMNS_V2.* FROM DBS JOIN TBLS ON DBS.DB_ID = TBLS.DB_ID JOIN SDS ON TBLS.SD_ID = SDS.SD_ID JOIN COLUMNS_V2 ON COLUMNS_V2.CD_ID = SDS.CD_ID JOIN (SELECT DISTINCT TBL_ID, TBL_COMMENT FROM (SELECT TBLS.TBL_ID TBL_ID, TABLE_PARAMS.PARAM_KEY, TABLE_PARAMS.PARAM_VALUE, CASE WHEN TABLE_PARAMS.PARAM_KEY = 'comment' THEN TABLE_PARAMS.PARAM_VALUE ELSE '' END TBL_COMMENT FROM TBLS JOIN TABLE_PARAMS ON TBLS.TBL_ID = TABLE_PARAMS.TBL_ID) TBL_COMMENTS_INTERNAL) TBL_COMMENTS ON TBLS.TBL_ID = TBL_COMMENTS.TBL_ID;
... View more
07-25-2018
02:51 PM
@dsun thanks for the response. Are the table/column comments stored somewhere in HIVE Metastore? I already know about the describe command and Atlas. I need to extract the table/column comments into a table/file, not simply view them on screen. I hope this makes sense. Does anyone else know how to query table/column comments using HIVE Metastore? Thanks.
... View more
07-24-2018
09:33 PM
I am trying to figure out how to query table and column comments (descriptions) in HIVE Metastore. If there is a way to add the comments to HIVE tables/columns, shouldn't be a way to query/report on the comments from HIVE Metastore? Please help 🙂 Best Regards, Michael
... View more
Labels:
- Labels:
-
Apache Hive
04-30-2018
02:27 AM
@Geoffrey Shelton Okot found the solution. Firewalld was not installed on the image I am using. After running the command from this link, everything worked. It was not the permissions issue, firewalld was not on the image. Centos has an unclear way of explaining this. https://docs-old.fedoraproject.org/en-US/Fedora/19/html/Security_Guide/sec-Check_if_firewalld_is_installed.html Thanks for taking a look at this. Best
... View more
04-28-2018
07:12 PM
Hi Everyone, I am installing HDP2.6.0.0 onto a 3 node AWS cluster running CentOS Linux 7 x86_64 HVM EBS 1704_01. Got stuck on Configuring iptables step in the manual https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.0.0/bk_ambari-installation/content/configuring_iptables.html Here is the error: $ sudo systemctl disable firewalld Failed to execute operation: Access denied Also tried this (same w/out sudo): $ systemctl disable firewalld ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-unit-files === Authentication is required to manage system service or unit files. Authenticating as: Cloud User (centos) Password: ==== AUTHENTICATION COMPLETE === Failed to execute operation: Access denied Any idea why is it access denied? What is the right way to do this step?
... View more
Labels: