You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/06/04 17:38:00 UTC

[jira] [Commented] (TRAFODION-3086) Traf support for DDL operations directly on Hive objects

    [ https://issues.apache.org/jira/browse/TRAFODION-3086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16500586#comment-16500586 ] 

ASF GitHub Bot commented on TRAFODION-3086:
-------------------------------------------

GitHub user anoopsharma00 opened a pull request:

    https://github.com/apache/trafodion/pull/1593

    TRAFODION-3086 Traf support for DDL operations on Hive objects

    -- Support for TRAFODION-3086. Details in document attached to jira.
    
    Other changes:
    -- support for "if not exists", "if exists" clause for create/drop view
    
    -- Support for:  truncate T, truncate table T.
      -- same as purgedata
    
    -- showddl <tab>, detail
    
    -- unregister hive schema <sch>
      -- will unregister all objects in specified schema
    
    -- Support for "if not registered", "if registered" clauss for
       register/unregister command.

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/1593.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 #1593
    
----
commit 6f490daf1b30e6ced48ce43bbd067a0bd828e620
Author: Anoop Sharma <an...@...>
Date:   2018-06-04T17:33:12Z

    TRAFODION-3086 Traf support for DDL operations on Hive objects
    
    -- Support for TRAFODION-3086. Details in document attached to jira.
    
    Other changes:
    -- support for "if not exists", "if exists" clause for create/drop view
    
    -- Support for:  truncate T, truncate table T.
      -- same as purgedata
    
    -- showddl <tab>, detail
    
    -- unregister hive schema <sch>
      -- will unregister all objects in specified schema
    
    -- Support for "if not registered", "if registered" clauss for
       register/unregister command.

----


> 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)