No Drill does not need any extra JAVA_HOME config. Great to hear that we cracked the issue.
Good Luck Drilling!! On Sat, May 24, 2014 at 2:07 PM, 南在南方 <[email protected]> wrote: > The m2 binary package works! > thanks! > > > > > > > > ------------------ 原始邮件 ------------------ > 发件人: "南在南方"<[email protected]>; > 发送时间: 2014年5月24日(星期六) 下午4:09 > 收件人: "drill-user"<[email protected]>; > 主题: 回复： 回复： 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with > drill. > > > > Here is my java -version output and $JAVA_HOME configuration: > > > bevin@le:/opt/drill$ java -version > java version "1.7.0_40" > Java(TM) SE Runtime Environment (build 1.7.0_40-b43) > Java HotSpot(TM) Server VM (build 24.0-b56, mixed mode) > > > > bevin@le:/opt/drill$ echo $JAVA_HOME > /usr/lib/jvm/jdk > > > > Does drill need extra java home configuration in its home directory? > > > ------------------ 原始邮件 ------------------ > 发件人: "Yash Sharma";<[email protected]>; > 发送时间: 2014年5月24日(星期六) 下午4:32 > 收件人: "drill-user"<[email protected]>; > > 主题: Re: 回复： 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with > drill. > > > > > https://www.dropbox.com/s/o95cxfj82dj5m8h/apache-drill-1.0.0-m2-incubating-SNAPSHOT-binary-release.tar.gz > > > > > On Sat, May 24, 2014 at 1:28 PM, 南在南方 <[email protected]> wrote: > > > The m2 binary URL you give returns 404 not found error. > > > > > > > > > > ------------------ 原始邮件 ------------------ > > 发件人: "南在南方"<[email protected]>; > > 发送时间: 2014年5月24日(星期六) 下午3:55 > > 收件人: "drill-user"<[email protected]>; > > 主题: 回复： 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with > drill. > > > > > > > > Thanks > > I compile m2 version successfully. > > Looks like readme.md file doesn't update to m2 . lol. > > > > > > No known driver to handle "jdbc:drill:zk=local" occurs. > > and run sqlline: > > bevin@le:/opt/drill$ sqlline -u jdbc:drill:zk=local -n admin -p admin > > scan complete in 109ms > > scan complete in 894ms > > No known driver to handle "jdbc:drill:zk=local" > > sqlline version 1.0.2 by Marc Prud'hommeaux > > sqlline> select * from `/home/data.csv`; > > No current connection > > sqlline> select * from dfs.`/home/data.csv`; > > No current connection > > > > > > > > > > > > > > > > ------------------ 原始邮件 ------------------ > > 发件人: "Yash Sharma";<[email protected]>; > > 发送时间: 2014年5月24日(星期六) 下午4:21 > > 收件人: "drill-user"<[email protected]>; > > > > 主题: Re: 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with > drill. > > > > > > > > Try the new binaries out: > > > > > https://www.dropbox.com/sm/create/apache-drill-1.0.0-m2-incubating-SNAPSHOT-binary-release.tar.gz > > > > Its ~90 Megs. > > > > Extract the tar to the installation dir as before and execute the queries > > on it. > > > > Also you can try this old method on the M1 version of binaries. This was > > the old way of querying Sqlline: > > > > > http://www.confusedcoders.com/bigdata/apache-drill/apache-drill-executing-sample-sql-queries-on-json-data > > > > Let me know if either one works. > > > > Peace, > > Yash > > > > > > > > On Sat, May 24, 2014 at 1:15 PM, Yash Sharma <[email protected]> wrote: > > > > > Building from source would give you M2 version. Let me put my binary > > > tarball on dropbox. > > > > > > > > > > > > On Sat, May 24, 2014 at 1:10 PM, 南在南方 <[email protected]> wrote: > > > > > >> Is that Apache Drill Milestone 1 - (Drill Alpha) is the newest > version? > > >> > > >> > > >> > > >> > > >> ------------------ 原始邮件 ------------------ > > >> 发件人: "南在南方"<[email protected]>; > > >> 发送时间: 2014年5月24日(星期六) 下午3:34 > > >> 收件人: "drill-user"<[email protected]>; > > >> 主题: 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with drill. > > >> > > >> > > >> > > >> I think not, now I git the newest package . > > >> Can I use your compiled drill directly in my computer? > > >> > > >> > > >> ------------------ 原始邮件 ------------------ > > >> 发件人: "Yash Sharma";<[email protected]>; > > >> 发送时间: 2014年5月24日(星期六) 下午3:57 > > >> 收件人: "drill-user"<[email protected]>; > > >> > > >> 主题: Re: 回复： 回复： 回复： 回复： 回复： error when querying a csv file with drill. > > >> > > >> > > >> > > >> Is this error message on a fresh pull? > > >> > > >> > > >> On Sat, May 24, 2014 at 12:49 PM, 南在南方 <[email protected]> wrote: > > >> > > >> > ERROR :No known driver to handle "xxxxx", That why I turn to binary. > > ==~ > > >> > > > >> > > > >> > bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=local -n > > admin > > >> -p > > >> > admin > > >> > scan complete in 81ms > > >> > scan complete in 984ms > > >> > No known driver to handle "jdbc:drill:zk=local" > > >> > sqlline version 1.0.2 by Marc Prud'hommeaux > > >> > sqlline> !quit > > >> > bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=dfs -n > > >> admin > > >> > -p admin > > >> > scan complete in 119ms > > >> > scan complete in 825ms > > >> > No known driver to handle "jdbc:drill:schmea=dfs" > > >> > sqlline version 1.0.2 by Marc Prud'hommeaux > > >> > sqlline> > > >> > > > >> > ------------------ 原始邮件 ------------------ > > >> > 发件人: "Yash Sharma";<[email protected]>; > > >> > 发送时间: 2014年5月24日(星期六) 下午3:37 > > >> > 收件人: "drill-user"<[email protected]>; > > >> > > > >> > 主题: Re: 回复： 回复： 回复： 回复： error when querying a csv file with drill. > > >> > > > >> > > > >> > > > >> > I am not sure of the root cause Bevin. > > >> > I would try to run queries on the binaries and let you know. > > >> > > > >> > Peace, > > >> > Yash > > >> > > > >> > > > >> > On Sat, May 24, 2014 at 12:31 PM, 南在南方 <[email protected]> wrote: > > >> > > > >> > > Thanks. > > >> > > I compiled it before, but now I use drill in my cluster > environment > > >> where > > >> > > Network isn't available. but I would try again in my own ubuntu ma > > >> chine. > > >> > > So is this version problem with binary installed drill package? > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > ------------------ 原始邮件 ------------------ > > >> > > 发件人: "Yash Sharma"<[email protected]>; > > >> > > 发送时间: 2014年5月24日(星期六) 下午3:17 > > >> > > 收件人: "drill-user"<[email protected]>; > > >> > > 主题: Re: 回复： 回复： 回复： error when querying a csv file with drill. > > >> > > > > >> > > > > >> > > > > >> > > Hi Bevin, > > >> > > These are the steps to build directly from the source: > > >> > > > > >> > > // Get Drill Source > > >> > > > > >> > > $ git clone https://github.com/apache/incubator-drill.git > > >> > > $ cd incubator-drill > > >> > > > > >> > > // Inside /DRILL DIR/ > > >> > > $ mvn clean install -DskipTests > > >> > > > > >> > > // Install Drill > > >> > > $ mkdir /opt/drill > > >> > > $ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill > > >> > > > > >> > > // Switch to installed directory > > >> > > $ cd /opt/drill > > >> > > $ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin > > >> > > > > >> > > 0: jdbc:drill:zk=local> > > >> > > select * from dfs.`/home/yash/git/Drill/data.json`; > > >> > > > > >> > > Let me know if this works. > > >> > > > > >> > > Peace Yash > > >> > > > > >> > > > > >> > > On Sat, May 24, 2014 at 12:10 PM, 南在南方 <[email protected]> wrote: > > >> > > > > >> > > > Hi, thank you for your reply. > > >> > > > I failed the query again this morning. > > >> > > > I can query json file correctly. (oddly, I use jsonl schema > which > > >> > defined > > >> > > > in storage-engines.json and there query with “select * from > > >> "file.json" > > >> > > ”, > > >> > > > not back ticks). > > >> > > > > > >> > > > > > >> > > > I use binary version of drill, Is that can be a reason I failed > to > > >> > query? > > >> > > > I would appreciate it if you send your entire Drill directory > zip > > >> > package > > >> > > > to me. [email protected] or [email protected] . > > >> > > > THANKS > > >> > > > > > >> > > > > > >> > > > ------------------ 原始邮件 ------------------ > > >> > > > 发件人: "Yash Sharma";<[email protected]>; > > >> > > > 发送时间: 2014年5月24日(星期六) 凌晨1:52 > > >> > > > 收件人: "drill-user"<[email protected]>; > > >> > > > > > >> > > > 主题: Re: 回复： 回复： error when querying a csv file with drill. > > >> > > > > > >> > > > > > >> > > > > > >> > > > Hi All, > > >> > > > Is the main issue on connecting/querying to the json/csv data > > >> sources. > > >> > > > > > >> > > > Here is what I did for querying Json/Csv data Sources. > > >> > > > Let me know if this is what we are looking for... or I am > missing > > >> the > > >> > > > context here.. > > >> > > > > > >> > > > 1. I did not modify the storage-plugin.json. > > >> > > > > > >> > > > > > >> > > > > >> > > > >> > > > https://github.com/apache/incubator-drill/blob/master/distribution/src/resources/storage-plugins.json > > >> > > > > > >> > > > *2 Created Json Data:* in Path /home/yash/git/Drill/data.json > > >> > > > The content of Json is pasted in the end of mail. > > >> > > > > > >> > > > *3. Start Drill: *Drill is started by > > >> > > > bin/sqlline -u jdbc:drill:zk=local -n admin -p admin > > >> > > > > > >> > > > *4. Query Json Data:* pass path with > dfs<dot>`path\to\data.json`; > > >> (path > > >> > > in > > >> > > > back-tick) > > >> > > > 0: jdbc:drill:zk=local> > > >> > > > select * from dfs.`/home/yash/git/Drill/data.json`; > > >> > > > > > >> > > > *5. Output* > > >> > > > > > >> > > > > > >> > > > > >> > > > >> > > > +------------+------------+------------+------------+------------+------------+ > > >> > > > | title | name | width | height | image > | > > >> > > text > > >> > > > | > > >> > > > > > >> > > > > > >> > > > > >> > > > >> > > > +------------+------------+------------+------------+------------+------------+ > > >> > > > | Transparent Window | trn_window | 500 | 500 | > > >> > > > > > >> > > > > > >> > > > > >> > > > >> > > > {"alignment":"center","hOffset":250,"name":"sun1","src":"Images/Sun.png","vOffset":250} > > >> > > > | {"alignm | > > >> > > > | White Window | white_window | 500 | 500 | > > >> > > > > > >> > > > > > >> > > > > >> > > > >> > > > {"alignment":"center","hOffset":250,"name":"sun1","src":"Images/Sun.png","vOffset":250} > > >> > > > | {"alignment" | > > >> > > > | black window | black_window | 500 | 500 | > > >> > > > > > >> > > > > > >> > > > > >> > > > >> > > > {"alignment":"center","hOffset":250,"name":"sun1","src":"Images/Sun.png","vOffset":250} > > >> > > > | {"alignment" | > > >> > > > > > >> > > > > > >> > > > > >> > > > >> > > > +------------+------------+------------+------------+------------+------------+ > > >> > > > 3 rows selected (0.095 seconds) > > >> > > > > > >> > > > > > >> > > > Same procedure for *CSV* Data: > > >> > > > *Query:* > > >> > > > select * from dfs.`/home/yash/Desktop/Drill/data.csv`; > > >> > > > select columns from dfs.`/home/yash/Desktop/Drill/data.csv`; > > >> > > > select columns[1] from dfs.`/home/yash/Desktop/Drill/data.csv`; > > >> > > > > > >> > > > > > >> > > > > > >> > > > Hope it helps. > > >> > > > > > >> > > > Peace, > > >> > > > Yash > > >> > > > > > >> > > > > > >> > > > > > >> > > > JSON Data: > > >> > > > > > >> > > > > { > > >> > > > > "title": "Transparent Window", > > >> > > > > "name": "trn_window", > > >> > > > > "width": 500, > > >> > > > > "height": 500, > > >> > > > > > > >> > > > > "image": { > > >> > > > > "src": "Images/Sun.png", > > >> > > > > "name": "sun1", > > >> > > > > "hOffset": 250, > > >> > > > > "vOffset": 250, > > >> > > > > "alignment": "center" > > >> > > > > }, > > >> > > > > "text": { > > >> > > > > "data": "Click Here", > > >> > > > > "size": 36, > > >> > > > > "style": "bold", > > >> > > > > "name": "text1", > > >> > > > > "hOffset": 250, > > >> > > > > "vOffset": 100, > > >> > > > > "alignment": "center", > > >> > > > > "onMouseUp": "sun1.opacity = (sun1.opacity / 100) * 90;" > > >> > > > > } > > >> > > > > } > > >> > > > > > > >> > > > > { > > >> > > > > "title": "White Window", > > >> > > > > "name": "white_window", > > >> > > > > "width": 500, > > >> > > > > "height": 500, > > >> > > > > > > >> > > > > "image": { > > >> > > > > "src": "Images/Sun.png", > > >> > > > > "name": "sun1", > > >> > > > > "hOffset": 250, > > >> > > > > "vOffset": 250, > > >> > > > > "alignment": "center" > > >> > > > > }, > > >> > > > > "text": { > > >> > > > > "data": "Click Here", > > >> > > > > "size": 36, > > >> > > > > "style": "bold", > > >> > > > > "name": "text1", > > >> > > > > "hOffset": 250, > > >> > > > > "vOffset": 100, > > >> > > > > "alignment": "center", > > >> > > > > "onMouseUp": "sun1.opacity = (sun1.opacity / 100) * 90;" > > >> > > > > } > > >> > > > > } > > >> > > > > > > >> > > > > { > > >> > > > > "title": "black window", > > >> > > > > "name": "black_window", > > >> > > > > "width": 500, > > >> > > > > "height": 500, > > >> > > > > > > >> > > > > "image": { > > >> > > > > "src": "Images/Sun.png", > > >> > > > > "name": "sun1", > > >> > > > > "hOffset": 250, > > >> > > > > "vOffset": 250, > > >> > > > > "alignment": "center" > > >> > > > > }, > > >> > > > > "text": { > > >> > > > > "data": "Click Here", > > >> > > > > "size": 36, > > >> > > > > "style": "bold", > > >> > > > > "name": "text1", > > >> > > > > "hOffset": 250, > > >> > > > > "vOffset": 100, > > >> > > > > "alignment": "center", > > >> > > > > "onMouseUp": "sun1.opacity = (sun1.opacity / 100) * 90;" > > >> > > > > } > > >> > > > > } > > >> > > > > > >> > > > > > >> > > > > > >> > > > CSV Data: > > >> > > > > > >> > > > u1,purchase,iphone > > >> > > > > u1,purchase,ipad > > >> > > > > u2,purchase,nexus > > >> > > > > u2,purchase,galaxy > > >> > > > > u3,purchase,surface > > >> > > > > u4,purchase,iphone > > >> > > > > u4,purchase,galaxy > > >> > > > > u1,view,iphone > > >> > > > > u1,view,ipad > > >> > > > > u1,view,nexus > > >> > > > > u1,view,galaxy > > >> > > > > u2,view,iphone > > >> > > > > u2,view,ipad > > >> > > > > u2,view,nexus > > >> > > > > u2,view,galaxy > > >> > > > > u3,view,surface > > >> > > > > u3,view,nexus > > >> > > > > u4,view,iphone > > >> > > > > u4,view,ipad > > >> > > > > u4,view,galaxy > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > On Fri, May 23, 2014 at 9:06 PM, Jason Altekruse > > >> > > > <[email protected]>wrote: > > >> > > > > > >> > > > > 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, 南在南方 <[email protected]> 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=dfs > > >> -n > > >> > > > admin > > >> > > > > - > > >> > > > > > 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 > > >> > > > > > > > >> > > > > > > > >> > > > > > > > >> > > > > > > > >> > > > > > ------------------ 原始邮件 ------------------ > > >> > > > > > 发件人: "Jason Altekruse"<[email protected]>; > > >> > > > > > 发送时间: 2014年5月23日(星期五) 晚上10:43 > > >> > > > > > 收件人: "drill-user"<[email protected]>; > > >> > > > > > 主题: Re: 回复： error when querying a csv file with drill. > > >> > > > > > > > >> > > > > > > > >> > > > > > > > >> > > > > > It looks like you need to specify the data source you are > > using > > >> > > > > (appearing > > >> > > > > > in the storage section of your config file), I believe there > > is > > >> a > > >> > way > > >> > > > > when > > >> > > > > > you are connecting to pass a default schema, but it > currently > > >> isn't > > >> > > set > > >> > > > > up > > >> > > > > > 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, 南在南方 <[email protected]> > 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=dfs> 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.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: > > Lexical > > >> > > error > > >> > > > at > > >> > > > > > > line 1, column 15. Encountered: "`" (96), after : "" > > >> > > > > > > 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.TokenMgrError: > > >> Lexical > > >> > > error > > >> > > > > at > > >> > > > > > > line 1, column 15. Encountered: "`" (96), after : "" > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlParserImplTokenManager.java:4924) > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.java:15281) > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_245(SqlParserImpl.java:14738) > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_38(SqlParserImpl.java:14750) > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_42(SqlParserImpl.java:14643) > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_73(SqlParserImpl.java:14951) > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_2_73(SqlParserImpl.java:5338) > > >> > > > > > > at > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.TableRef(SqlParserImpl.java:1379) > > >> > > > > > > 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 > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > Thanks. > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > ------------------ 原始邮件 ------------------ > > >> > > > > > > 发件人: "Jason Altekruse";<[email protected]>; > > >> > > > > > > 发送时间: 2014年5月23日(星期五) 晚上10:20 > > >> > > > > > > 收件人: "Apache Drill User"<[email protected] > >; > > >> > > > > > > > > >> > > > > > > 主题: Re: error when querying a csv file with drill. > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > Hello Bevin, > > >> > > > > > > > > >> > > > > > > Welcome to the Drill community! For your error it looks > like > > >> > there > > >> > > is > > >> > > > > an > > >> > > > > > > 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 > > >> > > > > post > > >> > > > > > > on the wiki. > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes > > >> > > > > > > > > >> > > > > > > -Jason > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > On Fri, May 23, 2014 at 6:15 AM, 南在南方 <[email protected]> > > 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=dfs > > >> > -n > > >> > > > > admin > > >> > > > > > > -p > > >> > > > > > > > admin" > > >> > > > > > > > > > >> > > > > > > > bevin@le:/opt/apache-drill-1.0.0-m1/bin$ sqlline -u > > >> > > > > > > jdbc:drill:schema=dfs > > >> > > > > > > > -n admin -p admin > > >> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > Loaded singnal handler: SunSignalHandler > > >> > > > > > > > /home/bevin/.sqlline/sqlline.properties (没有那个文件或目录) > > >> > > > > > > > scan complete in 18ms > > >> > > > > > > > scan complete in 2693ms > > >> > > > > > > > Connecting to jdbc:drill:schema=dfs > > >> > > > > > > > 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 > > >> > > > > path > > >> > > > > > > is > > >> > > > > > > > right) : > > >> > > > > > > > 0: jdbc:drill:schema=dfs> select * from > > >> > > > > "/home/bevin/AllstarFull.csv"; > > >> > > > > > > > 五月 23, 2014 7:09:14 下午 > > >> > > > > org.eigenbase.sql.validate.SqlValidatorException > > >> > > > > > > > <init> > > >> > > > > > > > 严重: org.eigenbase.sql.validate.SqlValidatorException: > > Table > > >> > > > > > > > '/home/bevin/AllstarFull.csv' not found > > >> > > > > > > > 五月 23, 2014 7:09:14 下午 > > org.eigenbase.util.EigenbaseException > > >> > > <init> > > >> > > > > > > > 严重: org.eigenbase.util.EigenbaseContextException: From > > 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(SqlValidatorImpl.java:3830) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:78) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:90) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:802) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:790) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2776) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3013) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:69) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:90) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:802) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:790) > > >> > > > > > > > at > > >> > > org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:154) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:753) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:444) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java: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.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.validate.SqlValidatorException: > > >> > > Table > > >> > > > > > > > '/home/bevin/AllstarFull.csv' not found > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.resource.EigenbaseResource$_Def9.ex(EigenbaseResource.java:963) > > >> > > > > > > > ... 27 more0: jdbc:drill:schema=dfs> 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.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: > > >> Lexical > > >> > > > error > > >> > > > > at > > >> > > > > > > > line 1, column 15. Encountered: "`" (96), after : "" > > >> > > > > > > > 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.TokenMgrError: > > >> Lexical > > >> > > > error > > >> > > > > > at > > >> > > > > > > > line 1, column 15. Encountered: "`" (96), after : "" > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlParserImplTokenManager.java:4924) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.java:15281) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_245(SqlParserImpl.java:14738) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_38(SqlParserImpl.java:14750) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3R_42(SqlParserImpl.java:14643) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_3_73(SqlParserImpl.java:14951) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.jj_2_73(SqlParserImpl.java:5338) > > >> > > > > > > > at > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > org.eigenbase.sql.parser.impl.SqlParserImpl.TableRef(SqlParserImpl.java:1379) > > >> > > > > > > > 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 more0: jdbc:drill:schema=dfs> 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.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 > > >> > > > > > > > "\'/home/bevin/AllstarFull.csv\'" 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 > > >> > > > > > > > "\'/home/bevin/AllstarFull.csv\'" 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 moreI can't figure out what happened > during > > >> the > > >> > > > query > > >> > > > > , > > >> > > > > > > PLZ > > >> > > > > > > > give me some help! > > >> > > > > > > > THANKS > > >> > > > > > > > BEVIN > > >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > > > > > > > >
