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

Implement "show create table"

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.10.0
    • Metastore, Query Processor
    • None

    Description

      SHOW CREATE TABLE would be very useful in cases where you are trying to figure out the partitioning and/or bucketing scheme for a table. Perhaps this could be implemented by having new tables automatically SET PROPERTIES (create_command='raw text of the create statement')?

      Attachments

        1. show_create.txt
          13 kB
          Edward Capriolo
        2. HiveShowCreateTable.jar
          7 kB
          Jay Ramadorai
        3. HIVE-967.patch.txt
          34 kB
          Feng Lu
        4. HIVE-967.6.patch.txt
          50 kB
          Feng Lu
        5. HIVE-967.5.patch.txt
          50 kB
          Feng Lu
        6. HIVE-967.4.patch.txt
          49 kB
          Feng Lu
        7. HIVE-967.3.patch.txt
          49 kB
          Feng Lu
        8. HIVE-967.2.patch.txt
          43 kB
          Feng Lu

        Issue Links

          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. HIVE-1187 Implement ddldump utility for Hive Metastore

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-4210 output of "show create table" shoud contain a Semicolon at the end of the query string

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. HIVE-2816 Extend IMPORT/EXPORT with metadata only option

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-4659 while sql contains \t ， 'desc formatted view_name' and 'show create table view_name' statements will generate Incomplete results

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. HIVE-11706 Implement "show create database"

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Activity

            People

              farlue Feng Lu
              akramer Adam Kramer
              Votes:
              3 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: