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

            is blocked by

            New Feature - A new feature of the product, which has yet to be developed. HIVE-675 Add Database/Schema support to Hive QL

            • Major - Major loss of function.
            • Closed

            New Feature - A new feature of the product, which has yet to be developed. HIVE-972 Support views

            • Major - Major loss of function.
            • Closed
            relates to

            New Feature - A new feature of the product, which has yet to be developed. HIVE-1555 JDBC Storage Handler

            • Major - Major loss of function.
            • Open

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              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
              Permalink
              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
              Permalink
              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:
                  5 Vote for this issue
                  Watchers:
                  10 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Development