drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aditya <adityakish...@gmail.com>
Subject Re: Reg: FLATTEN
Date Tue, 03 Mar 2015 08:47:50 GMT
Try

select flatten(fillings) as f
  from dfs.`/Users/philips/Development/BigData/RS/json/test.json` t
  where t.f.cal>300 ;

On Tue, Mar 3, 2015 at 12:25 AM, Jahagirdar, Madhu <
madhu.jahagirdar@philips.com> wrote:

> Ted,
>
> I am getting below error just executing simple statement on flatten, let
> me know if its bug or something I am doing wrong
>
> select flatten(fillings) as f
>   from dfs.`/Users/philips/Development/BigData/RS/json/test.json`
>   where f.cal>300
>   ;
>
> JSON:
> {"name":"classic","fillings":[{"name":"sugar","cal":500}]}
>
> ERROR:
>
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
>
> 0: jdbc:drill:zk=local> select flatten(fillings) as f
>
> . . . . . . . . . . . >   from
> dfs.`/Users/Development/BigData/RS/json/test.json`
>
> . . . . . . . . . . . >   where f.name='sugar'
>
> . . . . . . . . . . . >   ;
>
> Mar 03, 2015 7:47:03 AM org.eigenbase.sql.validate.SqlValidatorException
> <init>
>
> SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table 'f' not
> found
>
> Mar 03, 2015 7:47:03 AM org.eigenbase.util.EigenbaseException <init>
>
> SEVERE: org.eigenbase.util.EigenbaseContextException: At line 3, column 9:
> Table 'f' not found
>
> Query failed: Query failed: Failure validating SQL.
> org.eigenbase.util.EigenbaseContextException: At line 3, column 9: Table
> 'f' not found
>
>
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
>
> Regards,
> Madhu Jahagirdar
>
> ________________________________
> The information contained in this message may be confidential and legally
> protected under applicable law. The message is intended solely for the
> addressee(s). If you are not the intended recipient, you are hereby
> notified that any use, forwarding, dissemination, or reproduction of this
> message is strictly prohibited and may be unlawful. If you are not the
> intended recipient, please contact the sender by return e-mail and destroy
> all copies of the original message.
>

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