| ==== |
| ---- QUERY |
| set max_scan_range_length=0; |
| select c1, c2 from table_with_header |
| ---- RESULTS |
| 1,2 |
| 3,4 |
| 5,6 |
| ---- TYPES |
| INT,DOUBLE |
| ==== |
| ---- QUERY |
| set max_scan_range_length=0; |
| select count(*) from table_with_header |
| ---- RESULTS |
| 3 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| set max_scan_range_length=2; |
| select c1, c2 from table_with_header |
| ---- RESULTS |
| 1,2 |
| 3,4 |
| 5,6 |
| ---- TYPES |
| INT,DOUBLE |
| ==== |
| ---- QUERY |
| set max_scan_range_length=2; |
| select count(*) from table_with_header |
| ---- RESULTS |
| 3 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| set max_scan_range_length=30; |
| select c1, c2 from table_with_header |
| ---- RESULTS |
| 1,2 |
| 3,4 |
| 5,6 |
| ---- TYPES |
| INT,DOUBLE |
| ==== |
| ---- QUERY |
| set max_scan_range_length=30; |
| select count(*) from table_with_header |
| ---- RESULTS |
| 3 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| set max_scan_range_length=0; |
| select c1, c2 from table_with_header_2 |
| ---- RESULTS |
| 1,2 |
| 3,4 |
| 5,6 |
| ---- TYPES |
| INT,DOUBLE |
| ==== |
| ---- QUERY |
| set max_scan_range_length=0; |
| select count(*) from table_with_header_2 |
| ---- RESULTS |
| 3 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # This test is only supported on uncompressed tables, since we always only issue one |
| # single scan range for a compressed file. |
| set max_scan_range_length=2; |
| set abort_on_error=1; |
| select c1, c2 from functional.table_with_header_2 |
| ---- CATCH |
| increasing max_scan_range_length to a value larger than the size of the file's header. |
| ---- TYPES |
| INT,DOUBLE |
| ==== |
| ---- QUERY |
| # This test is only supported on uncompressed tables, since we always only issue one |
| # single scan range for a compressed file. |
| set max_scan_range_length=2; |
| set abort_on_error=0; |
| select c1, c2 from functional.table_with_header_2 |
| ---- CATCH |
| increasing max_scan_range_length to a value larger than the size of the file's header. |
| ---- TYPES |
| INT,DOUBLE |
| ==== |
| ---- QUERY |
| set max_scan_range_length=30; |
| select c1, c2 from table_with_header_2 |
| ---- RESULTS |
| 1,2 |
| 3,4 |
| 5,6 |
| ---- TYPES |
| INT,DOUBLE |
| ==== |
| ---- QUERY |
| set max_scan_range_length=30; |
| select count(*) from table_with_header_2 |
| ---- RESULTS |
| 3 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| drop table if exists $UNIQUE_DB.mixed; |
| create table $UNIQUE_DB.mixed (kf smallint) partitioned by (year smallint) stored as textfile; |
| alter table $UNIQUE_DB.mixed add partition (year=2012); |
| alter table $UNIQUE_DB.mixed add partition (year=2013); |
| alter table $UNIQUE_DB.mixed partition (year=2013) set fileformat parquet; |
| insert into $UNIQUE_DB.mixed partition (year=2012) values (1),(2),(3); |
| insert into $UNIQUE_DB.mixed partition (year=2013) values (4),(5),(6); |
| alter table $UNIQUE_DB.mixed set tblproperties("skip.header.line.count"="1"); |
| alter table $UNIQUE_DB.mixed set fileformat parquet; |
| alter table $UNIQUE_DB.mixed set tblproperties("skip.header.line.count"="2"); |
| select * from $UNIQUE_DB.mixed; |
| ---- RESULTS |
| 3,2012 |
| 4,2013 |
| 5,2013 |
| 6,2013 |
| ---- TYPES |
| SMALLINT,SMALLINT |
| ==== |
| ---- QUERY |
| drop table $UNIQUE_DB.mixed; |
| ==== |