You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/10/12 16:48:05 UTC
[jira] [Commented] (TAJO-1922) Allow date types with IN operator
for partition pruning.
[ https://issues.apache.org/jira/browse/TAJO-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14953188#comment-14953188 ]
ASF GitHub Bot commented on TAJO-1922:
--------------------------------------
GitHub user blrunner opened a pull request:
https://github.com/apache/tajo/pull/819
TAJO-1922: Allow date types with IN operator for partition pruning.
The following amendments were.
- Allow Date, Timestamp, Time with IN operator
- Update java.sql.Timestamp to TimestampDatum
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/blrunner/tajo TAJO-1922
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/819.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #819
----
commit 2125d4e7131bc74cae3c03b9232fa5c571eb02b6
Author: JaeHwa Jung <bl...@apache.org>
Date: 2015-10-12T14:42:38Z
TAJO-1922: Allow date types with IN operator for partition pruning.
----
> Allow date types with IN operator 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.11.0, 0.12.0
>
>
> 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)