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

Allow date types with IN operator for partition pruning.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.12.0
    • 0.12.0
    • Catalog, Planner/Optimizer
    • 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

            blrunner JaeHwa Jung
            blrunner JaeHwa Jung
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: