[
https://issues.apache.org/jira/browse/IMPALA-12583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17793071#comment-17793071
]
Wenzhe Zhou edited comment on IMPALA-12583 at 12/7/23 11:11 PM:
----------------------------------------------------------------
Querying the information_schema database:
https://docs.cloudera.com/cdw-runtime/cloud/using-hiveql/topics/hive_query_information_schema.html
Checked "create table" statements of information_schema.views,
information_schema.tables, information_schema.table_privileges,
information_schema.schemata. These 4 views are created on top of tables of sys
database - sys.dbs, sys.tbls, and sys.tbl_privs. Tables of sys database -
sys.dbs, sys.tbls, and sys.tbl_privs are fetched from the database of Hive
Metastore through Hive JdbcStorageHandler.
was (Author: wzhou):
Querying the information_schema database:
https://docs.cloudera.com/cdw-runtime/cloud/using-hiveql/topics/hive_query_information_schema.html
> Support reading hive "information_schema" views in Impala
> ---------------------------------------------------------
>
> Key: IMPALA-12583
> URL: https://issues.apache.org/jira/browse/IMPALA-12583
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Manish Maheshwari
> Priority: Major
> Attachments: image-2023-11-30-02-24-18-869.png
>
>
> Hive supports "information_schema" db that all jdbc tables exposed from the
> HMS database. The same jdbc source tables should be queryable in Impala too.
>
> !image-2023-11-30-02-24-18-869.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
