I missed the ending '. It should be : dfs.`/home/mapr/apache-drill- 1.0.0-m2-incubating-SNAPSHOT/sample-data/fb/`
On Wed, Mar 26, 2014 at 10:10 AM, Jinfeng Ni (JIRA) <[email protected]> wrote: > > [ > https://issues.apache.org/jira/browse/DRILL-453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13948120#comment-13948120] > > Jinfeng Ni commented on DRILL-453: > ---------------------------------- > > Could you please try this: > dfs.`/home/mapr/apache-drill-1.0.0-m2-incubating-SNAPSHOT/sample-data/fb/ > > Notice the '/' in the end. For directory, I think the tailing '/' is > required. > > > > > Query on a directory throws exception > > ------------------------------------- > > > > Key: DRILL-453 > > URL: https://issues.apache.org/jira/browse/DRILL-453 > > Project: Apache Drill > > Issue Type: Bug > > Reporter: Neeraja > > Priority: Critical > > > > Following exception is thrown when issuing query against a directory. > > The directory contained 2 files of similar schema. Queries against each > single file works but query against doesn't work. > > 0: jdbc:drill:> select * from > dfs.`/home/mapr/apache-drill-1.0.0-m2-incubating-SNAPSHOT/sample-data/fb`; > > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure > while running query.[error_id: "3dc30404-99b7-4ba1-ba38-c8afb7006fb0" > > endpoint { > > address: "ubuntu" > > 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 87 ] < EigenbaseContextException:[ From line 1, column 15 to > line 1, column 87 ] < SqlValidatorException:[ Table > \'dfs./home/mapr/apache-drill-1.0.0-m2-incubating-SNAPSHOT/sample-data/fb\' > not found ]" > > ]Error: exception while executing query (state=,code=0) > > > > -- > This message was sent by Atlassian JIRA > (v6.2#6252) >
