Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5844

Incorrect values of TABLE_TYPE returned from method DatabaseMetaData.getTables of JDBC API

    XMLWordPrintableJSON

    Details

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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arjung Arjun Gupta
                Reporter:
                second88 second88
                Reviewer:
                Igor Guzenko
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: