[
https://issues.apache.org/jira/browse/TAJO-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jaehwa Jung updated TAJO-1922:
------------------------------
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:
{code:xml}
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
{code}
was:
Currently, Tajo doesn't allow date types in row constant for partition pruning.
If users execute IN operator with partitioned table, users will fail to execute
their query as following:
{code:xml}
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
{code}
> Allow date types in row constant for partition pruning.
> -------------------------------------------------------
>
> Key: TAJO-1922
> URL: https://issues.apache.org/jira/browse/TAJO-1922
> Project: Tajo
> Issue Type: Sub-task
> Components: Catalog
> Affects Versions: 0.11.0, 0.12.0
> Reporter: Jaehwa Jung
> Assignee: Jaehwa Jung
> Fix For: 0.12.0, 0.11.1
>
>
> 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:
> {code:xml}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
