You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2018/02/15 05:28:00 UTC

[jira] [Commented] (TRAFODION-1969) support Oracle's TRUNCATE TABLE syntax

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

Anoop Sharma commented on TRAFODION-1969:
-----------------------------------------

trafodion currently supports 'truncate table' command to truncate hive tables. 

It doesn't support 'truncate table' to remove data from traf tables. For that purgedata need to be used.

Truncate table could be enabled for traf tables.

 

> support Oracle's TRUNCATE TABLE syntax 
> ---------------------------------------
>
>                 Key: TRAFODION-1969
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1969
>             Project: Apache Trafodion
>          Issue Type: Improvement
>            Reporter: liu ming
>            Assignee: liu ming
>            Priority: Major
>
> Oracle 'TRUNCATE TABLE' is used to delete all data for a given table.
> It should be the same command in Trafodion 'purgedata'.
> It will be convenient that Trafodion directly support this syntax.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)