[
https://issues.apache.org/jira/browse/TRAFODION-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16443257#comment-16443257
]
Hans Zeller commented on TRAFODION-3028:
----------------------------------------
For the fix, I am planning to allow both fast_extract() and hive_insert(). Note
that even though EXPLAIN of a Hive insert shows HIVE_INSERT, when doing a
SHOWSHAPE for the same statement that shows fast_extract(). In the fix,
fast_extract() and hive_insert() have the same meaning, both indicate either of
these nodes, which are closely related.
I tried a CQS statement for an unload statement, but that had no effect, since
the unload is just an "ExeUtil" command that prepares an internal query, UNLOAD
EXTRACT, which does the actual work.
My general rule is that I should be able to use the output of a SHOWSHAPE as a
CQS and that I should be able to use the operator name displayed in EXPLAIN in
a CQS. The fix should satisfy both of these for Hive inserts.
> 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)
