You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Suresh Ollala (JIRA)" <ji...@apache.org> on 2014/11/08 00:24:33 UTC

[jira] [Resolved] (DRILL-1658) Queries fail when an unrelated storage plugin is not available

     [ https://issues.apache.org/jira/browse/DRILL-1658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Ollala resolved DRILL-1658.
----------------------------------
    Resolution: Duplicate

Duplicate of DRILL-1343

> Queries fail when an unrelated storage plugin is not available
> --------------------------------------------------------------
>
>                 Key: DRILL-1658
>                 URL: https://issues.apache.org/jira/browse/DRILL-1658
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Tomer Shiran
>
> Drill should be able to work when one of the data sources is not available. I queried the DFS while MongoDB was down and the query did not run (nothing in the query touched MongoDB). I would also expect "show databases" to be more informative in these scenarios (right now that command simply fails with some generic message).
> {code}
> 0: jdbc:drill:zk=local> select * from dfs.mydata.`yelp/user.json` limit 1;
> +---------------+------------+--------------+------------+------------+------------+---------------+------------+-------------+------------+------------+
> | yelping_since |   votes    | review_count |    name    |  user_id   |    fans    | average_stars |    type    | compliments |  friends   |   elite    |
> +---------------+------------+--------------+------------+------------+------------+---------------+------------+-------------+------------+------------+
> | 2012-02       | {"funny":1,"useful":5,"cool":0} | 6            | Lee        | qtrmBGNqCvupHMHL_bKFgQ | 0          | 3.83          | user       | {}          | []         | []         |
> +---------------+------------+--------------+------------+------------+------------+---------------+------------+-------------+------------+------------+
> 1 row selected (0.184 seconds)
> ************** HERE I ENABLED THE "mongo" STORAGE PLUGIN - NOTE THAT MONGODB IS NOT RUNNING **************
> 0: jdbc:drill:zk=local> select * from dfs.mydata.`yelp/user.json` limit 1;
> Query failed: Failure while parsing sql. Timed out while waiting to connect after 753 ms [76ca7a65-d9a2-43ac-a7a5-a58f61876ef6]
> Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)