tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyunsik Choi (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (TAJO-388) limit clause does not work properly
Date Fri, 06 Dec 2013 05:25:35 GMT

     [ https://issues.apache.org/jira/browse/TAJO-388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hyunsik Choi reassigned TAJO-388:
---------------------------------

    Assignee: Hyunsik Choi

> 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
>
> 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)

Mime
View raw message