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)

Reply via email to