[ https://issues.apache.org/jira/browse/DRILL-2138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Girish resolved DRILL-2138. ------------------------------------ Resolution: Later > Failure while querying MapR-DB Views/Tables > ------------------------------------------- > > Key: DRILL-2138 > URL: https://issues.apache.org/jira/browse/DRILL-2138 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 0.8.0 > Reporter: Abhishek Girish > Assignee: Jacques Nadeau > Priority: Critical > > I'm hitting an issue while querying views on top of MapR-DB tables. Issuing a > simple select * on any one of the views succeeds after which any subsequent > query fails, irrespective of the schema. > > select * from customer limit 1; > +------------+------------+------------+-------------+------------+------------+--------------+------------+ > | c_custkey | c_name | c_address | c_nationkey | c_phone | c_acctbal > | c_mktsegment | c_comment | > +------------+------------+------------+-------------+------------+------------+--------------+------------+ > | 1 | Customer#000000001 | IVhzIApeRb ot,c,E | 15 | > 25-989-741-2988 | 711.56 | BUILDING | to the even, regular platelets. > regular, ironic epitaphs nag e | > +------------+------------+------------+-------------+------------+------------+--------------+------------+ > 1 row selected (1.113 seconds) > > select * from customer limit 1; > Query failed: SqlValidatorException: Table 'customer' not found > Error: exception while executing query: Failure while executing query. > (state=,code=0) > > use dfs.tmp; > +------------+------------+ > | ok | summary | > +------------+------------+ > | true | Default schema changed to 'dfs.tmp' | > +------------+------------+ > 1 row selected (0.179 seconds) > > show files; > Query failed: IOException: Filesystem closed > Error: exception while executing query: Failure while executing query. > (state=,code=0) > Log: > 2015-02-01 18:39:29,437 [2b311c9e-2130-ead7-d1bc-df1148f48cff:foreman] INFO > o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING --> > FAILED > org.apache.drill.exec.planner.sql.QueryInputException: Failure handling SQL. > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:149) > ~[drill-java-exec-0.7.0-r3-SNAPSHOT-rebuffed.jar:0.7.0-r3-SNAPSHOT] > ... > Caused by: java.io.IOException: Filesystem closed > at com.mapr.fs.MapRFileSystem.checkOpen(MapRFileSystem.java:1359) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.lookupClient(MapRFileSystem.java:481) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.lookupClient(MapRFileSystem.java:567) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at > com.mapr.fs.MapRFileSystem.listMapRStatus(MapRFileSystem.java:1276) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.listStatus(MapRFileSystem.java:1334) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.listStatus(MapRFileSystem.java:66) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1519) > ~[hadoop-common-2.4.1-mapr-1408.jar:na] > ... > ... > 2015-02-01 18:39:29,443 [2b311c9e-2130-ead7-d1bc-df1148f48cff:foreman] ERROR > o.a.drill.exec.work.foreman.Foreman - Error > e55832c9-35a8-4287-9eb4-758b1b241cb1: IOException: Filesystem closed > org.apache.drill.exec.planner.sql.QueryInputException: Failure handling SQL. > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:149) > ~[drill-java-exec-0.7.0-r3-SNAPSHOT-rebuffed.jar:0.7.0-r3-SNAPSHOT] > ... > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65] > Caused by: java.io.IOException: Filesystem closed > at com.mapr.fs.MapRFileSystem.checkOpen(MapRFileSystem.java:1359) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.lookupClient(MapRFileSystem.java:481) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.lookupClient(MapRFileSystem.java:567) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at > com.mapr.fs.MapRFileSystem.listMapRStatus(MapRFileSystem.java:1276) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.listStatus(MapRFileSystem.java:1334) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at com.mapr.fs.MapRFileSystem.listStatus(MapRFileSystem.java:66) > ~[maprfs-4.0.1.28318-mapr.jar:4.0.1.28318-mapr] > at org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1519) > ~[hadoop-common-2.4.1-mapr-1408.jar:na] > ... > 2015-02-01 18:39:29,443 [2b311c9e-2130-ead7-d1bc-df1148f48cff:foreman] INFO > o.a.drill.exec.work.foreman.Foreman - foreman cleaning up - status: [] > I just verified that the issue is not observed on Drill 0.6, 0.7-r2. It is > observed on Drill 0.7-R3 & Drill 0.8 (Have logs from each run for reference) > Also, on Drill 0.7-R3 (& Drill 0.8), the issue is not observed when i query > any regular json/text/parquet files. This is seen only when I query any > MapR-DB table /view. After which I cannot query any file on any schema. On > restarting drill-bits, I can begin querying other schemas. -- This message was sent by Atlassian JIRA (v6.3.4#6332)