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

Hive create table like comment

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Not A Bug
    • 1.1.0
    • None
    • SQL
    • None

    Description

      In cloudera:

      Cloning tables (LIKE clause):

      https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_create_table.html

      However can not run:

       

      hive> CREATE TABLE `test_like` LIKE `test` COMMENT 'test_like' STORED AS ORC TBLPROPERTIES('orc.compress'='SNAPPY');
      FAILED: ParseException line 1:38 missing EOF at 'COMMENT' near 'test'
      

       

      Can I add COMMIT in sql if I create table like?

       

      Attachments

        Activity

          People

            runlin Runlin Zhang
            wxmimperio wxmimperio
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: