You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/12/06 12:36:36 UTC
[jira] [Updated] (TAJO-388) limit clause does not work properly
[ https://issues.apache.org/jira/browse/TAJO-388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyunsik Choi updated TAJO-388:
------------------------------
Attachment: TAJO-388.patch
This is a bug of GlobalPlanner. It's main cause is to set an wrong input schema to a scanner of an execution block. I fixed this bug. I added an unit test to reproduce this problem, and verified 'mvn clean install'.
Thank you for your bug report.
> limit clause does not work properly
> -----------------------------------
>
> Key: TAJO-388
> URL: https://issues.apache.org/jira/browse/TAJO-388
> Project: Tajo
> Issue Type: Bug
> Components: planner/optimizer
> Reporter: Jinho Kim
> Assignee: Hyunsik Choi
> Attachments: TAJO-388.patch
>
>
> The schema does not match.
> {noformat}
> Query: select l_returnflag from lineitem_100 limit 10
>
> Distributed Query Plan
> -------------------------------------------------------------------------------
> Execution Block Graph (TERMINAL - eb_1386296972441_0012_000003)
> -------------------------------------------------------------------------------
> |-eb_1386296972441_0012_000003
> |-eb_1386296972441_0012_000002
> |-eb_1386296972441_0012_000001
> -------------------------------------------------------------------------------
> =======================================================
> Block Id: eb_1386296972441_0012_000001 [LEAF]
> =======================================================
> [Outgoing]
> [q_1386296972441_0012] 1 => 2 (type=HASH_PARTITION, key=, num=1)
> Limit (10)
> "out schema: {lineitem_100.l_returnflag (TEXT(0))}
> "in schema: {lineitem_100.l_returnflag (TEXT(0))}
> "Scan" : {"table":"lineitem_100", "target list": lineitem_100.l_returnflag (TEXT(0)),
> "out schema": {lineitem_100.l_returnflag (TEXT(0))}
> "in schema": {lineitem_100.l_orderkey (INT8(0)),lineitem_100.l_partkey (INT8(0)),lineitem_100.l_suppkey (INT8(0)),lineitem_100.l_linenumber (INT8(0)),lineitem_100.l_quantity (FLOAT8(0)),lineitem_100.l_extendedprice (FLOAT8(0)),lineitem_100.l_discount (FLOAT8(0)),lineitem_100.l_tax (FLOAT8(0)),lineitem_100.l_returnflag (TEXT(0)),lineitem_100.l_linestatus (TEXT(0)),lineitem_100.l_shipdate (TEXT(0)),lineitem_100.l_commitdate (TEXT(0)),lineitem_100.l_receiptdate (TEXT(0)),lineitem_100.l_shipinstruct (TEXT(0)),lineitem_100.l_shipmode (TEXT(0)),lineitem_100.l_comment (TEXT(0))}
> =======================================================
> Block Id: eb_1386296972441_0012_000002 [ROOT]
> =======================================================
> [Incoming]
> [q_1386296972441_0012] 1 => 2 (type=HASH_PARTITION, key=, num=1)
> [Outgoing]
> "Projection": {"targets": ["lineitem_100.l_returnflag (TEXT(0))"],
> "out schema": {lineitem_100.l_returnflag (TEXT(0))},
> "in schema": {lineitem_100.l_returnflag (TEXT(0))}}
> Limit (10)
> "out schema: {lineitem_100.l_returnflag (TEXT(0))}
> "in schema: {lineitem_100.l_returnflag (TEXT(0))}
> "Scan" : {"table":"lineitem_100", "target list": lineitem_100.l_returnflag (TEXT(0)),
> "out schema": {lineitem_100.l_returnflag (TEXT(0))}
> "in schema": {lineitem_100.l_orderkey (INT8(0)),lineitem_100.l_partkey (INT8(0)),lineitem_100.l_suppkey (INT8(0)),lineitem_100.l_linenumber (INT8(0)),lineitem_100.l_quantity (FLOAT8(0)),lineitem_100.l_extendedprice (FLOAT8(0)),lineitem_100.l_discount (FLOAT8(0)),lineitem_100.l_tax (FLOAT8(0)),lineitem_100.l_returnflag (TEXT(0)),lineitem_100.l_linestatus (TEXT(0)),lineitem_100.l_shipdate (TEXT(0)),lineitem_100.l_commitdate (TEXT(0)),lineitem_100.l_receiptdate (TEXT(0)),lineitem_100.l_shipinstruct (TEXT(0)),lineitem_100.l_shipmode (TEXT(0)),lineitem_100.l_comment (TEXT(0))}
> =======================================================
> Block Id: eb_1386296972441_0012_000003 [TERMINAL]
> =======================================================
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.1#6144)