[
https://issues.apache.org/jira/browse/TRAFODION-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16443372#comment-16443372
]
ASF GitHub Bot commented on TRAFODION-3028:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1525#discussion_r182604451
--- Diff: core/sql/common/ExprNode.cpp ---
@@ -737,6 +737,16 @@ NABoolean OperatorType::match(OperatorTypeEnum
wildcard) const
return FALSE;
}
+ case REL_ANY_EXTRACT:
+ switch (op_)
+ {
+ case REL_FAST_EXTRACT:
--- End diff --
It's counterintuitive to me that a Hive Insert (or any Insert) is
considered an Extract. "Extract" to me has the connotation of pulling something
out, while "Insert" to me has the connotation of putting something in. Perhaps
"Extract" in this context is in reference to a Trafodion object? But would a
Hive Insert always be taking data from a Trafodion object? Or might we support
Insert/Select from one Hive object to another?
> 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)
