[
https://issues.apache.org/jira/browse/TAJO-1786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongkyu Hwangbo resolved TAJO-1786.
-----------------------------------
Resolution: Not A Problem
I misunderstood overall
> 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
> Labels: sql
>
> 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)
