drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-2138) Failure while querying MapR-DB Views/Tables
Date Mon, 02 Feb 2015 17:21:35 GMT

     [ 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)

Mime
View raw message