framework/resources/Functional/hive/hive_functions/count1.q

select count(*) from voter_avro where registration='green';