Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-1010

Implement INFORMATION_SCHEMA in Hive

    XMLWordPrintableJSON

    Details

    • Hadoop Flags:
      Incompatible change, Reviewed
    • Release Note:
      Hide
      New method added to StorageHandler to pass credentials around.

      Adds db type to hive schematool. The db type is "hive". When you run the schematool w/ hive it installs the "sys" db and the "information_schema" db. both contain tables and views that expose meta information about tables, columns etc.
      Show
      New method added to StorageHandler to pass credentials around. Adds db type to hive schematool. The db type is "hive". When you run the schematool w/ hive it installs the "sys" db and the "information_schema" db. both contain tables and views that expose meta information about tables, columns etc.

      Description

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

        Attachments

        1. HIVE-1010.7.patch
          158 kB
          Gunther Hagleitner
        2. HIVE-1010.8.patch
          158 kB
          Gunther Hagleitner
        3. HIVE-1010.9.patch
          158 kB
          Gunther Hagleitner
        4. HIVE-1010.10.patch
          180 kB
          Gunther Hagleitner
        5. HIVE-1010.11.patch
          186 kB
          Gunther Hagleitner
        6. HIVE-1010.12.patch
          185 kB
          Gunther Hagleitner
        7. HIVE-1010.13.patch
          214 kB
          Gunther Hagleitner
        8. HIVE-1010.14.patch
          217 kB
          Gunther Hagleitner
        9. HIVE-1010.15.patch
          218 kB
          Gunther Hagleitner
        10. HIVE-1010.16.patch
          219 kB
          Gunther Hagleitner

          Issue Links

          breaks

          Bug - A problem which impairs or prevents the functions of the product. HIVE-17083 DagUtils overwrites any credentials already added

          • Major - Major loss of function.
          • Closed
          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
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-16630 Make connection pool pluggable in JdbcStorageHandler

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. HIVE-16657 Replace conf variable with checkDatabaseProduct-like in JDBCStorageHandler

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-16946 Information Schema Improvements

          • Major - Major loss of function.
          • Open
          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.
          • Resolved
          links to

          Web Link GitHub Pull Request #177

          Web Link GitHub Pull Request #181

          Web Link GitHub Pull Request #181

            Activity

              People

              • Assignee:
                hagleitn Gunther Hagleitner
                Reporter:
                hammer Jeff Hammerbacher
              • Votes:
                5 Vote for this issue
                Watchers:
                26 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m