gistfile1.txt

[ve0130.halxg.cloudera.com:21000] > show column stats ycsb_todd;
Query: show column stats ycsb_todd
+--------+--------+------------------+--------+----------+------------------+
| Column | Type   | #Distinct Values | #Nulls | Max Size | Avg Size         |
+--------+--------+------------------+--------+----------+------------------+
| key    | STRING | 10000000         | -1     | 23       | 22.8794994354248 |
| field0 | STRING | 10000000         | -1     | 100      | 100              |
| field1 | STRING | 10000000         | -1     | 100      | 100              |
| field2 | STRING | 10000000         | -1     | 100      | 100              |
| field3 | STRING | 10000000         | -1     | 100      | 100              |
| field4 | STRING | 10000000         | -1     | 100      | 100              |
| field5 | STRING | 10000000         | -1     | 100      | 100              |
| field6 | STRING | 9919978          | -1     | 100      | 100              |
| field7 | STRING | 10000000         | -1     | 100      | 100              |
| field8 | STRING | 9960544          | -1     | 100      | 100              |
| field9 | STRING | 9845609          | -1     | 100      | 100              |
+--------+--------+------------------+--------+----------+------------------+
Fetched 11 row(s) in 0.01s
[ve0130.halxg.cloudera.com:21000] > alter table ycsb_todd set column stats field4 ('numdvs'='100000');
Query: alter table ycsb_todd set column stats field4 ('numdvs'='100000')
+-----------------------------------------+
| summary                                 |
+-----------------------------------------+
| Updated 0 partition(s) and 1 column(s). |
+-----------------------------------------+
Fetched 1 row(s) in 0.23s
[ve0130.halxg.cloudera.com:21000] > explain select count(*) from ycsb_todd where field4 = 'x' and field5 = 'y';
Query: explain select count(*) from ycsb_todd where field4 = 'x' and field5 = 'y'
+------------------------------------------------+
| Explain String                                 |
+------------------------------------------------+
| Max Per-Host Resource Reservation: Memory=0B   |
| Per-Host Resource Estimates: Memory=20.00MB    |
|                                                |
| PLAN-ROOT SINK                                 |
| |                                              |
| 03:AGGREGATE [FINALIZE]                        |
| |  output: count:merge(*)                      |
| |                                              |
| 02:EXCHANGE [UNPARTITIONED]                    |
| |                                              |
| 01:AGGREGATE                                   |
| |  output: count(*)                            |
| |                                              |
| 00:SCAN KUDU [default.ycsb_todd]               |
|    kudu predicates: field5 = 'y', field4 = 'x' |
+------------------------------------------------+
Fetched 15 row(s) in 0.05s
[ve0130.halxg.cloudera.com:21000] > alter table ycsb_todd set column stats field4 ('numdvs'='10000000000');
Query: alter table ycsb_todd set column stats field4 ('numdvs'='10000000000')
+-----------------------------------------+
| summary                                 |
+-----------------------------------------+
| Updated 0 partition(s) and 1 column(s). |
+-----------------------------------------+
Fetched 1 row(s) in 0.21s
[ve0130.halxg.cloudera.com:21000] > explain select count(*) from ycsb_todd where field4 = 'x' and field5 = 'y';
Query: explain select count(*) from ycsb_todd where field4 = 'x' and field5 = 'y'
+------------------------------------------------+
| Explain String                                 |
+------------------------------------------------+
| Max Per-Host Resource Reservation: Memory=0B   |
| Per-Host Resource Estimates: Memory=20.00MB    |
|                                                |
| PLAN-ROOT SINK                                 |
| |                                              |
| 03:AGGREGATE [FINALIZE]                        |
| |  output: count:merge(*)                      |
| |                                              |
| 02:EXCHANGE [UNPARTITIONED]                    |
| |                                              |
| 01:AGGREGATE                                   |
| |  output: count(*)                            |
| |                                              |
| 00:SCAN KUDU [default.ycsb_todd]               |
|    kudu predicates: field4 = 'x', field5 = 'y' |
+------------------------------------------------+
Fetched 15 row(s) in 0.03s