Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
SHOW TABLES IN <DATABASE> will currently list tables and views. It would be helpful to also have the table type or object type returned with the list of object names so that a DESCRIBE command doesn't need to be run on each object. Our application uses object type quite frequently and to be able to pull this information at one time during a SHOW TABLE EXTENDED for example would be preferred over having to run DESCRIBE for each object in the database. We're using the Hive ODBC driver to connect. Thanks.