In the storage plugins file I sent replace the maprfs:/// with file:/// Regards Ramana
On Thursday, May 22, 2014, 南在南方 <[email protected]> wrote: > I conn't tell what is "maprfs with file" ,could you more specific? I'm new > to Drill. thanks. > > > > > ------------------ 原始邮件 ------------------ > 发件人: "Ramana Inukonda"<[email protected] <javascript:;>>; > 发送时间: 2014年5月23日(星期五) 下午2:48 > 收件人: "drill-user"<[email protected] <javascript:;>>; > 主题: 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]<javascript:;>> > 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:;> > <javascript:_e(%7B%7D,'cvml','[email protected] <javascript:;>');> > > > 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> ... >
