[jira] [Commented] (TRAFODION-3028) Control query shape (CQS) does not work for Hive insert and unload

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

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

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

GitHub user zellerh opened a pull request:

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

    [TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert

    Adding fast_extract() and hive_insert() CQS operator syntax to be able to force shapes of Hive insert statements.
    
    Example:
    
    control query shape hive_insert(cut);
    explain insert into hive.hive.t values(1,1);
    
    Note: I don't think this fix works for UNLOAD, since that seems to be
    an "ExeUtil" statement that gets executed in two phases.

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

    $ git pull https://github.com/zellerh/trafodion bug/R23a

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

    https://github.com/apache/trafodion/pull/1525.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 #1525
    
----
commit 81fadbc34683b33875892ded7a92d84793cc73c4
Author: Hans Zeller <hz...@...>
Date:   2018-04-18T21:38:03Z

    [TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert
    
    Adding fast_extract() and hive_insert() CQS operator syntax to be able to force shapes of Hive insert statements.
    
    Example:
    
    control query shape hive_insert(cut);
    explain insert into hive.hive.t values(1,1);
    
    Note: I don't think this fix works for UNLOAD, since that seems to be
    an "ExeUtil" statement that gets executed in two phases.

----


> Control query shape (CQS) does not work for Hive insert and unload
> ------------------------------------------------------------------
>
>                 Key: TRAFODION-3028
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3028
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.0-incubating
>            Reporter: Hans Zeller
>            Assignee: Hans Zeller
>            Priority: Major
>             Fix For: 2.3
>
>
> We don't have the right syntax in the CONTROL QUERY SHAPE (CQS) command to force the shape of an insert into a Hive table or an unload statement.
> The shape in a CQS has to start with the top node. For Hive insert or unload, that is a HiveInsert or FastExtract node, which does not yet have a corresponding syntax element in CQS.
> Note that the SHOWSHAPE command already shows what the syntax should (or could) be, this is what showshape displays:
> {noformat}
> control query shape fast_extract(...)
> {noformat}



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