As far as I can see, the values of TABLE_TYPE returned from method DatabaseMetaData.getTables of JDBC API of a Drill Connection include:
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".