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