[
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 <hzeller@...>
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)
