Jinho Kim created TAJO-388:
------------------------------
Summary: 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
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)