drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Hsuan-Yi Chu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1343) Drill should timeout after short time if a storage plugin is unresponsive.
Date Fri, 21 Nov 2014 18:29:34 GMT

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

Sean Hsuan-Yi Chu updated DRILL-1343:
-------------------------------------
    Attachment: DRILL-1343.1.patch

The query "show tables;" works in this way: 
No matter which schema you specified at first, drill runs through all the schemas and grabs
the table list for each of them. 
And later based on which schema you wanted, drill returns that one.
(Maybe we need another solution?).

So when you have a non-responsive data source, "show tables;" hangs due to that data source
(even when you are running this query on another healthy data source).

According to my tests, Drill is able to skip the non-responsive data source, except for HBase.
I uploaded a patch to fix it. 

> Drill should timeout after short time if a storage plugin is unresponsive.
> --------------------------------------------------------------------------
>
>                 Key: DRILL-1343
>                 URL: https://issues.apache.org/jira/browse/DRILL-1343
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Zhiyong Liu
>            Assignee: Sean Hsuan-Yi Chu
>            Priority: Blocker
>             Fix For: 0.7.0
>
>         Attachments: DRILL-1343.1.patch
>
>
> git.commit.id.abbrev=654c879
> git.commit.id=654c879f7caa13925edca911de1b59d04d8f1a8b
> Start drillbit and sqlline with a schema specified, e.g.,
> sqlline -n admin -p admin -u "jdbc:drill:schema=dfs.TpcHMulti;zk=10.10.30.104:5181,10.10.30.105:5181,10.10.30.106:5181"
> Execute one of the following:
> show tables;
> select * from INFORMATION_SCHEMA.`TABLES`;
> The commands hang forever.  No exception was thrown in the log file.
> Note that if using zk=local, the second query works with no hanging problems.



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

Mime
View raw message