Robert Hou created DRILL-6078:
---------------------------------
Summary: 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)
