[
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/8/23 1:42 AM:
---------------------------------------------------------------
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.
Here are SQL scripts to create HIVE system db and INFORMATION_SCHEMA:
https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/hive/hive-schema-4.0.0-beta-2.hive.sql
https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/hive/hive-schema-3.1.0.hive.sql
was (Author: wzhou):
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.
Here is SQL scripts to create HIVE system db and INFORMATION_SCHEMA:
https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/hive/hive-schema-4.0.0-beta-2.hive.sql
https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/hive/hive-schema-3.1.0.hive.sql
> 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, information_schema.txt
>
>
> 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]
