Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-1786

TAJO cannot understand DATE type without casting

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • 0.11.0
    • None
    • None

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dkhwangbo Dongkyu Hwangbo
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: