[
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 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}
was:
Currently, Tajo doesn't allow date types in IN operator 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 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}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
