[
https://issues.apache.org/jira/browse/DRILL-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
second88 updated DRILL-5844:
----------------------------
Affects Version/s: 1.10.0
> Incorrect values of TABLE_TYPE returned from method
> DatabaseMetaData.getTables of JDBC API
> ------------------------------------------------------------------------------------------
>
> Key: DRILL-5844
> URL: https://issues.apache.org/jira/browse/DRILL-5844
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC, Metadata
> Affects Versions: 1.10.0
> Reporter: second88
> Priority: Minor
>
> As far as I can see, the values of TABLE_TYPE returned from method
> DatabaseMetaData.getTables of JDBC API of a Drill Connection include:
> TABLE
> VIEW
> SYSTEM_TABLE
> According to [JDBC
> API|http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String\[\])],
> the typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY",
> "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
> Therefore "SYSTEM_TABLE" should be replaced by "SYSTEM TABLE".
> Besides, I wonder if this bug is related to another bug
> [DRILL-5843|https://issues.apache.org/jira/browse/DRILL-5843] reported by me.
> It should be noted that the values of TABLE_TYPE returned from methods
> DatabaseMetaData.getTables and DatabaseMetaData.getTableTypes should be
> one-to-one matched with but may not be the same as those in
> INFORMATION_SCHEMA.TABLES.TABLE_TYPE, for instance, "TABLE" VS "BASE TABLE".
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
