[IMPALA-3193] Return table comments in GetTables Thrift API call and SHOW TABLES statement resultset

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 1.3, Impala 1.4, Impala 2.0, Impala 2.1, Impala 2.2
• Component/s: Catalog, Clients
• Labels: ramp-up
• Assignee: Jin Chul Kim
• Reporter: Holman Lan
• Created: 16/Mar/16 23:55
• Updated: 07/May/19 00:57
• Resolved: 07/May/19 00:57

Description

When accessing Impala via the Thrift interface the server always returns empty string for the comments/remarks column for the GetTables API call.

It would also be nice if Impala can return table comments for the SHOW TABLES statement. Currently it only returns the table name.

Attached is a simple Java program that uses the open-source Hive JDBC driver to connect to Impala via the Thrift interface and prints out results for the getTables JDBC API call. We notice that the JDBC driver internally uses the GetTables API call to retrieve metadata from Impala for the getTables JDBC API call. The remarks/comments column is always an empty string and it looks like it is because the server always returns empty string for that column.

Impala returns column comments for the GetColumns Thrift API call as well as the DESCRIBE <table> statement.

Issue Links

• duplicates: IMPALA-7587 Follow up for IMPALA-2636: consider fixing GetTables() for tables with not loaded metadata