[
https://issues.apache.org/jira/browse/HIVE-21137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vaibhav Gumashta updated HIVE-21137:
------------------------------------
Attachment: HIVE-21137.1.patch
> 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
> Assignee: Vaibhav Gumashta
> Priority: Major
> Attachments: HIVE-21137.1.patch, 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)
