[
https://issues.apache.org/jira/browse/DRILL-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva reassigned DRILL-5844:
---------------------------------------
Assignee: Arjun Gupta
> 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
> Assignee: Arjun Gupta
> Priority: Minor
> Fix For: 1.17.0
>
>
> 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
(v8.3.4#803005)
