[jira] [Updated] (DRILL-1082) Problems with creating views using a path
[ https://issues.apache.org/jira/browse/DRILL-1082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse updated DRILL-1082: --- Fix Version/s: (was: 1.2.0) 1.3.0 > Problems with creating views using a path > - > > Key: DRILL-1082 > URL: https://issues.apache.org/jira/browse/DRILL-1082 > Project: Apache Drill > Issue Type: Bug > Components: Metadata >Reporter: Krystal >Assignee: Jason Altekruse >Priority: Minor > Fix For: 1.3.0 > > > git.commit.id.abbrev=33c28f6 > I tried to create a view with a path relative to dfs.default schema: > 0: jdbc:drill:schema=dfs> create view `dfs.default`.`views/votertsv.v2` as > select columns[0] voter_id, columns[1] name, columns[2] age, columns[3] > registration,columns[4] contributions,columns[5] voterzone,columns[6] > create_time from `dfs`.`root`.`./drill/testdata/tsv/voter.tsv`; > I got the following error message: > +++ > | ok | summary | > +++ > | false | Error: Failure while accessing Zookeeper | > +++ > 1 row selected (0.595 seconds) > However, the view is actually created: > [root@qa-node56 ~]# hadoop fs -ls /drill/testdata/p1tests/views > Found 1 items > -rwxr-xr-x 3 mapr mapr683 2014-06-26 09:27 > /drill/testdata/p1tests/views/votertsv.v2.view.drill > I cannot query from the view: > 0: jdbc:drill:schema=dfs> select * from `dfs.default`.`views/votertsv.v2`; > "Failure while parsing sql. < ValidationException:[ > org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line > 1, column 27 ] < EigenbaseContextException:[ From line 1, column 15 to line > 1, column 27 ] < SqlValidatorException:[ Table > 'dfs.default.views/votertsv.v2' not found ]" -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-1082) Problems with creating views using a path
[ https://issues.apache.org/jira/browse/DRILL-1082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau updated DRILL-1082: -- Fix Version/s: (was: 1.0.0) 1.2.0 > Problems with creating views using a path > - > > Key: DRILL-1082 > URL: https://issues.apache.org/jira/browse/DRILL-1082 > Project: Apache Drill > Issue Type: Bug > Components: Metadata >Reporter: Krystal >Assignee: Jason Altekruse >Priority: Minor > Fix For: 1.2.0 > > > git.commit.id.abbrev=33c28f6 > I tried to create a view with a path relative to dfs.default schema: > 0: jdbc:drill:schema=dfs> create view `dfs.default`.`views/votertsv.v2` as > select columns[0] voter_id, columns[1] name, columns[2] age, columns[3] > registration,columns[4] contributions,columns[5] voterzone,columns[6] > create_time from `dfs`.`root`.`./drill/testdata/tsv/voter.tsv`; > I got the following error message: > +++ > | ok | summary | > +++ > | false | Error: Failure while accessing Zookeeper | > +++ > 1 row selected (0.595 seconds) > However, the view is actually created: > [root@qa-node56 ~]# hadoop fs -ls /drill/testdata/p1tests/views > Found 1 items > -rwxr-xr-x 3 mapr mapr683 2014-06-26 09:27 > /drill/testdata/p1tests/views/votertsv.v2.view.drill > I cannot query from the view: > 0: jdbc:drill:schema=dfs> select * from `dfs.default`.`views/votertsv.v2`; > "Failure while parsing sql. < ValidationException:[ > org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line > 1, column 27 ] < EigenbaseContextException:[ From line 1, column 15 to line > 1, column 27 ] < SqlValidatorException:[ Table > 'dfs.default.views/votertsv.v2' not found ]" -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-1082) Problems with creating views using a path
[ https://issues.apache.org/jira/browse/DRILL-1082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse updated DRILL-1082: --- Fix Version/s: (was: 0.9.0) 1.0.0 > Problems with creating views using a path > - > > Key: DRILL-1082 > URL: https://issues.apache.org/jira/browse/DRILL-1082 > Project: Apache Drill > Issue Type: Bug > Components: Metadata >Reporter: Krystal >Assignee: Jason Altekruse >Priority: Minor > Fix For: 1.0.0 > > > git.commit.id.abbrev=33c28f6 > I tried to create a view with a path relative to dfs.default schema: > 0: jdbc:drill:schema=dfs> create view `dfs.default`.`views/votertsv.v2` as > select columns[0] voter_id, columns[1] name, columns[2] age, columns[3] > registration,columns[4] contributions,columns[5] voterzone,columns[6] > create_time from `dfs`.`root`.`./drill/testdata/tsv/voter.tsv`; > I got the following error message: > +++ > | ok | summary | > +++ > | false | Error: Failure while accessing Zookeeper | > +++ > 1 row selected (0.595 seconds) > However, the view is actually created: > [root@qa-node56 ~]# hadoop fs -ls /drill/testdata/p1tests/views > Found 1 items > -rwxr-xr-x 3 mapr mapr683 2014-06-26 09:27 > /drill/testdata/p1tests/views/votertsv.v2.view.drill > I cannot query from the view: > 0: jdbc:drill:schema=dfs> select * from `dfs.default`.`views/votertsv.v2`; > "Failure while parsing sql. < ValidationException:[ > org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line > 1, column 27 ] < EigenbaseContextException:[ From line 1, column 15 to line > 1, column 27 ] < SqlValidatorException:[ Table > 'dfs.default.views/votertsv.v2' not found ]" -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-1082) Problems with creating views using a path
[ https://issues.apache.org/jira/browse/DRILL-1082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau updated DRILL-1082: -- Fix Version/s: (was: 0.8.0) 0.9.0 > Problems with creating views using a path > - > > Key: DRILL-1082 > URL: https://issues.apache.org/jira/browse/DRILL-1082 > Project: Apache Drill > Issue Type: Bug > Components: Metadata >Reporter: Krystal >Assignee: Jason Altekruse >Priority: Minor > Fix For: 0.9.0 > > > git.commit.id.abbrev=33c28f6 > I tried to create a view with a path relative to dfs.default schema: > 0: jdbc:drill:schema=dfs> create view `dfs.default`.`views/votertsv.v2` as > select columns[0] voter_id, columns[1] name, columns[2] age, columns[3] > registration,columns[4] contributions,columns[5] voterzone,columns[6] > create_time from `dfs`.`root`.`./drill/testdata/tsv/voter.tsv`; > I got the following error message: > +++ > | ok | summary | > +++ > | false | Error: Failure while accessing Zookeeper | > +++ > 1 row selected (0.595 seconds) > However, the view is actually created: > [root@qa-node56 ~]# hadoop fs -ls /drill/testdata/p1tests/views > Found 1 items > -rwxr-xr-x 3 mapr mapr683 2014-06-26 09:27 > /drill/testdata/p1tests/views/votertsv.v2.view.drill > I cannot query from the view: > 0: jdbc:drill:schema=dfs> select * from `dfs.default`.`views/votertsv.v2`; > "Failure while parsing sql. < ValidationException:[ > org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line > 1, column 27 ] < EigenbaseContextException:[ From line 1, column 15 to line > 1, column 27 ] < SqlValidatorException:[ Table > 'dfs.default.views/votertsv.v2' not found ]" -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-1082) Problems with creating views using a path
[ https://issues.apache.org/jira/browse/DRILL-1082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau updated DRILL-1082: -- Priority: Minor (was: Major) > Problems with creating views using a path > - > > Key: DRILL-1082 > URL: https://issues.apache.org/jira/browse/DRILL-1082 > Project: Apache Drill > Issue Type: Bug > Components: Metadata >Reporter: Krystal >Assignee: Jason Altekruse >Priority: Minor > Fix For: 0.8.0 > > > git.commit.id.abbrev=33c28f6 > I tried to create a view with a path relative to dfs.default schema: > 0: jdbc:drill:schema=dfs> create view `dfs.default`.`views/votertsv.v2` as > select columns[0] voter_id, columns[1] name, columns[2] age, columns[3] > registration,columns[4] contributions,columns[5] voterzone,columns[6] > create_time from `dfs`.`root`.`./drill/testdata/tsv/voter.tsv`; > I got the following error message: > +++ > | ok | summary | > +++ > | false | Error: Failure while accessing Zookeeper | > +++ > 1 row selected (0.595 seconds) > However, the view is actually created: > [root@qa-node56 ~]# hadoop fs -ls /drill/testdata/p1tests/views > Found 1 items > -rwxr-xr-x 3 mapr mapr683 2014-06-26 09:27 > /drill/testdata/p1tests/views/votertsv.v2.view.drill > I cannot query from the view: > 0: jdbc:drill:schema=dfs> select * from `dfs.default`.`views/votertsv.v2`; > "Failure while parsing sql. < ValidationException:[ > org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line > 1, column 27 ] < EigenbaseContextException:[ From line 1, column 15 to line > 1, column 27 ] < SqlValidatorException:[ Table > 'dfs.default.views/votertsv.v2' not found ]" -- This message was sent by Atlassian JIRA (v6.3.4#6332)