[
https://issues.apache.org/jira/browse/TRAFODION-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15397842#comment-15397842
]
ASF GitHub Bot commented on TRAFODION-2047:
-------------------------------------------
GitHub user traflm opened a pull request:
https://github.com/apache/incubator-trafodion/pull/623
[TRAFODION-2047] add support of SQL syntax INTERSECT
support of SQL syntax INTERSECT, INTERSECT DISTINCT
not able to support INTERSECT ALL, which will raise an error.
TPCDS quries only need INTERSECT, and the semantics is same, while two
child input of INTERSECT must have same number of columns and in same order and
each column type must be matching.
Also a minor change to TM Makefile to include log4cxx header file path, if
log4cxx is not installed into system include path.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/traflm/incubator-trafodion TRAFODION-2047-1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/623.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 #623
----
commit 23fe6d5a6c5c9832bf85bb2348bba5d75f91c8ea
Author: Liu Ming <ovis_p...@sina.com>
Date: 2016-07-28T16:58:20Z
[TRAFODION-2047] add support of SQL syntax INTERSECT
----
> add SQL syntax support to INTERSECT
> -----------------------------------
>
> Key: TRAFODION-2047
> URL: https://issues.apache.org/jira/browse/TRAFODION-2047
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: liu ming
> Assignee: liu ming
> Fix For: 2.1-incubating
>
>
> INTERSECT is a common SQL syntax.
> Trafodion should support it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
