| ==== |
| ---- QUERY |
| select count(*) from functional.table_no_newline |
| ---- RESULTS |
| 5 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select count(col_3) from functional.table_no_newline |
| ---- RESULTS |
| 5 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select count(*) from functional.table_no_newline_part |
| ---- RESULTS |
| 11 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select count(year) from functional.table_no_newline_part |
| ---- RESULTS |
| 11 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select count(year) from functional.table_no_newline_part where year=2015 |
| ---- RESULTS |
| 6 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select count(col_3) from functional.table_no_newline_part where year=2015 |
| ---- RESULTS |
| 3 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select distinct year from functional.table_no_newline_part order by year |
| ---- RESULTS |
| 2010 |
| 2015 |
| ---- TYPES |
| INT |
| ==== |
| ---- QUERY |
| select count(id), count(col_1), count(col_2), count(col_3), count(year), count(month) from functional.table_no_newline_part |
| ---- RESULTS |
| 10,10,9,8,11,11 |
| ---- TYPES |
| BIGINT,BIGINT,BIGINT,BIGINT,BIGINT,BIGINT |
| ==== |
| ---- QUERY |
| select year, count(*) from functional.table_no_newline_part group by year order by year |
| ---- RESULTS |
| 2010,5 |
| 2015,6 |
| ---- TYPES |
| INT,BIGINT |
| ==== |
| ---- QUERY |
| select year, count(col_3) from functional.table_no_newline_part group by year order by year |
| ---- RESULTS |
| 2010,5 |
| 2015,3 |
| ---- TYPES |
| INT,BIGINT |
| ==== |