You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Wenzhe Zhou (Jira)" <ji...@apache.org> on 2024/02/07 05:04:00 UTC

[jira] [Commented] (IMPALA-12583) Support reading hive "information_schema" views in Impala

    [ https://issues.apache.org/jira/browse/IMPALA-12583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815101#comment-17815101 ] 

Wenzhe Zhou commented on IMPALA-12583:
--------------------------------------

Typical configurations in hive-site.xml, including driver class, jdbc url, user-name/password:

      <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <value>org.postgresql.Driver</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>password</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:postgresql://localhost:5432/HMS_home_wzhou_projects_impala_cdp</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>hiveuser</value>
      </property>


> 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
>            Assignee: Wenzhe Zhou
>            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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org