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 < [email protected]> 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. >
