You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vaibhav Gumashta (JIRA)" <ji...@apache.org> on 2019/01/18 23:10:00 UTC
[jira] [Updated] (HIVE-21137) JDBC: HiveDatabaseMetaData.getTables
does not adhere to jdbc spec
[ https://issues.apache.org/jira/browse/HIVE-21137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vaibhav Gumashta updated HIVE-21137:
------------------------------------
Attachment: HiveJdbcClient.java
> JDBC: HiveDatabaseMetaData.getTables does not adhere to jdbc spec
> -----------------------------------------------------------------
>
> Key: HIVE-21137
> URL: https://issues.apache.org/jira/browse/HIVE-21137
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 3.1.1, 2.3.4
> Reporter: Vaibhav Gumashta
> Priority: Major
> Attachments: HiveJdbcClient.java
>
>
> The {{types}} parameter in {{HiveDatabaseMetaData.getTable(String catalog, String schemaPattern, String tableNamePattern, String[] types)}} is supposed to honor only the return values from {{HiveDatabaseMetaData.getTableTypes}}. However following is the output from the attached test jdbc programs:
> {code}
> *** Using dbMetadata.getTables ***
> *** With only EXTERNAL TABLE ***
> Table: test1
> Table: test_2
> Table: names_text
> Table: names_text_1
> *** With only TABLE ***
> Table: test1
> Table: test_2
> Table: names_text
> Table: names_text_1
> *** With only EXTERNAL_TABLE ***
> Table: test1
> Table: test_2
> Table: names_text
> Table: names_text_1
> *** With empty array ***
> Table: test1
> Table: test_2
> Table: names_text
> Table: names_text_1
> *** With VIEW ***
> *** With INDEX_TABLE ***
> Table: test1
> Table: test_2
> Table: names_text
> Table: names_text_1
> *** With VIEW, INDEX_TABLE ***
> *** With EXTERNAL_TABLE, VIEW, INDEX_TABLE ***
> *** With TABLE, VIEW, INDEX_TABLE ***
> Table: test1
> Table: test_2
> Table: names_text
> Table: names_text_1
> *** With a random string ***
> Table: test1
> Table: test_2
> Table: names_text
> Table: names_text_1
> *** getTableTypes ***
> Table: TABLE
> Table: TABLE
> Table: VIEW
> Table: MATERIALIZED_VIEW
> {code}
> We should fix the api so that clients can see expected behaviour.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)