drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jahagirdar, Madhu" <madhu.jahagir...@philips.com>
Subject Reg: FLATTEN
Date Tue, 03 Mar 2015 03:11:54 GMT
All,


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