[ https://issues.apache.org/jira/browse/DRILL-6078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pritesh Maker updated DRILL-6078: --------------------------------- Fix Version/s: (was: 1.13.0) 1.14.0 > 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 > Priority: Major > Fix For: 1.14.0 > > > 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 (v7.6.3#76005)