Hive
  1. Hive
  2. HIVE-1010

Implement INFORMATION_SCHEMA in Hive

    Details

      Description

      INFORMATION_SCHEMA is part of the SQL92 standard and would be useful to implement using our metastore.

        Issue Links

          Activity

          Hide
          Carl Steinbach added a comment -

          MySQL INFORMATION_SCHEMA views: http://dev.mysql.com/doc/refman/5.1/en/information-schema.html

          There's been some discussion offline about supporting this using the JDO query language, i.e. expressing HiveQL queries against the INFORMATION_SCHEMA as JDOQL queries against the metastore.

          Additionally, supporting an INFORMATION_SCHEMA is probably the biggest missing piece that blocks grafting the PostgreSQL ODBC driver onto Hive (as has been done for LucidDB, H2, etc).

          Show
          Carl Steinbach added a comment - MySQL INFORMATION_SCHEMA views: http://dev.mysql.com/doc/refman/5.1/en/information-schema.html There's been some discussion offline about supporting this using the JDO query language, i.e. expressing HiveQL queries against the INFORMATION_SCHEMA as JDOQL queries against the metastore. Additionally, supporting an INFORMATION_SCHEMA is probably the biggest missing piece that blocks grafting the PostgreSQL ODBC driver onto Hive (as has been done for LucidDB, H2, etc).
          Hide
          John Sichi added a comment -

          Can we get the native SQL translation from JDO and then wrap this to get the data out of the metastore?

          http://hadoop.apache.org/common/docs/current/api/org/apache/hadoop/mapred/lib/db/DBInputFormat.html

          Then use HIve views to map metastore representation to INFORMATION_SCHEMA.

          Show
          John Sichi added a comment - Can we get the native SQL translation from JDO and then wrap this to get the data out of the metastore? http://hadoop.apache.org/common/docs/current/api/org/apache/hadoop/mapred/lib/db/DBInputFormat.html Then use HIve views to map metastore representation to INFORMATION_SCHEMA.
          Hide
          John Sichi added a comment -

          See HIVE-1555 for a JDBC storage handler.

          Show
          John Sichi added a comment - See HIVE-1555 for a JDBC storage handler.

            People

            • Assignee:
              Unassigned
              Reporter:
              Jeff Hammerbacher
            • Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:

                Development