JDBC driver DatabaseMetadata.getTables method returns views as type TABLE


#1

When you call DatabaseMetadata.getTables it will return a TABLE_TYPE of TABLE for views created in MAPD.

null,null,TABLE1,TABLE,null,null,null,null,null,null
null,null,VIEW1,TABLE,null,null,null,null,null,null

Similarly, DatabaseMetadata.getTableTypes only returns TABLE as a type.

https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTables-java.lang.String-java.lang.String-java.lang.String-java.lang.String:A-

https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTableTypes--