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:24 UTC
[jira] [Created] (TRAFODION-568) LP Bug: 1359957 - Splitting not
possible with non-salted, single region table that has stats.
Alice Chen created TRAFODION-568:
------------------------------------
Summary: LP Bug: 1359957 - Splitting not possible with non-salted, single region table that has stats.
Key: TRAFODION-568
URL: https://issues.apache.org/jira/browse/TRAFODION-568
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Julie Thai
Assignee: Qifan Chen
Priority: Critical
Fix For: 0.9 (pre-incubation)
>>cqd hbase_partitioning 'system';
--- SQL operation complete.
--non-salted, single partition table with stats
>>explain options 'f' select * from nosalt_1reg_orders order by o_orderkey;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 3.00E+006
. . 1 trafodion_scan NOSALT_1REG_ORDERS 3.00E+006
--- SQL operation complete.
>>cqd hbase_min_bytes_per_esp_partition '10';
--- SQL operation complete.
--non-salted, single partition table with stats
>>explain options 'f' select * from nosalt_1reg_orders order by o_orderkey;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 3.00E+006
. . 1 trafodion_scan NOSALT_1REG_ORDERS 3.00E+006
--- SQL operation complete.
--non-salted, multi-partitioned table with stats
>>explain options 'f' select * from nosalt_mreg_orders order by o_orderkey;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 3.00E+006
. . 1 trafodion_scan NOSALT_MREG_ORDERS 3.00E+006
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)