Return-Path: X-Original-To: apmail-incubator-drill-user-archive@minotaur.apache.org Delivered-To: apmail-incubator-drill-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8FA38114E9 for ; Fri, 23 May 2014 15:36:53 +0000 (UTC) Received: (qmail 72923 invoked by uid 500); 23 May 2014 15:36:50 -0000 Delivered-To: apmail-incubator-drill-user-archive@incubator.apache.org Received: (qmail 72871 invoked by uid 500); 23 May 2014 15:36:50 -0000 Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: drill-user@incubator.apache.org Delivered-To: mailing list drill-user@incubator.apache.org Received: (qmail 72858 invoked by uid 99); 23 May 2014 15:36:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 May 2014 15:36:50 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of altekrusejason@gmail.com designates 209.85.216.181 as permitted sender) Received: from [209.85.216.181] (HELO mail-qc0-f181.google.com) (209.85.216.181) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 May 2014 15:36:46 +0000 Received: by mail-qc0-f181.google.com with SMTP id m20so8263874qcx.26 for ; Fri, 23 May 2014 08:36:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=AZ9XAd54MvuE+1zxIUa2rWze5HZ/x85UbBabm0fg4YQ=; b=bfueN/esCgHv/SDZ2m95dMB2MD942703MQ7J7BY7BgMAh80lsyepBmXnN6o8eX3Z1V dR18Y8HyKRQzCYjXIsf/Koh16u/XK4FYP9kFP1SujZOSMH8zaQiR4r6+cAGITT/nvj6f 6JG431AVje9vCQIscRPmnJV4Wp2tk/gFI1Jl9HqL6iQ9nNH7qFs0KC8rpN8/f8ldtRlO QyisGvPA9TciIb2C4F/zx/TdZNCzwdYh9mifLgOXFs0MyeFO5F+O2Y0dRmdYMQXwuaa/ E6X3JkJeAMJp9PaM0AbIB1XHInRwPGPxNzX7Z2/YeWcK3TU+Ucd+pPdtr4T5c16tQVYw T2+g== X-Received: by 10.224.56.5 with SMTP id w5mr7902739qag.60.1400859385237; Fri, 23 May 2014 08:36:25 -0700 (PDT) MIME-Version: 1.0 Received: by 10.140.35.239 with HTTP; Fri, 23 May 2014 08:36:05 -0700 (PDT) In-Reply-To: References: From: Jason Altekruse Date: Fri, 23 May 2014 10:36:05 -0500 Message-ID: Subject: =?UTF-8?B?UmU6IOWbnuWkje+8miDlm57lpI3vvJogZXJyb3Igd2hlbiBxdWVyeWluZyBhIGNzdiBmaQ==?= =?UTF-8?B?bGUgd2l0aCBkcmlsbC4=?= To: Apache Drill User Content-Type: multipart/alternative; boundary=001a11c300a609953c04fa12fe9d X-Virus-Checked: Checked by ClamAV on apache.org --001a11c300a609953c04fa12fe9d Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Sorry, that was a bit of a roundabout way of describing the process. The normal connection should just give you a session where you can query all schemas (in your config file, dfs is the only schema listed). You simply need to write it as dfs.`filepath' I was looking at the connection docs quickly and I couldn't find the exact option for specifying schema. I'll reply if I find something later today (its likely just schema or default_schema). Doing this would simply allow you to leave off the dfs part of the name, as it will assume your queries will want to default to that schema. -Jason On Fri, May 23, 2014 at 10:20 AM, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 wrote: > I found that there are two configuration files in drill home > (storage-engines.json and storage-plugins.json) . I have tried to remove > storage-engines.json, Connection can establish but same error occurs. > I connected drill with string "sqlline -u jdbc:drill:schema=3Ddfs -n admi= n - > p admin " ,you mean I connect without giving a schema then query with > dfs.`tablename`? > It's 23:00 now. I would try again tomorrow. ^_^ > thanks > > > > > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 -----------------= - > =E5=8F=91=E4=BB=B6=E4=BA=BA: "Jason Altekruse"; > =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) =E6=99=9A=E4=B8=8A10:43 > =E6=94=B6=E4=BB=B6=E4=BA=BA: "drill-user"; > =E4=B8=BB=E9=A2=98: Re: =E5=9B=9E=E5=A4=8D=EF=BC=9A error when querying a= csv file with drill. > > > > It looks like you need to specify the data source you are using (appearin= g > in the storage section of your config file), I believe there is a way whe= n > you are connecting to pass a default schema, but it currently isn't set u= p > to bring you right into a schema, even if you only have line specified in > your config file. So you should be able to query from dfs.`table` (where > table is the filename in your case) > > - Jason > > > On Fri, May 23, 2014 at 9:30 AM, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 wrote: > > > I have tried three way (back-ticks, single quotes, double quotes).Here = is > > the back-ticks error report: > > I succeed in quering parquet and json format file before with "double > > quotes" around file classpath. I thought they were same. > > 0: jdbc:drill:schema=3Ddfs> select * from `/home/bevin/AllstarFull.csv`= ; > > 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:19= 2) > > 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: Lexical error at > > line 1, column 15. Encountered: "`" (96), after : "" > > 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:138) > > at > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.= java:235) > > ... 10 more > > Caused by: org.eigenbase.sql.parser.impl.TokenMgrError: Lexical error a= t > > line 1, column 15. Encountered: "`" (96), after : "" > > at > > > org.eigenbase.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlP= arserImplTokenManager.java:4924) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.j= ava:15281) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_245(SqlParserImpl.java:1= 4738) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_38(SqlParserImpl.java:1= 4750) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_42(SqlParserImpl.java:1= 4643) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_73(SqlParserImpl.java:14= 951) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_2_73(SqlParserImpl.java:53= 38) > > at > > > org.eigenbase.sql.parser.impl.SqlParserImpl.TableRef(SqlParserImpl.java:1= 379) > > 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:130) > > ... 11 more > > > > > > Thanks. > > > > > > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 ---------------= --- > > =E5=8F=91=E4=BB=B6=E4=BA=BA: "Jason Altekruse";; > > =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) =E6=99=9A=E4=B8=8A10:20 > > =E6=94=B6=E4=BB=B6=E4=BA=BA: "Apache Drill User"; > > > > =E4=B8=BB=E9=A2=98: Re: error when querying a csv file with drill. > > > > > > > > Hello Bevin, > > > > Welcome to the Drill community! For your error it looks like there is a= n > > issue parsing the table name. Table names are expected to be surrounded > by > > back-ticks instead of single quotes, for more info you can read this po= st > > on the wiki. > > > > > https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minu= tes > > > > -Jason > > > > > > On Fri, May 23, 2014 at 6:15 AM, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 <= i02389@qq.com> wrote: > > > > > Here is my storage-plugins.json: > > > { > > > "storage":{ > > > dfs: { > > > type: "file", > > > connection: "file:///" > > > }, > > > formats: { > > > "psv" : { > > > type: "text", > > > extensions: [ "tbl" ], > > > delimiter: "|" > > > }, > > > "csv" : { > > > type: "text", > > > extensions: [ "csv" ], > > > delimiter: "," > > > }, > > > "tsv" : { > > > type: "text", > > > extensions: [ "tsv" ], > > > delimiter: "\t" > > > }, > > > "parquet" : { > > > type: "parquet" > > > }, > > > "json" : { > > > type: "json" > > > } > > > } > > > }, > > > cp: { > > > type: "file", > > > connection: "classpath:///" > > > } > > > } > > > }I connect drill with string "sqlline -u jdbc:drill:schema=3Ddfs -n a= dmin > > -p > > > admin" > > > > > > bevin@le:/opt/apache-drill-1.0.0-m1/bin$ sqlline -u > > jdbc:drill:schema=3Ddfs > > > -n admin -p admin > > > > > > > > > Loaded singnal handler: SunSignalHandler > > > /home/bevin/.sqlline/sqlline.properties (=E6=B2=A1=E6=9C=89=E9=82=A3= =E4=B8=AA=E6=96=87=E4=BB=B6=E6=88=96=E7=9B=AE=E5=BD=95) > > > scan complete in 18ms > > > scan complete in 2693ms > > > Connecting to jdbc:drill:schema=3Ddfs > > > Connected to: Drill (version 1.0) > > > Driver: Apache Drill JDBC Driver (version 1.0) > > > Autocommit status: true > > > Transaction isolation: TRANSACTION_REPEATABLE_READ > > > sqlline version ??? by Marc Prud'hommeauxThen run a query(the file pa= th > > is > > > right) : > > > 0: jdbc:drill:schema=3Ddfs> select * from "/home/bevin/AllstarFull.cs= v"; > > > =E4=BA=94=E6=9C=88 23, 2014 7:09:14 =E4=B8=8B=E5=8D=88 org.eigenbase.= sql.validate.SqlValidatorException > > > > > > =E4=B8=A5=E9=87=8D: org.eigenbase.sql.validate.SqlValidatorException:= Table > > > '/home/bevin/AllstarFull.csv' not found > > > =E4=BA=94=E6=9C=88 23, 2014 7:09:14 =E4=B8=8B=E5=8D=88 org.eigenbase.= util.EigenbaseException > > > =E4=B8=A5=E9=87=8D: org.eigenbase.util.EigenbaseContextException: Fro= m line 1, column > 15 > > > to line 1, column 43 > > > org.eigenbase.util.EigenbaseContextException: From line 1, column 15 = to > > > line 1, column 43 > > > at > > > > > > org.eigenbase.resource.EigenbaseResource$_Def12.ex(EigenbaseResource.java= :1026) > > > at > > org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:739) > > > at > > org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:726) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidat= orImpl.java:3830) > > > at > > > > > > org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNam= espace.java:78) > > > at > > > > > > org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.j= ava:90) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidato= rImpl.java:802) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImp= l.java:790) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl= .java:2776) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorIm= pl.java:3013) > > > at > > > > > > org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.j= ava:69) > > > at > > > > > > org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.j= ava:90) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidato= rImpl.java:802) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImp= l.java:790) > > > at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:154) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlV= alidatorImpl.java:753) > > > at > > > > > > org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.jav= a:444) > > > at > > > > > > org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.ja= va:445) > > > at > > > net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:160) > > > at > > > net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:129) > > > at > > > > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.= java:255) > > > 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.validate.SqlValidatorException: Table > > > '/home/bevin/AllstarFull.csv' not found > > > at > > > > > > org.eigenbase.resource.EigenbaseResource$_Def9.ex(EigenbaseResource.java:= 963) > > > ... 27 more0: jdbc:drill:schema=3Ddfs> select * from > > > `/home/bevin/AllstarFull.csv`; > > > 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: Lexical error = at > > > line 1, column 15. Encountered: "`" (96), after : "" > > > 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:138) > > > at > > > > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.= java:235) > > > ... 10 more > > > Caused by: org.eigenbase.sql.parser.impl.TokenMgrError: Lexical error > at > > > line 1, column 15. Encountered: "`" (96), after : "" > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlP= arserImplTokenManager.java:4924) > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.j= ava:15281) > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_245(SqlParserImpl.java:1= 4738) > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_38(SqlParserImpl.java:1= 4750) > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_42(SqlParserImpl.java:1= 4643) > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_73(SqlParserImpl.java:14= 951) > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_2_73(SqlParserImpl.java:53= 38) > > > at > > > > > > org.eigenbase.sql.parser.impl.SqlParserImpl.TableRef(SqlParserImpl.java:1= 379) > > > 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:130) > > > ... 11 more0: jdbc:drill:schema=3Ddfs> select * from > > > '/home/bevin/AllstarFull.csv'; > > > 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 > > > "\'/home/bevin/AllstarFull.csv\'" at line 1, column 15. > > > Was expecting one of: > > > ... > > > ... > > > ... > > > "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:138) > > > at > > > > > > net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.= java:235) > > > ... 10 more > > > Caused by: org.eigenbase.sql.parser.impl.ParseException: Encountered > > > "\'/home/bevin/AllstarFull.csv\'" at line 1, column 15. > > > Was expecting one of: > > > ... > > > ... > > > ... > > > "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:130) > > > ... 11 moreI can't figure out what happened during the query = , > > PLZ > > > give me some help! > > > THANKS > > > BEVIN > > > --001a11c300a609953c04fa12fe9d--