second88 created DRILL-5844: ------------------------------- Summary: 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 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)