I conn't tell what is "maprfs with file" ,could you more specific? I'm new to Drill. thanks.
------------------ ???????? ------------------ ??????: "Ramana Inukonda"<[email protected]>; ????????: 2014??5??23??(??????) ????2:48 ??????: "drill-user"<[email protected]>; ????: Re: Have some trouble in querying json files Please substitute maprfs with file if you are using a local file. Regards Ramana On Thursday, May 22, 2014, Ramana Inukonda <[email protected]> wrote: > To Query CSV files. Please use the storage-plugins.json I have provided. > > > > > On Thu, May 22, 2014 at 10:58 PM, ???????? > <[email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> > > wrote: > > I have tried several querying format. Like select * from > "/home/bevin/storage-engines.json"; select * from > `/home/bevin/storage-engines.json`; select * from > '/home/bevin/storage-engines.json'; but error also happened. when I query > another json file , query works. > BTW, How should I config my storage.engines.json file if I want to query > csv files? The configuration of cwiki page by configuring > drill-override.conf file doesn's works. > > > > > ------------------ ???????? ------------------ > ??????: "Neeraja Rentachintala"<[email protected]>; > ????????: 2014??5??23??(??????) ????1:48 > ??????: "drill-user"<[email protected]>; > ????: Re: ?????? ?????? Have some trouble in querying json files > > > > You will need to use back ticks (`) around the file name for the above > error. > Refer to the document below on sample queries. > > https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes#ApacheDrillin10Minutes-QueryingaJSONFile > > > On Thu, May 22, 2014 at 10:42 PM, ???????? <[email protected]> wrote: > > > Sorry. BTW, How should I config my storage.engines.json file if I want to > > query csv files? > > > > > > 0: jdbc:drill:schema> select * from /home/bevin/storage.engines.json; > > java.lang.RuntimeException: parse failed > > at > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:237) > > at > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare_(OptiqPrepareImpl.java:195) > > at > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl.java:168) > > at > > > net.hydromatic.optiq.jdbc.OptiqStatement.parseQuery(OptiqStatement.java:402) > > at > > net.hydromatic.optiq.jdbc.OptiqStatement.execute(OptiqStatement.java:192) > > at sqlline.SqlLine$Commands.execute(SqlLine.java:3825) > > at sqlline.SqlLine$Commands.sql(SqlLine.java:3738) > > at sqlline.SqlLine.dispatch(SqlLine.java:882) > > at sqlline.SqlLine.begin(SqlLine.java:717) > > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460) > > at sqlline.SqlLine.main(SqlLine.java:443) > > Caused by: org.eigenbase.sql.parser.SqlParseException: Encountered "/" at > > line 1, column 15. > > Was expecting one of: > > <IDENTIFIER> ... > > <QUOTED_IDENTIFIER> ... > > <UNICODE_QUOTED_IDENTIFIER> ... > > "LATERAL" ... > > "(" ... > > "UNNEST" ... > > "TABLE" ... > > > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:281) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:44) > > at > org.eigenbase.sql.parser.SqlParser.parseStmt(SqlParser.java:138) > > at > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:235) > > ... 10 more > > Caused by: org.eigenbase.sql.parser.impl.ParseException: Encountered "/" > > at line 1, column 15. > > Was expecting one of: > > <IDENTIFIER> ... > > <QUOTED_IDENTIFIER> ... > > <UNICODE_QUOTED_IDENTIFIER> ... > > "LATERAL" ... > > "(" ... > > "UNNEST" ... > > "TABLE" ... > > > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.generateParseException(SqlParserImpl.java:15443) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImpl.java:15272) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.TableRef(SqlParserImpl.java:1423) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.FromClause(SqlParserImpl.java:1286) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.SqlSelect(SqlParserImpl.java:633) > > at > > org.eigenbase.sql.parser.impl.SqlParserImpl. > > >
