[jira] [Created] (TAJO-1786) TAJO cannot understand DATE type without casting

["Dongkyu Hwangbo (JIRA)" <ji...@apache.org>]

Dongkyu Hwangbo created TAJO-1786:
-------------------------------------

             Summary: TAJO cannot understand DATE type without casting
                 Key: TAJO-1786
                 URL: https://issues.apache.org/jira/browse/TAJO-1786
             Project: Tajo
          Issue Type: Bug
    Affects Versions: 0.11.0
            Reporter: Dongkyu Hwangbo


This is TPC-H q3.

{code:SQL}
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;
{code}

when i enter this query, tajo gives me error message like this.
{noformat}
ERROR: operator does not exist: 'tpch.orders.o_orderdate (DATE) < 1995-03-15'
{noformat}

I replace query from 
{noformat}
O_ORDERDATE < '1995-03-15' AND L_SHIPDATE > '1995-03-15'
{noformat}
to
{noformat}
O_ORDERDATE < '1995-03-15'::date AND L_SHIPDATE > '1995-03-15'::date
{noformat}
then tajo can run query and give me right answer.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)