| ==== |
| ---- QUERY |
| -- Test hash partitioning |
| create table simple_hash (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by hash(id) partitions 4, |
| hash(name) partitions 2 stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats simple_hash |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'','0000000000000001',regex:.*?:\d+,3 |
| -1,'0000000000000001','00000001',regex:.*?:\d+,3 |
| -1,'00000001','0000000100000001',regex:.*?:\d+,3 |
| -1,'0000000100000001','00000002',regex:.*?:\d+,3 |
| -1,'00000002','0000000200000001',regex:.*?:\d+,3 |
| -1,'0000000200000001','00000003',regex:.*?:\d+,3 |
| -1,'00000003','0000000300000001',regex:.*?:\d+,3 |
| -1,'0000000300000001','',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test single column range partitioning with bounded and unbounded partitions |
| create table range_part_bounds (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by range (id) |
| (partition values <= 10, partition 10 < values <= 20, partition 20 < values) |
| stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats range_part_bounds |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'','8000000B',regex:.*?:\d+,3 |
| -1,'8000000B','80000015',regex:.*?:\d+,3 |
| -1,'80000015','',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test single column range partitioning with single value partitions |
| create table range_part_single (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by range (id) |
| (partition value = 1, partition value = 10, partition value = 100) |
| stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats range_part_single |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'80000001','80000002',regex:.*?:\d+,3 |
| -1,'8000000A','8000000B',regex:.*?:\d+,3 |
| -1,'80000064','80000065',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test single column range partitioning with bounded, unbounded and single |
| -- value partitions |
| create table range_part_multiple_bounds (id int, name string, valf float, |
| primary key (id, name)) partition by range (id) |
| (partition values <= 10, partition 10 < values <= 20, partition 20 < values <= 30, |
| partition value = 40, partition value = 50) stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats range_part_multiple_bounds |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'','8000000B',regex:.*?:\d+,3 |
| -1,'8000000B','80000015',regex:.*?:\d+,3 |
| -1,'80000015','8000001F',regex:.*?:\d+,3 |
| -1,'80000028','80000029',regex:.*?:\d+,3 |
| -1,'80000032','80000033',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test multiple column range partitioning |
| create table range_part_multiple_cols (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by range (id, name) |
| (partition value = (10, 'martin'), partition value = (20, 'dimitris'), |
| partition value = (30, 'matthew')) stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| -- Test printing of multiple column range partitioning |
| show range partitions range_part_multiple_cols |
| ---- RESULTS |
| 'VALUE = (10, "martin")' |
| 'VALUE = (20, "dimitris")' |
| 'VALUE = (30, "matthew")' |
| ==== |
| ---- QUERY |
| show table stats range_part_multiple_cols |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'8000000A6D617274696E','8000000A6D617274696E00',regex:.*?:\d+,3 |
| -1,'8000001464696D6974726973','8000001464696D697472697300',regex:.*?:\d+,3 |
| -1,'8000001E6D617474686577','8000001E6D61747468657700',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test single column range partitioning with string partition column |
| create table range_part_single_string_col (id int, name string, valf float, |
| primary key (id, name)) partition by range(name) |
| (partition values <= 'aaa', partition 'aaa' < values <= 'bbb', |
| partition 'bbb' < values <= 'ccc', partition value = 'ddd') stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats range_part_single_string_col |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'','61616100',regex:.*?:\d+,3 |
| -1,'61616100','62626200',regex:.*?:\d+,3 |
| -1,'62626200','63636300',regex:.*?:\d+,3 |
| -1,'646464','64646400',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test hash and range partitioning |
| create table simple_hash_range (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by hash(id) partitions 4, range(id, name) |
| (partition value = (10, 'martin'), partition value = (20, 'alex')) stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats simple_hash_range |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'000000008000000A6D617274696E','000000008000000A6D617274696E00',regex:.*?:\d+,3 |
| -1,'0000000080000014616C6578','0000000080000014616C657800',regex:.*?:\d+,3 |
| -1,'000000018000000A6D617274696E','000000018000000A6D617274696E00',regex:.*?:\d+,3 |
| -1,'0000000180000014616C6578','0000000180000014616C657800',regex:.*?:\d+,3 |
| -1,'000000028000000A6D617274696E','000000028000000A6D617274696E00',regex:.*?:\d+,3 |
| -1,'0000000280000014616C6578','0000000280000014616C657800',regex:.*?:\d+,3 |
| -1,'000000038000000A6D617274696E','000000038000000A6D617274696E00',regex:.*?:\d+,3 |
| -1,'0000000380000014616C6578','0000000380000014616C657800',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| create table simple_hash_range_ctas |
| primary key (id, name) partition by hash(id) partitions 4, |
| range(id, name) (partition value = (10, 'casey'), partition value = (20, 'marcel')) |
| stored as kudu |
| as select * from simple_hash |
| ---- RESULTS |
| 'Inserted 0 row(s)' |
| ==== |
| ---- QUERY |
| show table stats simple_hash_range_ctas |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'000000008000000A6361736579','000000008000000A636173657900',regex:.*?:\d+,3 |
| -1,'00000000800000146D617263656C','00000000800000146D617263656C00',regex:.*?:\d+,3 |
| -1,'000000018000000A6361736579','000000018000000A636173657900',regex:.*?:\d+,3 |
| -1,'00000001800000146D617263656C','00000001800000146D617263656C00',regex:.*?:\d+,3 |
| -1,'000000028000000A6361736579','000000028000000A636173657900',regex:.*?:\d+,3 |
| -1,'00000002800000146D617263656C','00000002800000146D617263656C00',regex:.*?:\d+,3 |
| -1,'000000038000000A6361736579','000000038000000A636173657900',regex:.*?:\d+,3 |
| -1,'00000003800000146D617263656C','00000003800000146D617263656C00',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test hash defaults to all columns |
| create table simple_hash_all_columns (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by hash partitions 4 stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats simple_hash_all_columns |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'','00000001',regex:.*?:\d+,3 |
| -1,'00000001','00000002',regex:.*?:\d+,3 |
| -1,'00000002','00000003',regex:.*?:\d+,3 |
| -1,'00000003','',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test range defaults to all columns |
| create table simple_range_all_columns (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by range |
| (partition value = (1, 'a'), partition value = (2, 'b')) |
| stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats simple_range_all_columns |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'8000000161','800000016100',regex:.*?:\d+,3 |
| -1,'8000000262','800000026200',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test using non-literal constant values in range-partition bounds |
| create table range_complex_const_boundary_vals (x int, y int, primary key (x)) |
| partition by range (x) (partition values < 1 + 1, partition (1+3) + 2 < values < 10, |
| partition factorial(4) < values < factorial(5), partition value = factorial(6)) |
| stored as kudu |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| show table stats range_complex_const_boundary_vals |
| ---- LABELS |
| # Rows,Start Key,Stop Key,Leader Replica,# Replicas |
| ---- RESULTS |
| -1,'','80000002',regex:.*?:\d+,3 |
| -1,'80000007','8000000A',regex:.*?:\d+,3 |
| -1,'80000019','80000078',regex:.*?:\d+,3 |
| -1,'800002D0','800002D1',regex:.*?:\d+,3 |
| ---- TYPES |
| INT,STRING,STRING,STRING,INT |
| ==== |
| ---- QUERY |
| -- Test range partitioning with overlapping partitions |
| create table simple_range_with_overlapping (id int, name string, valf float, vali bigint, |
| primary key (id, name)) partition by range (id) |
| (partition values <= 10, partition values < 20, partition value = 5) stored as kudu |
| ---- CATCH |
| NonRecoverableException: overlapping range partitions: first range partition: VALUES < 11, second range partition: VALUES < 20 |
| ==== |
| ---- QUERY |
| -- Test range partitioning with the same partition specified multiple times |
| create table simple_range_duplicate_parts (id int, name string, valf float, vali bigint, |
| primary key(id, name)) partition by range (id) |
| (partition 10 < values <= 20, partition 10 < values <= 20) stored as kudu |
| ---- CATCH |
| NonRecoverableException: overlapping range partitions: first range partition: 11 <= VALUES < 21, second range partition: 11 <= VALUES < 21 |
| ==== |
| ---- QUERY |
| -- Test multi-column range partitioning with the same partition specified multiple times |
| create table range_multi_col_duplicate_parts (id int, name string, valf float, |
| vali bigint, primary key (id, name)) partition by range (id, name) |
| (partition value = (10, 'dimitris'), partition value = (10, 'dimitris')) stored as kudu |
| ---- CATCH |
| NonRecoverableException: overlapping range partitions: first range partition: (10, "dimitris") <= VALUES < (10, "dimitris\000"), second range partition: (10, "dimitris") <= VALUES < (10, "dimitris\000") |
| ==== |
