The real issue is what Jacques mentioned. To solve it copy the tsv format plugin in the web UI and create a new log plugin. What this means is that now drill will look at .log files and know what to do with them, i.e. What kind of delimiters are used in the .log file.
Regards Ramana On Wednesday, July 16, 2014, Jacques Nadeau <[email protected]> wrote: > We really need to see the git.properties to determine whether this is an > old version. The tag you gave is too generic. The latest build will be git > tag starting with 699851b. > > You're most likely having an issue with file mappings. Drill defaults to > only mapping certain extensions to various text file formats. You can > change these mappings by updating the storage plugin configurations from > within the web gui. > > > On Wed, Jul 16, 2014 at 9:06 PM, Jiaojiao Song (JIRA) <[email protected] > <javascript:;>> > 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) > > >
