Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3193

Return table comments in GetTables Thrift API call and SHOW TABLES statement resultset

    XMLWordPrintableJSON

    Details

    • 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
    • Fix Version/s: None
    • Component/s: Catalog, Clients
    • Labels:

      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.

        Attachments

        1. SimpleTestApp.java
          1 kB
          Holman Lan

          Issue Links

            Activity

              People

              • Assignee:
                jinchul Jinchul Kim
                Reporter:
                holmanl_impala_9dbd Holman Lan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: