Hello Jiaojiao, Yes, that's an old version you're using. Lot has changed in the code in terms of fixes since that bundle.
--- Mufeed Usman My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal <http://mufeed.livejournal.com> On Thu, Jul 17, 2014 at 9:36 AM, Jiaojiao Song (JIRA) <[email protected]> wrote: > Jiaojiao Song created DRILL-1154: > ------------------------------------ > > Summary: Query log file failed > Key: DRILL-1154 > URL: https://issues.apache.org/jira/browse/DRILL-1154 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Text & CSV > Affects Versions: 1.0.0 > Environment: ubuntu > Reporter: Jiaojiao Song > Priority: Critical > > > Failed when I query a text file (.txt/ .log). But when I change the suffix > of this file to '.tsv' It works. I hear a talk and Drill claim can support > log files. So I tried this and find It failed on both .txt and .log. Is > the version I'm using too old? (apache-drill-1.0.0-m2-incubating-SNAPSHOT) > > > Error messages: > 0: jdbc:drill:zk=local> SELECT * FROM > dfs.logs.`/drill/apache-drill-1.0.0-m2-incubating-SNAPSHOT/log/sqlline.log`; > Jul 16, 2014 9:08:08 PM org.eigenbase.sql.validate.SqlValidatorException > <init> > SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table > 'dfs.logs./drill/apache-drill-1.0.0-m2-incubating-SNAPSHOT/log/sqlline.log' > not found > Jul 16, 2014 9:08:08 PM org.eigenbase.util.EigenbaseException <init> > SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column > 15 to line 1, column 17 > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while > running query.[error_id: "fe18b830-2ed7-447d-b4be-5e340e4aa488" > endpoint { > address: "promd-1s-dhcp69.eng.vmware.com" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > error_type: 0 > message: "Failure while parsing sql. < ValidationException:[ > org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to > line 1, column 17 ] < EigenbaseContextException:[ From line 1, column 15 to > line 1, column 17 ] < SqlValidatorException:[ Table > 'dfs.logs./drill/apache-drill-1.0.0-m2-incubating-SNAPSHOT/log/sqlline.log' > not found ]" > ] > Error: exception while executing query (state=,code=0) > > > > -- > This message was sent by Atlassian JIRA > (v6.2#6252) >
