Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-744 (Umbrella) ALTER TABLE ADD/DROP PARTITION statement
  3. TAJO-1922

Allow date types with IN operator for partition pruning.

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.12.0
    • Fix Version/s: 0.12.0
    • Component/s: Catalog, Planner/Optimizer
    • Labels:
      None

      Description

      Currently, Tajo doesn't allow date types with IN operator for partition pruning. If users execute date types with IN operator with partitioned table, users will fail to execute their query as following:

      tpch_partition> \d lineitem
      
      table name: tpch_partition.lineitem
      table uri: hdfs://localhost:9010/tajo/warehouse/tpch_partition/lineitem
      store type: TEXT
      number of rows: 0
      volume: 696.5 MB
      Options: 
      	'transient_lastDdlTime'='1441266430'
      	'text.null'='\\N'
      	'text.delimiter'='|'
      
      schema: 
      l_orderkey	INT8
      l_partkey	INT8
      l_suppkey	INT8
      l_linenumber	INT8
      l_quantity	FLOAT8
      l_extendedprice	FLOAT8
      l_discount	FLOAT8
      l_tax	FLOAT8
      l_returnflag	TEXT
      l_linestatus	TEXT
      l_commitdate	DATE
      l_receiptdate	DATE
      l_shipinstruct	TEXT
      l_shipmode	TEXT
      l_comment	TEXT
      
      Partitions: 
      type:COLUMN
      columns::tpch_partition.lineitem.l_shipdate (DATE)
      
      tpch_partition> select l_shipdate, count(*) from lineitem where l_shipdate in ( to_date('1992-01-02', 'YYYY-MM-DD') 
      >  ,  to_date('1992-02-24', 'YYYY-MM-DD')) group by l_shipdate;
      ERROR: internal error: Unsupported type: DATE
      

        Attachments

          Activity

            People

            • Assignee:
              blrunner Jaehwa Jung
              Reporter:
              blrunner Jaehwa Jung
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: