[TAJO-1786] TAJO cannot understand DATE type without casting

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.11.0
• Labels: sql
• Assignee: Unassigned
• Reporter: Dongkyu Hwangbo
• Created: 19/Aug/15 08:01
• Updated: 19/Aug/15 09:13
• Resolved: 19/Aug/15 09:13

Description

This is TPC-H q3.

SELECT L_ORDERKEY, SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)) AS REVENUE, O_ORDERDATE, O_SHIPPRIORITY
FROM CUSTOMER, ORDERS, LINEITEM
WHERE C_MKTSEGMENT = 'BUILDING' AND C_CUSTKEY = O_CUSTKEY AND L_ORDERKEY = O_ORDERKEY AND
O_ORDERDATE < '1995-03-15' AND L_SHIPDATE > '1995-03-15'
GROUP BY L_ORDERKEY, O_ORDERDATE, O_SHIPPRIORITY
ORDER BY REVENUE DESC, O_ORDERDATE 
limit 10;

when i enter this query, tajo gives me error message like this.

ERROR: operator does not exist: 'tpch.orders.o_orderdate (DATE) < 1995-03-15'

I replace query from

O_ORDERDATE < '1995-03-15' AND L_SHIPDATE > '1995-03-15'

to

O_ORDERDATE < '1995-03-15'::date AND L_SHIPDATE > '1995-03-15'::date

then tajo can run query and give me right answer.