You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:52 UTC
[jira] [Created] (TRAFODION-703) LP Bug: 1383581 - Serial plan
generated for salt table after toggling cqds HBASE_HASH2_PARTITIONING and
HBASE_RANGE_PARTITIONING
Alice Chen created TRAFODION-703:
------------------------------------
Summary: LP Bug: 1383581 - Serial plan generated for salt table after toggling cqds HBASE_HASH2_PARTITIONING and HBASE_RANGE_PARTITIONING
Key: TRAFODION-703
URL: https://issues.apache.org/jira/browse/TRAFODION-703
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Julie Thai
Assignee: Qifan Chen
Priority: Critical
On cluster with daily build 20141014_0830:
In sqlci, with default cqd values for HBASE_HASH2_PARTITIONING & HBASE_RANGE_PARTITIONING, query of salt table produces parallel plan with hash2 partitioning. Setting cqds HBASE_HASH2_PARTITIONING & HBASE_RANGE_PARTITIONING to 'off', produces serial query plan. Subsequently, if cqds are reset and set to 'on', serial plan is still produced, whereas a parallel plan with hash2 partitioning is expected.
>>cqd query_cache '0';
--- SQL operation complete.
>>
>>--expect parallel plan with hash2 partitioning
>>prepare XX from select * from g_tpch2x.orders where o_orderkey < 300000;
--- SQL command prepared.
>>explain options 'f' XX;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
2 . 3 root 7.52E+004
1 . 2 esp_exchange 1:4(hash2) 7.52E+004
. . 1 trafodion_scan ORDERS 7.52E+004
--- SQL operation complete.
>>
>>--expect parallel plan with range partitioning
>>cqd HBASE_HASH2_PARTITIONING 'OFF';
--- SQL operation complete.
>>showcontrol default;
CONTROL QUERY DEFAULT
SHOWCONTROL_SHOW_ALL ON
QUERY_CACHE 0
HBASE_HASH2_PARTITIONING OFF
--- SQL operation complete.
>>prepare XX from select * from g_tpch2x.orders where o_orderkey < 300000;
--- SQL command prepared.
>>explain options 'f' XX;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
2 . 3 root 7.52E+004
1 . 2 esp_exchange 1:6(range) 7.52E+004
. . 1 trafodion_scan ORDERS 7.52E+004
--- SQL operation complete.
>>
>>--expect parallel plan with hash2 partitioning
>>cqd HBASE_HASH2_PARTITIONING 'ON';
--- SQL operation complete.
>>showcontrol default;
CONTROL QUERY DEFAULT
SHOWCONTROL_SHOW_ALL ON
QUERY_CACHE 0
HBASE_HASH2_PARTITIONING ON
--- SQL operation complete.
>>prepare XX from select * from g_tpch2x.orders where o_orderkey < 300000;
--- SQL command prepared.
>>explain options 'f' XX;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
2 . 3 root 7.52E+004
1 . 2 esp_exchange 1:4(hash2) 7.52E+004
. . 1 trafodion_scan ORDERS 7.52E+004
--- SQL operation complete.
>>
>>--expect serial plan
>>cqd HBASE_HASH2_PARTITIONING 'OFF';
--- SQL operation complete.
>>cqd HBASE_RANGE_PARTITIONING 'OFF';
--- SQL operation complete.
>>showcontrol default;
CONTROL QUERY DEFAULT
SHOWCONTROL_SHOW_ALL ON
QUERY_CACHE 0
HBASE_HASH2_PARTITIONING OFF
HBASE_RANGE_PARTITIONING OFF
--- SQL operation complete.
>>prepare XX from select * from g_tpch2x.orders where o_orderkey < 300000;
--- SQL command prepared.
>>explain options 'f' XX;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 7.52E+004
. . 1 trafodion_scan ORDERS 7.52E+004
--- SQL operation complete.
>>
>>--expect parallel plan with hash2 partitioning
>>cqd HBASE_HASH2_PARTITIONING 'ON';
--- SQL operation complete.
>>cqd HBASE_RANGE_PARTITIONING 'ON';
--- SQL operation complete.
>>showcontrol default;
CONTROL QUERY DEFAULT
SHOWCONTROL_SHOW_ALL ON
QUERY_CACHE 0
HBASE_HASH2_PARTITIONING ON
HBASE_RANGE_PARTITIONING ON
--- SQL operation complete.
>>prepare XX from select * from g_tpch2x.orders where o_orderkey < 300000;
--- SQL command prepared.
>>explain options 'f' XX;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 7.52E+004
. . 1 trafodion_scan ORDERS 7.52E+004
--- SQL operation complete.
To reproduce:
1. extract attachment, repo_cases.tar.
2. in sqlci, obey case[1-5].sql
Attachment contains logs generated on cluster with daily build 20141014_0830.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)