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 E8F5E113ED for ; Sat, 24 May 2014 08:03:16 +0000 (UTC) Received: (qmail 71177 invoked by uid 500); 24 May 2014 08:03:16 -0000 Delivered-To: apmail-incubator-drill-user-archive@incubator.apache.org Received: (qmail 71122 invoked by uid 500); 24 May 2014 08:03:16 -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 71114 invoked by uid 99); 24 May 2014 08:03:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 May 2014 08:03:16 +0000 X-ASF-Spam-Status: No, hits=2.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of yash360@gmail.com designates 209.85.220.169 as permitted sender) Received: from [209.85.220.169] (HELO mail-vc0-f169.google.com) (209.85.220.169) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 May 2014 08:03:11 +0000 Received: by mail-vc0-f169.google.com with SMTP id ij19so7283802vcb.14 for ; Sat, 24 May 2014 01:02:50 -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=CDf1OOtyWL5O6lEINYCJKjaq7ZYTFcVbEwGpWWKPK8U=; b=rsaFTB2KvMmmNJbnG33alE7C3LfTHcgpYcXqoorIvrh7+AOoolBRclftXrjjcoAitg 47wrbGsycUH/csc9ZNNaJJbsUz6ITz72Bz9wiYY3OiPBZTeOYRTx/mVyeSBs7qQju8DF VjUIf0NPeOYoZzVJGPQnMqaXNca1q/J1D8oIDtFJRf2sgEvnCquDqiz3kmRqhBp5Kzp+ 1MZM7daAE915JpBeLUU4fqfw6JMZ51q/PdOMs/F750SQObxPKqAATk3NdOG77MUQPgLY l51cX7E6I12Kpt1ABOXcJ2TrhsKBQxSqaXp4I0JPPCgP9nkpLhnUizIEVnNSfZ+3ngiU PGKA== X-Received: by 10.221.64.20 with SMTP id xg20mr5151843vcb.3.1400918570557; Sat, 24 May 2014 01:02:50 -0700 (PDT) MIME-Version: 1.0 Received: by 10.220.136.74 with HTTP; Sat, 24 May 2014 01:02:09 -0700 (PDT) In-Reply-To: References: From: Yash Sharma Date: Sat, 24 May 2014 13:32:09 +0530 Message-ID: Subject: =?UTF-8?B?UmU6IOWbnuWkje+8miDlm57lpI3vvJog5Zue5aSN77yaIOWbnuWkje+8miDlm57lpI0=?= =?UTF-8?B?77yaIOWbnuWkje+8miDlm57lpI3vvJogZXJyb3Igd2hlbiBxdWVyeWluZyBhIGNzdiBmaWxlIHdpdGgg?= =?UTF-8?B?ZHJpbGwu?= To: drill-user@incubator.apache.org Content-Type: multipart/alternative; boundary=001a113304acc1e7ba04fa20c5cc X-Virus-Checked: Checked by ClamAV on apache.org --001a113304acc1e7ba04fa20c5cc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 wrote: > The m2 binary URL you give returns 404 not found error. > > > > > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 -----------------= - > =E5=8F=91=E4=BB=B6=E4=BA=BA: "=E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9"; > =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8824=E6=97=A5(= =E6=98=9F=E6=9C=9F=E5=85=AD) =E4=B8=8B=E5=8D=883:55 > =E6=94=B6=E4=BB=B6=E4=BA=BA: "drill-user"; > =E4=B8=BB=E9=A2=98: =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC= =9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4= =8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A 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=3Dlocal" occurs. > and run sqlline: > bevin@le:/opt/drill$ sqlline -u jdbc:drill:zk=3Dlocal -n admin -p admin > scan complete in 109ms > scan complete in 894ms > No known driver to handle "jdbc:drill:zk=3Dlocal" > 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 > > > > > > > > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 -----------------= - > =E5=8F=91=E4=BB=B6=E4=BA=BA: "Yash Sharma";; > =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8824=E6=97=A5(= =E6=98=9F=E6=9C=9F=E5=85=AD) =E4=B8=8B=E5=8D=884:21 > =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 =E5=9B=9E=E5=A4=8D=EF= =BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5= =A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A 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-SNAPSH= OT-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 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, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9 <= i02389@qq.com> wrote: > > > >> Is that Apache Drill Milestone 1 - (Drill Alpha) is the newest version= ? > >> > >> > >> > >> > >> ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 --------------= ---- > >> =E5=8F=91=E4=BB=B6=E4=BA=BA: "=E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9"; > >> =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8824=E6=97= =A5(=E6=98=9F=E6=9C=9F=E5=85=AD) =E4=B8=8B=E5=8D=883:34 > >> =E6=94=B6=E4=BB=B6=E4=BA=BA: "drill-user"; > >> =E4=B8=BB=E9=A2=98: =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF= =BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5= =A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A 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? > >> > >> > >> ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 --------------= ---- > >> =E5=8F=91=E4=BB=B6=E4=BA=BA: "Yash Sharma";; > >> =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8824=E6=97= =A5(=E6=98=9F=E6=9C=9F=E5=85=AD) =E4=B8=8B=E5=8D=883:57 > >> =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 =E5=9B=9E=E5=A4=8D= =EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E= =E5=A4=8D=EF=BC=9A 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, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96=B9= wrote: > >> > >> > ERROR :No known driver to handle "xxxxx", That why I turn to binary. > =3D=3D~ > >> > > >> > > >> > bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=3Dlocal -n > admin > >> -p > >> > admin > >> > scan complete in 81ms > >> > scan complete in 984ms > >> > No known driver to handle "jdbc:drill:zk=3Dlocal" > >> > sqlline version 1.0.2 by Marc Prud'hommeaux > >> > sqlline> !quit > >> > bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=3Ddfs -n > >> admin > >> > -p admin > >> > scan complete in 119ms > >> > scan complete in 825ms > >> > No known driver to handle "jdbc:drill:schmea=3Ddfs" > >> > sqlline version 1.0.2 by Marc Prud'hommeaux > >> > sqlline> > >> > > >> > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 ------------= ------ > >> > =E5=8F=91=E4=BB=B6=E4=BA=BA: "Yash Sharma";; > >> > =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8824=E6= =97=A5(=E6=98=9F=E6=9C=9F=E5=85=AD) =E4=B8=8B=E5=8D=883:37 > >> > =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 =E5=9B=9E=E5=A4= =8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A 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, =E5=8D=97=E5=9C=A8=E5=8D=97=E6=96= =B9 wrote: > >> > > >> > > Thanks. > >> > > I compiled it before, but now I use drill in my cluster environmen= t > >> 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? > >> > > > >> > > > >> > > > >> > > > >> > > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 ----------= -------- > >> > > =E5=8F=91=E4=BB=B6=E4=BA=BA: "Yash Sharma"; > >> > > =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8824=E6= =97=A5(=E6=98=9F=E6=9C=9F=E5=85=AD) =E4=B8=8B=E5=8D=883:17 > >> > > =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 =E5=9B=9E=E5= =A4=8D=EF=BC=9A =E5=9B=9E=E5=A4=8D=EF=BC=9A 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=3D1 -C /opt/drill > >> > > > >> > > // Switch to installed directory > >> > > $ cd /opt/drill > >> > > $ sudo bin/sqlline -u jdbc:drill:zk=3Dlocal -n admin -p admin > >> > > > >> > > 0: jdbc:drill:zk=3Dlocal> > >> > > 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, =E5=8D=97=E5=9C=A8=E5=8D=97=E6= =96=B9 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 whic= h > >> > defined > >> > > > in storage-engines.json and there query with =E2=80=9Cselect * f= rom > >> "file.json" > >> > > =E2=80=9D, > >> > > > 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 zi= p > >> > package > >> > > > to me. i02389@qq.com or beviniy@gmail.com . > >> > > > THANKS > >> > > > > >> > > > > >> > > > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 --------= ---------- > >> > > > =E5=8F=91=E4=BB=B6=E4=BA=BA: "Yash Sharma";; > >> > > > =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2014=E5=B9=B45=E6=9C=8824= =E6=97=A5(=E6=98=9F=E6=9C=9F=E5=85=AD) =E5=87=8C=E6=99=A81:52 > >> > > > =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 =E5=9B=9E=E5= =A4=8D=EF=BC=9A 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 missin= g > >> the > >> > > > context here.. > >> > > > > >> > > > 1. I did not modify the storage-plugin.json. > >> > > > > >> > > > > >> > > > >> > > >> > https://github.com/apache/incubator-drill/blob/master/distribution/src/re= sources/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=3Dlocal -n admin -p admin > >> > > > > >> > > > *4. Query Json Data:* pass path with dfs`path\to\data.json`= ; > >> (path > >> > > in > >> > > > back-tick) > >> > > > 0: jdbc:drill:zk=3Dlocal> > >> > > > 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 =3D (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 =3D (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 =3D (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 > >> > > > 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 fi= nd > >> 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 tri= ed > >> to > >> > > > remove > >> > > > > > storage-engines.json, Connection can establish but same erro= r > >> > occurs. > >> > > > > > I connected drill with string "sqlline -u > jdbc:drill:schema=3Ddfs > >> -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 > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > ------------------ =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 wh= en 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 currentl= y > >> 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, =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: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 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 wit= h drill. > >> > > > > > > > >> > > > > > > > >> > > > > > > > >> > > > > > > Hello Bevin, > >> > > > > > > > >> > > > > > > Welcome to the Drill community! For your error it looks li= ke > >> > 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+Minu= tes > >> > > > > > > > >> > > > > > > -Jason > >> > > > > > > > >> > > > > > > > >> > > > > > > On Fri, May 23, 2014 at 6:15 AM, =E5=8D=97=E5=9C=A8=E5=8D= =97=E6=96=B9 > 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 > >> > > > > admin > >> > > > > > > -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 > >> > > > > path > >> > > > > > > is > >> > > > > > > > right) : > >> > > > > > > > 0: jdbc:drill:schema=3Ddfs> select * from > >> > > > > "/home/bevin/AllstarFull.csv"; > >> > > > > > > > =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.SqlValida= torException: > 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.EigenbaseContextE= xception: 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(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:373= 8) > >> > > > > > > > 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:373= 8) > >> > > > > > > > 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:373= 8) > >> > > > > > > > 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 duri= ng > >> the > >> > > > query > >> > > > > , > >> > > > > > > PLZ > >> > > > > > > > give me some help! > >> > > > > > > > THANKS > >> > > > > > > > BEVIN > >> > > > > > > > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > >> > > > > > --001a113304acc1e7ba04fa20c5cc--