[
https://issues.apache.org/jira/browse/DRILL-6078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16324863#comment-16324863
]
ASF GitHub Bot commented on DRILL-6078:
---------------------------------------
GitHub user chunhui-shi opened a pull request:
https://github.com/apache/drill/pull/1089
DRILL-6078: support timestamp type to be pushed into MapRDB
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/chunhui-shi/drill work3
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/1089.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 #1089
----
commit 1c2a7c94fcdb56e7e430879b26f1b3e5a5144d11
Author: chunhui-shi <cshi@...>
Date: 2018-01-12T23:14:44Z
DRILL-6078: support timestamp type to be pushed into MapRDB
----
> Query with INTERVAL in predicate does not return any rows
> ---------------------------------------------------------
>
> Key: DRILL-6078
> URL: https://issues.apache.org/jira/browse/DRILL-6078
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.12.0
> Reporter: Robert Hou
> Assignee: Chunhui Shi
>
> This query does not return any rows when accessing MapR DB tables.
> SELECT
> C.C_CUSTKEY,
> C.C_NAME,
> SUM(L.L_EXTENDEDPRICE * (1 - L.L_DISCOUNT)) AS REVENUE,
> C.C_ACCTBAL,
> N.N_NAME,
> C.C_ADDRESS,
> C.C_PHONE,
> C.C_COMMENT
> FROM
> customer C,
> orders O,
> lineitem L,
> nation N
> WHERE
> C.C_CUSTKEY = O.O_CUSTKEY
> AND L.L_ORDERKEY = O.O_ORDERKEY
> AND O.O_ORDERDate >= DATE '1994-03-01'
> AND O.O_ORDERDate < DATE '1994-03-01' + INTERVAL '3' MONTH
> AND L.L_RETURNFLAG = 'R'
> AND C.C_NATIONKEY = N.N_NATIONKEY
> GROUP BY
> C.C_CUSTKEY,
> C.C_NAME,
> C.C_ACCTBAL,
> C.C_PHONE,
> N.N_NAME,
> C.C_ADDRESS,
> C.C_COMMENT
> ORDER BY
> REVENUE DESC
> LIMIT 20
> This query works against JSON tables. It should return 20 rows.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
