Names export for OBIS

gistfile1.sql

create table tim.name_export
row format delimited fields terminated by '\t' as
select datasetKey, kingdom, family, scientificName, taxonKey,  count(*) as numRecords
from prod_b.occurrence_hdfs
where 
  datasetKey is not null and 
  kingdom is not null and 
  speciesKey is not null and 
  scientificName is not null and 
  family is not null and 
  taxonKey is not null
group by 
  datasetKey, kingdom, family, scientificName, taxonKey