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.LeafQuery(SqlParserImpl.java:399)
at
org.eigenbase.sql.parser.impl.SqlParserImpl.LeafQueryOrExpr(SqlParserImpl.java:2055)
at
org.eigenbase.sql.parser.impl.SqlParserImpl.QueryOrExpr(SqlParserImpl.java:2017)
at
org.eigenbase.sql.parser.impl.SqlParserImpl.OrderedQueryOrExpr(SqlParserImpl.java:377)
at
org.eigenbase.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:573)
at
org.eigenbase.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:599)
at org.eigenbase.sql.parser.SqlParser.parseStmt(SqlParser.java:130)
... 11 more
0: jdbc:drill:schema>
------------------ ???????? ------------------
??????: "Yash Sharma"<[email protected]>;
????????: 2014??5??23??(??????) ????2:04
??????: "drill-user"<[email protected]>;
????: Re: ?????? Have some trouble in querying json files
Hi,
Please try to paste the text error trace directly rather than
screenshots/images.
We are unable to view the images in the mail.
Peace,
Yash
On Fri, May 23, 2014 at 9:32 AM, ???????? <[email protected]> wrote:
>
> ------------------ ???????? ------------------
> *??????:* "Jason Altekruse";<[email protected]>;
> *????????:* 2014??5??22??(??????) ????11:29
> *??????:* "Apache Drill User"<[email protected]>;
> *????:* Re: Have some trouble in querying json files
>
> The image didn't show up for me, do you want to throw it on an image
> hosting service like imgur and post a link?
>
> -Jason Altekruse
>
>
> On Thu, May 22, 2014 at 8:53 AM, ???????? <[email protected]> wrote:
>
> > hi,
> > When I use drill to query json files , error occurs . here is my error
> > report :
> >
> > and my drill storage-engines.json configuration :
> > {
> > "storage":{
> > "parquet-local" :
> > {
> > "type":"parquet",
> > "dfsName" : "file:///"
> > },
> > "parquet-cp" :
> > {
> > "type":"parquet",
> > "dfsName" : "classpath:///"
> > },
> > "jsonl" :
> > {
> > "type":"json",
> > "dfsName" : "hdfs://localhost:9000/user/bevin"
> > },
> > "json-cp" :
> > {
> > "type":"json",
> > "dfsName" : "classpath:///"
> > },
> > "parquet" :
> > {
> > "type":"parquet",
> > "dfsName" : "hdfs://localhost:9000/user/bevin"
> > }
> > }
> > }
> >
> > I also have some trouble in querying csv file. How should I config my
> > drill storage-engines.json file?
> > thanks
> >
>
>
