====
---- 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
====