GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/trafodion/pull/1615
TRAFODION-3086 Further enhancements to 'DDL on Hive objects'
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/trafodion ansharma_hiveddl_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1615.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1615
----
commit bb3dee8fdd0d0593073dd39162c381e0913ba734
Author: Anoop Sharma <anoop.sharma@...>
Date: 2018-06-16T19:17:06Z
CTAS fixes for ddl on hive objects
commit 9f3fb9fd9d8974bd426ff31fb0e51aecd2490c88
Author: Anoop Sharma <anoop.sharma@...>
Date: 2018-06-18T20:48:17Z
Merge remote branch 'origin/master' into ansharma_hiveddl_br
commit 2bba19ffaa8b6737e928ad98e4b0cf8cc6b24349
Author: Anoop Sharma <anoop.sharma@...>
Date: 2018-06-19T19:50:13Z
TRAFODION-3086 Further enhancements to 'DDL on Hive objects'
-- Hive CTAS enhancements
-- CTAS will do create through Hive and insert...select in Traf
-- a cqd can be set if CTAS need to be passed in completely to Hive
-- CTAS 'no load' option can be used to create a Hive
table LIKE a traf table.
Older 'create hive like traf' is removed.
-- explain for CTAS to show ddl, insert...select, upd...stats stmts
-- Truncate enhancements.
-- traf: purgedata, truncate, truncate table
-- Hive: truncate, truncate table
-- 'if exists' option has been added
-- Hive truncate is through new exeutil operator
-- older operator uses LOB interface to clear data.
Maintained as Legacy operator, will be removed.
-- new operator uses Hive to truncate tables
-- explain for truncate to show trunc query that will be sent
-- removed obsolete parallel label op
-- removed obsolete purgedata (fast delete) op
----
---
