blob: c57b16cbf763911026486d1e74e5d1c2545e9883 [file] [log] [blame]
>>
>>create hbase table t028tbl1(column family 'cf');
--- SQL operation complete.
>>
>>insert into hbase."_CELL_".t028tbl1 values
+>('0', 'cf', '1a', -1, '2'),
+>('1', 'cf', '1a', -1, '102'),
+>('2', 'cf', '1a', -1, '202'),
+>('3', 'cf', '1a', -1, '302'),
+>('4', 'cf', '1a', -1, '402'),
+>('5', 'cf', '1a', -1, '502'),
+>('6', 'cf', '1a', -1, '602'),
+>('7', 'cf', '1a', -1, '702'),
+>('8', 'cf', '1a', -1, '802');
--- 9 row(s) inserted.
>>
>>exit;
End of MXCI Session
>>
>>cqd USTAT_INTERNAL_SORT 'off';
--- SQL operation complete.
>>update statistics for table hbase."_CELL_".t028tbl1 on every column;
--- SQL operation complete.
>>showstats for table hbase."_CELL_".t028tbl1 on ROW_ID detail;
Detailed Histogram data for Table HBASE."_CELL_".T028TBL1
Table ID: 378379789629904219
Hist ID: 2022909903
Column(s): ROW_ID
Total Rows: 9
Total UEC: 9
Low Value: ('0')
High Value: ('8')
Intervals: 9
Number Rowcount UEC Boundary
====== =========== =========== ======================================
0 0 0 ('0')
1 1 1 ('0')
2 1 1 ('1')
3 1 1 ('2')
4 1 1 ('3')
5 1 1 ('4')
6 1 1 ('5')
7 1 1 ('6')
8 1 1 ('7')
9 1 1 ('8')
--- SQL operation complete.
>>
>>explain options 'f' select * from hbase."_CELL_".t028tbl1;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 9.00E+000
. . 1 hbase_scan T028TBL1 9.00E+000
--- SQL operation complete.
>>explain options 'f' select * from hbase."_CELL_".t028tbl1 where col_family = 'cf1';
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root 9.00E+000
. . 1 hbase_scan T028TBL1 9.00E+000
--- SQL operation complete.
>>
>>drop hbase table t028tbl1;
--- SQL operation complete.
>>exit;
End of MXCI Session