[
https://issues.apache.org/jira/browse/TRAFODION-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16443378#comment-16443378
]
ASF GitHub Bot commented on TRAFODION-3028:
-------------------------------------------
Github user zellerh commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1525#discussion_r182605678
--- 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 --
Yes, this is for historical reasons. Khaled originally implemented a "fast
extract" operator that would take the output of a query and store it in a
delimited HDFS file.
Later, when we wanted to implement insert into Hive tables, someone
recognized that the fast extract operator did something very similar, so they
enhanced it and internally used it to implement Hive inserts. We could try to
hide this by avoiding the term "FAST_EXTRACT", and in fact this is done in
EXPLAIN, but SHOWSHAPE still shows this heritage.
> 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)
