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

Implement "show create table"

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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. HIVE-967.6.patch.txt
          50 kB
          Feng Lu
        2. HIVE-967.5.patch.txt
          50 kB
          Feng Lu
        3. HIVE-967.4.patch.txt
          49 kB
          Feng Lu
        4. HIVE-967.3.patch.txt
          49 kB
          Feng Lu
        5. HIVE-967.2.patch.txt
          43 kB
          Feng Lu
        6. HIVE-967.patch.txt
          34 kB
          Feng Lu
        7. HiveShowCreateTable.jar
          7 kB
          Jay Ramadorai
        8. show_create.txt
          13 kB
          Edward Capriolo

        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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment