incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramana Inukonda <rinuko...@maprtech.com>
Subject Re: Have some trouble in querying json files
Date Fri, 23 May 2014 06:48:58 GMT
Please substitute maprfs with file if you are using a local file.

Regards
Ramana

On Thursday, May 22, 2014, Ramana Inukonda <rinukonda@maprtech.com> wrote:

> To Query CSV files. Please use the storage-plugins.json I have provided.
>
>
>
>
> On Thu, May 22, 2014 at 10:58 PM, 南在南方 <i02389@qq.com<javascript:_e(%7B%7D,'cvml','i02389@qq.com');>
> > 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"<nrentachintala@maprtech.com>;
> 发送时间: 2014年5月23日(星期五) 中午1:48
> 收件人: "drill-user"<drill-user@incubator.apache.org>;
> 主题: 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, 南在南方 <i02389@qq.com> 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.
>
>
>

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