[
https://issues.apache.org/jira/browse/TRAFODION-2117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15410426#comment-15410426
]
ASF GitHub Bot commented on TRAFODION-2117:
-------------------------------------------
Github user traflm commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/639#discussion_r73779962
--- Diff: core/sql/optimizer/RelExpr.cpp ---
@@ -6630,6 +6630,23 @@ const NAString Intersect::getText() const
}
// -----------------------------------------------------------------------
+// // member functions for class Except
+// //
-----------------------------------------------------------------------
+Except::Except(RelExpr *leftChild,
+ RelExpr *rightChild)
+: RelExpr(REL_EXCEPT, leftChild, rightChild)
+{ setNonCacheable(); }
--- End diff --
I don't know either, but SET operations like UNION is also set as non
cacheable. So I feel we should keep it now. I will try to study more on this
later.
showshape works:
>>showshape select eno,ename,dno from t021 except select * from t022;
I
control query shape hybrid_hash_join(scan(path 'TRAFODION.SEABASE.T021',
forward, blocks_per_access 1 , mdam off),
scan(path 'TRAFODION.SEABASE.T022', forward, blocks_per_access 1
, mdam off));
--- SQL operation complete.
>>
> add support of SQL extension 'EXCEPT'
> --------------------------------------
>
> Key: TRAFODION-2117
> URL: https://issues.apache.org/jira/browse/TRAFODION-2117
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: liu ming
> Assignee: liu ming
>
> add syntax and basic functional support for 'EXCEPT', meet the requirement to
> run TPCDS as initial goal.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
