[
https://issues.apache.org/jira/browse/TRAFODION-3086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16517451#comment-16517451
]
ASF GitHub Bot commented on TRAFODION-3086:
-------------------------------------------
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
----
> Traf support for DDL operations directly on Hive objects
> ----------------------------------------------------------
>
> Key: TRAFODION-3086
> URL: https://issues.apache.org/jira/browse/TRAFODION-3086
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
> Attachments: HiveDDL.docx
>
>
> A previous Jira, TRAFODION-2498, added support to pass through some DDL
> commands to hive API. It was done via: process hive statement
> 'hive-ddl-command' syntax. The supplied command was passed in as-is to the
> underlying interface.
> This current Jira is to add support to directly perform DDL operations on
> Hive objects without having to use 'process hive statement'.
> Example: create table hive.hive.t (...) ...
> or: alter table hive.hivesch.t ....
> With this enhancement, Hive objects will be treated similar to traf objects
> while performing DDL operations. Things like registration/unregistration in
> traf MD, query invalidation, cleanup, etc will be done automatically.
> A detailed spec/note will be added later.
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
