drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Omernik <j...@omernik.com>
Subject Re: Error Messages that are difficult to parse.
Date Mon, 25 Sep 2017 18:44:24 GMT
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 <john@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 <john@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
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message