[HIVE-16817] Restore CTAS tests in mm_all.q

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: hive-14535
• Assignee: Wei Zheng Assign to me
• Reporter: Wei Zheng
• Created: 02/Jun/17 17:30
• Updated: 02/Jun/17 17:57
• Resolved: 02/Jun/17 17:57

Description

In earlier ACID integration patch CTAS was not supported. (previously I used a different approach in which I created a new data operation type for INSERT ONLY, which got errored out in TxnHandler. Later I changed that to INSERT which is working fine) As CTAS is working now, the corresponding tests for it should be restored.

Note we still have the same limitations for MM tables as Hive regular tables do in general:

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableAsSelect(CTAS)

CTAS has these restrictions:
The target table cannot be a partitioned table.
The target table cannot be an external table.
The target table cannot be a list bucketing table.