Hi guys, I have a table:
CREATE TABLE clb_occ(classification_id STRING, taxon_concept_id STRING, taxon_name_id STRING, kingdom_concept_id STRING, phylum_concept_id STRING, class_concept_id STRING, order_concept_id STRING, family_concept_id STRING, genus_concept_id STRING, species_concept_id STRING, nub_concept_id STRING, occurrence_ids ARRAY<STRING>); Can I issue a select for rows where the occurrence_ids contain a value? e.g. something like select * from clb_occ where occurrence_ids contains(1909); What is the syntax please if this is possible? Thanks Tim
