| ==== |
| ---- QUERY |
| create table alltypessmall_hbase like functional_hbase.alltypessmall |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| compute incremental stats alltypessmall_hbase |
| ---- RESULTS |
| 'Updated 1 partition(s) and 13 column(s).' |
| ---- TYPES |
| STRING |
| ==== |
| ---- QUERY |
| show table stats alltypessmall_hbase |
| ---- LABELS |
| REGION LOCATION, START ROWKEY, EST. #ROWS, SIZE |
| ---- RESULTS: VERIFY_IS_EQUAL |
| regex:.+,'',regex:.+,regex:.+B |
| regex:.+,'1',regex:.+,regex:.+B |
| regex:.+,'3',regex:.+,regex:.+B |
| regex:.+,'5',regex:.+,regex:.+B |
| regex:.+,'7',regex:.+,regex:.+B |
| regex:.+,'9',regex:.+,regex:.+B |
| 'Total','',regex:.+,regex:.+B |
| ---- TYPES |
| STRING, STRING, BIGINT, STRING |
| ==== |
| ---- QUERY |
| show column stats alltypessmall_hbase |
| ---- LABELS |
| COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE |
| ---- RESULTS |
| 'id','INT',99,0,4,4 |
| 'bigint_col','BIGINT',10,0,8,8 |
| 'bool_col','BOOLEAN',2,0,1,1 |
| 'date_string_col','STRING',12,0,8,8 |
| 'double_col','DOUBLE',10,0,8,8 |
| 'float_col','FLOAT',10,0,4,4 |
| 'int_col','INT',10,0,4,4 |
| 'month','INT',4,0,4,4 |
| 'smallint_col','SMALLINT',10,0,2,2 |
| 'string_col','STRING',10,0,1,1 |
| 'timestamp_col','TIMESTAMP',100,0,16,16 |
| 'tinyint_col','TINYINT',10,0,1,1 |
| 'year','INT',1,0,4,4 |
| ---- TYPES |
| STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE |
| ==== |
| ---- QUERY |
| create table date_tbl_hbase like functional_hbase.date_tbl |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| compute incremental stats date_tbl_hbase |
| ---- RESULTS |
| 'Updated 1 partition(s) and 3 column(s).' |
| ---- TYPES |
| STRING |
| ==== |
| ---- QUERY |
| show table stats date_tbl_hbase |
| ---- LABELS |
| REGION LOCATION, START ROWKEY, EST. #ROWS, SIZE |
| ---- RESULTS: VERIFY_IS_EQUAL |
| regex:.+,'',regex:.+,regex:.+B |
| regex:.+,'1',regex:.+,regex:.+B |
| regex:.+,'3',regex:.+,regex:.+B |
| regex:.+,'5',regex:.+,regex:.+B |
| regex:.+,'7',regex:.+,regex:.+B |
| regex:.+,'9',regex:.+,regex:.+B |
| 'Total','',regex:.+,regex:.+B |
| ---- TYPES |
| STRING, STRING, BIGINT, STRING |
| ==== |
| ---- QUERY |
| show column stats date_tbl_hbase |
| ---- LABELS |
| COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE |
| ---- RESULTS |
| 'id_col','INT',22,0,4,4 |
| 'date_col','DATE',16,2,4,4 |
| 'date_part','DATE',4,0,4,4 |
| ---- TYPES |
| STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE |
| ==== |