[HIVE-18736] Create Table Like doc needs to be updated

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Documentation
• Target Version/s: 3.0.0
• Assignee: Nikhil Harsoor
• Reporter: Eugene Koifman
• Created: 16/Feb/18 21:11
• Updated: 16/Mar/18 20:59

Description

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableLike needs to be updated.

according to HiveParser.g the syntax is much richer that what is in the doc

    -> ^(TOK_CREATETABLE $name $temp? $ext? ifNotExists?
         ^(TOK_LIKETABLE $likeName?)
         columnNameTypeOrConstraintList?
         tableComment?
         tablePartition?
         tableBuckets?
         tableSkewed?
         tableRowFormat?
         tableFileFormat?
         tableLocation?
         tablePropertiesPrefixed?
         selectStatementWithCTE?
        )

I tried specifying TBLPROPERTIES on current master (Hive 3.0) and it works. Updated doc accordingly but more verification/doc changes are needed.

Issue Links

• is related to: HIVE-18735 Create table like loses transactional attribute
• is related to: HIVE-18983 Add support for table properties inheritance in Create table like