This is so odd...
select a.sa, a.sp, a.da, a.dp, subject_name from ( select b.sa, b.sp, b.da, b.dp, CASE WHEN b.tls.SNI[0] is null then '' else b.tls.SNI[0] END as subject_name from `ciscojoy/2017-09-22/*.json` b ) a where subject_name <> '' limit 10 This query works select subject_name from ( select a.sa, a.sp, a.da, a.dp, subject_name from ( select b.sa, b.sp, b.da, b.dp, CASE WHEN b.tls.SNI[0] is null then '' else b.tls.SNI[0] END as subject_name from `ciscojoy/2017-09-22/*.json` b ) a where subject_name <> '' ) x limit 10 Fails with the Error Returned - Code: 500 Error Text: SYSTEM ERROR: NumberFormatException: On Mon, Sep 25, 2017 at 1:40 PM, John Omernik <j...@omernik.com> wrote: > So I think I addressed the first one with > > select CASE when tbl.field.subfield[0] is null then '' else > tbl.field.subfield[0] end as myfield from table as tbl > > That seems to work on small queries > > but when I try to group by myfield I get > > Error Returned - Code: 500 > Error Text: > SYSTEM ERROR: NumberFormatException: > > > > Which I am confused by because '' or the field isn't a number.. so not sure > how to troubleshoot this one either.. > > > John > > > On Mon, Sep 25, 2017 at 1:14 PM, John Omernik <j...@omernik.com> wrote: > >> >> So as a user, I got this >> >> >> Error Returned - Code: 500 >> Error Text: >> SYSTEM ERROR: IllegalArgumentException: You tried to read a [RepeatedInt] >> type when you are using a field reader of type [NullableIntReaderImpl]. >> >> >> It's a JSON dataset, the record exists in some row, and not in others, but I >> have no idea how to interpret this or how to handle it. I feel like we >> should try to curate error messages like this to help improve them for the >> end user. >> >> >> John >> >> >