| ==== |
| ---- QUERY |
| select * from avro_decimal_tbl |
| ---- RESULTS |
| 'Tom',234.79 |
| 'Beck',77.34 |
| 'Snow',55.71 |
| 'Mary',4.33 |
| 'Cluck',5.96 |
| 'Tom',12.25 |
| 'Mary',33.33 |
| 'Tom',19.00 |
| 'Beck',3.15 |
| 'Beck',79.90 |
| ---- TYPES |
| STRING, DECIMAL |
| ==== |
| ---- QUERY |
| select name from avro_decimal_tbl |
| ---- RESULTS |
| 'Tom' |
| 'Beck' |
| 'Snow' |
| 'Mary' |
| 'Cluck' |
| 'Tom' |
| 'Mary' |
| 'Tom' |
| 'Beck' |
| 'Beck' |
| ---- TYPES |
| STRING |
| ==== |
| ---- QUERY |
| select count(*) from avro_decimal_tbl |
| ---- RESULTS |
| 10 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select l_shipmode, count(distinct l_quantity), avg(l_extendedprice), max(l_discount), ndv(l_tax) |
| from tpch_avro_snap.lineitem |
| group by l_shipmode |
| ---- RESULTS |
| 'SHIP',50,38267.370378,0.10,9 |
| 'REG AIR',50,38268.410670,0.10,9 |
| 'RAIL',50,38269.811059,0.10,9 |
| 'MAIL',50,38224.291934,0.10,9 |
| 'AIR',50,38299.981696,0.10,9 |
| 'TRUCK',50,38209.826048,0.10,9 |
| 'FOB',50,38246.233625,0.10,9 |
| ---- TYPES |
| STRING,DECIMAL,DECIMAL,DECIMAL,DECIMAL |
| ==== |