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 Tue, 26 Sep 2017 19:58:46 GMT
Hmm, I updated my data set and cleared the offending data by accident. Now
it's not reproducing the issue. I will keep an I out for it...

On Mon, Sep 25, 2017 at 1:54 PM, Kunal Khatua <kkhatua@mapr.com> wrote:

> Not sure what is going on, but my hunch is that the outermost wrapping SQL
> is probably using the final projections to eliminate some of the columns
> early on, which "helps" avoid the NumberFormat exception.
>
> Perhaps adding back the other columns, one by one, should narrow down the
> source of the NumberFormatException.
>
> I think this is a simple but important bug, since it seems we don't know
> which column is triggering the Exception. In case there isn't an existing
> bug, could you file one for this?
>
>
>
> -----Original Message-----
> From: John Omernik [mailto:john@omernik.com]
> Sent: Monday, September 25, 2017 11:44 AM
> To: user <user@drill.apache.org>
> Subject: Re: Error Messages that are difficult to parse.
>
> 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