Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of nrentachintala@maprtech.com
 designates 209.85.128.174 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <tencent_443A39493B87A803528F4A1A@qq.com>
References: <tencent_131ECEA60202B5DD6E101928@qq.com>
	<CAMpYv7CXvjc74h5pELLR2mRqojk=eMqkP1wP6hmeHXUJoRi-uw@mail.gmail.com>
	<tencent_5E15AA001CF7348052EFDF50@qq.com>
	<CAFi_UEeUju6XcussaWrAqAKgKoUc7Kbqzp697kgiB_Qy9hxgvA@mail.gmail.com>
	<tencent_443A39493B87A803528F4A1A@qq.com>
Date: Thu, 22 May 2014 22:48:41 -0700
Message-ID: 
 <CAH-_v4JZyiV-upD_m1gb=uL+WidYFRXQ74tZT4gQnn--Q2WFqw@mail.gmail.com>
Subject: 
 =?UTF-8?B?UmU6IOWbnuWkje+8miDlm57lpI3vvJogSGF2ZSBzb21lIHRyb3VibGUgaW4gcXVlcnlpbg==?=
	=?UTF-8?B?ZyBqc29uIGZpbGVz?=
From: Neeraja Rentachintala <nrentachintala@maprtech.com>
To: drill-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=047d7b5d5d7e2c165204fa0ac865

--047d7b5d5d7e2c165204fa0ac865
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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+Minute=
s#ApacheDrillin10Minutes-QueryingaJSONFile


On Thu, May 22, 2014 at 10:42 PM, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 <i02=
389@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.j=
ava:195)
>         at
> net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl=
.java:168)
>         at
> net.hydromatic.optiq.jdbc.OptiqStatement.parseQuery(OptiqStatement.java:4=
02)
>         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(SqlParserImp=
l.java:281)
>         at
> org.eigenbase.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserI=
mpl.java:44)
>         at org.eigenbase.sql.parser.SqlParser.parseStmt(SqlParser.java:13=
8)
>         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(SqlPar=
serImpl.java:15443)
>         at
> org.eigenbase.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImp=
l.java:15272)
>         at
> org.eigenbase.sql.parser.impl.SqlParserImpl.TableRef(SqlParserImpl.java:1=
423)
>         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.jav=
a:2017)
>         at
> org.eigenbase.sql.parser.impl.SqlParserImpl.OrderedQueryOrExpr(SqlParserI=
mpl.java:377)
>         at
> org.eigenbase.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:57=
3)
>         at
> org.eigenbase.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java=
:599)
>         at org.eigenbase.sql.parser.SqlParser.parseStmt(SqlParser.java:13=
0)
>         ... 11 more
> 0: jdbc:drill:schema>
>
>
>
>
>
> ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 -----------------=
-
> =E5=8F=91=E4=BB=B6=E4=BA=BA: "Yash Sharma"<yash360@gmail.com>;
> =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8823=E6=97=A5(=
=E6=98=9F=E6=9C=9F=E4=BA=94) =E4=B8=8B=E5=8D=882:04
> =E6=94=B6=E4=BB=B6=E4=BA=BA: "drill-user"<drill-user@incubator.apache.org=
>;
> =E4=B8=BB=E9=A2=98: Re: =E5=9B=9E=E5=A4=8D=EF=BC=9A 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, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 <i0=
2389@qq.com> wrote:
>
> >
> > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 ---------------=
---
> > *=E5=8F=91=E4=BB=B6=E4=BA=BA:* "Jason Altekruse";<altekrusejason@gmail.=
com>;
> > *=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4:* 2014=E5=B9=B45=E6=9C=8822=E6=97=
=A5(=E6=98=9F=E6=9C=9F=E5=9B=9B) =E6=99=9A=E4=B8=8A11:29
> > *=E6=94=B6=E4=BB=B6=E4=BA=BA:* "Apache Drill User"<drill-user@incubator=
.apache.org>;
> > *=E4=B8=BB=E9=A2=98:* 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, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 <=
i02389@qq.com> wrote:
> >
> > > hi,
> > > When I use drill to query json files , error occurs . here is my erro=
r
> > > 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
> > >
> >
> >
>

--047d7b5d5d7e2c165204fa0ac865--