| ==== |
| ---- QUERY |
| # Test the default encoding - RLE. |
| # Verify that total counts of non-null values are correct. |
| select count(id), count(tinyint_col), count(smallint_col), count(int_col), |
| count(bigint_col), count(float_col), count(double_col), count(date_string_col), |
| count(string_col), count(timestamp_col), count(year), count(month), count(day) |
| from functional_parquet.alltypesagg |
| ---- TYPES |
| BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT |
| ---- RESULTS |
| 11000,9000,10800,10980,10980,10980,10980,11000,11000,11000,11000,11000,10000 |
| ==== |
| ---- QUERY |
| # Test the default encoding - RLE. Spot-check a subset of values. |
| select * |
| from functional_parquet.alltypesagg |
| where year = 2010 and month = 1 and int_col is null or int_col % 1000 = 77 |
| order by id, year, month, day |
| ---- TYPES |
| INT,BOOLEAN,TINYINT,SMALLINT,INT,BIGINT,FLOAT,DOUBLE,STRING,STRING,TIMESTAMP,INT,INT,INT |
| ---- RESULTS |
| 0,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/01/10','0',2010-01-01 00:00:00,2010,1,1 |
| 0,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/01/10','0',2010-01-01 00:00:00,2010,1,NULL |
| 77,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/01/10','77',2010-01-01 01:17:29.260000000,2010,1,1 |
| 1000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/02/10','0',2010-01-02 00:00:00,2010,1,2 |
| 1000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/02/10','0',2010-01-02 00:00:00,2010,1,NULL |
| 1077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/02/10','77',2010-01-02 01:17:29.260000000,2010,1,2 |
| 2000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/03/10','0',2010-01-03 00:00:00,2010,1,3 |
| 2000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/03/10','0',2010-01-03 00:00:00,2010,1,NULL |
| 2077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/03/10','77',2010-01-03 01:17:29.260000000,2010,1,3 |
| 3000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/04/10','0',2010-01-04 00:00:00,2010,1,4 |
| 3000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/04/10','0',2010-01-04 00:00:00,2010,1,NULL |
| 3077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/04/10','77',2010-01-04 01:17:29.260000000,2010,1,4 |
| 4000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/05/10','0',2010-01-05 00:00:00,2010,1,5 |
| 4000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/05/10','0',2010-01-05 00:00:00,2010,1,NULL |
| 4077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/05/10','77',2010-01-05 01:17:29.260000000,2010,1,5 |
| 5000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/06/10','0',2010-01-06 00:00:00,2010,1,6 |
| 5000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/06/10','0',2010-01-06 00:00:00,2010,1,NULL |
| 5077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/06/10','77',2010-01-06 01:17:29.260000000,2010,1,6 |
| 6000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/07/10','0',2010-01-07 00:00:00,2010,1,7 |
| 6000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/07/10','0',2010-01-07 00:00:00,2010,1,NULL |
| 6077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/07/10','77',2010-01-07 01:17:29.260000000,2010,1,7 |
| 7000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/08/10','0',2010-01-08 00:00:00,2010,1,8 |
| 7000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/08/10','0',2010-01-08 00:00:00,2010,1,NULL |
| 7077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/08/10','77',2010-01-08 01:17:29.260000000,2010,1,8 |
| 8000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/09/10','0',2010-01-09 00:00:00,2010,1,9 |
| 8000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/09/10','0',2010-01-09 00:00:00,2010,1,NULL |
| 8077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/09/10','77',2010-01-09 01:17:29.260000000,2010,1,9 |
| 9000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/10/10','0',2010-01-10 00:00:00,2010,1,10 |
| 9000,true,NULL,NULL,NULL,NULL,NULL,NULL,'01/10/10','0',2010-01-10 00:00:00,2010,1,NULL |
| 9077,false,7,77,77,770,84.69999694824219,777.6999999999999,'01/10/10','77',2010-01-10 01:17:29.260000000,2010,1,10 |
| ==== |
| ---- QUERY |
| # IMPALA-6077: unsupported BIT_PACKED encoding fails when materializing columns. |
| select id |
| from alltypes_agg_bitpacked_def_levels |
| ---- CATCH |
| deprecated BIT_PACKED encoding for rep or def levels. |
| ==== |
| ---- QUERY |
| # IMPALA-6077: do not need to decode BIT_PACKED encoding when not materializing columns. |
| select count(*) |
| from alltypes_agg_bitpacked_def_levels |
| ---- RESULTS |
| 11000 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # IMPALA-6077: in future we could return results for this query from metadata, in which |
| # case it should either work or fail gracefully. For now it still requires materialising |
| # levels. |
| select count(id) |
| from alltypes_agg_bitpacked_def_levels |
| ---- CATCH |
| deprecated BIT_PACKED encoding for rep or def levels. |
| ==== |
| ---- QUERY |
| # IMPALA-6077: in future we could return results for this query from metadata, in which |
| # case it should either work or fail gracefully. For now it still requires materialising |
| # levels. |
| select min(int_col) |
| from alltypes_agg_bitpacked_def_levels |
| ---- CATCH |
| deprecated BIT_PACKED encoding for rep or def levels. |
| ==== |