[DRILL-5844] Incorrect values of TABLE_TYPE returned from method DatabaseMetaData.getTables of JDBC API

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.17.0
• Component/s: Client - JDBC, Metadata
• Labels: ready-to-commit
• Assignee: Arjun Gupta
• Reporter: second88
• Reviewer: Igor Guzenko
• Created: 05/Oct/17 06:47
• Updated: 04/Dec/19 12:57
• Resolved: 04/Dec/19 12:57

Description

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, 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 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".

Issue Links

• relates to: CALCITE-2001 JDBC driver should return "SYSTEM TABLE" rather than "SYSTEM_TABLE"
• links to: GitHub Pull Request #1904