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 2016/06/02 15:11:00 UTC

[jira] [Commented] (TRAFODION-2022) add support for purgedata command to remove hive data

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

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

GitHub user anoopsharma00 opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/516

    JIRA TRAFODION-2022 Add support for purgedata of hive tables

    In addition to purgedata:
    -- showplan correctly shows aqr setting
    -- data modification check is skipped during insert if overwrite
       option was used

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/anoopsharma00/incubator-trafodion ansharma_hivets_br

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/516.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 #516
    
----
commit c8a6187f08d8bcb0074630b2e30fea723c53733c
Author: Anoop Sharma <an...@esgyn.com>
Date:   2016-06-02T14:52:21Z

    JIRA TRAFODION-2022 Add support for purgedata of hive tables
    
    In addition to purgedata:
    -- showplan correctly shows aqr setting
    -- data modification check is skipped during insert if overwrite
       option was used

----


> add support for purgedata command to remove hive data
> -----------------------------------------------------
>
>                 Key: TRAFODION-2022
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2022
>             Project: Apache Trafodion
>          Issue Type: New Feature
>            Reporter: Anoop Sharma
>            Assignee: Anoop Sharma
>            Priority: Minor
>
> purgedata is a trafodion command which removes data from
> tables. It is supported for trafodion tables.
> >>purgedata trafodion.sch.t1;
> --- SQL operation complete.
> >>
> This JIRA is to add support for purgedata for hive tables.
> Currently an error is returned when this command is issued.
> >>purgedata hive.hive.thive;
> *** WARNING[4222] The DDL feature is not supported in this software version.
> *** WARNING[8822] The statement was not prepared.
> *** ERROR[15001] A syntax error occurred at or before: 
> purgedata hive.hive.thive;
>                          ^ (26 characters from start of SQL statement)
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)