You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Vitalii Diravka (JIRA)" <ji...@apache.org> on 2018/03/15 17:25:00 UTC
[jira] [Created] (DRILL-6251) Queries from system tables are hang
Vitalii Diravka created DRILL-6251:
--------------------------------------
Summary: Queries from system tables are hang
Key: DRILL-6251
URL: https://issues.apache.org/jira/browse/DRILL-6251
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow
Affects Versions: 1.13.0
Reporter: Vitalii Diravka
On CentoOS cluster Drill hangs while querying sys tables after "use dfs;" (embedded or distributed mode):
{code}
0: jdbc:drill:> select * from sys.version;
+----------+-------------------------------------------+------------------------------------------------------+----------------------------+--------------------+----------------------------+
| version | commit_id | commit_message | commit_time | build_email | build_time |
+----------+-------------------------------------------+------------------------------------------------------+----------------------------+--------------------+----------------------------+
| 1.13.0 | 796fcf051b3553c4597abbdca5ca247b139734ba | [maven-release-plugin] prepare release drill-1.13.0 | 13.03.2018 @ 11:39:14 IST | parthc@apache.org | 13.03.2018 @ 13:13:45 IST |
+----------+-------------------------------------------+------------------------------------------------------+----------------------------+--------------------+----------------------------+
1 row selected (3.784 seconds)
0: jdbc:drill:> use dfs;
+-------+----------------------------------+
| ok | summary |
+-------+----------------------------------+
| true | Default schema changed to [dfs] |
+-------+----------------------------------+
1 row selected (0.328 seconds)
0: jdbc:drill:> select * from sys.version;
Error: Statement canceled (state=,code=0)
0: jdbc:drill:>
{code}
*Note*: there is not failure on local debian machine in embedded mode.
dfs pugin configs are default (with "connection": "file:///", other file systems works good).
This failure is connected to DRILL-5089 and calcite rebase.
Related commits:
https://github.com/apache/drill/commit/450e67094eb6e9a6484d7f86c49b51c77a08d7b2
https://github.com/apache/drill/commit/18a71a38f6bd1fd33d21d1c68fc23c5901b0080a
After analyzing in remote debug I found the following flow:
"dfs" DynamicRootSchema is created, then a new "sys" one is created.
After calcite validate "sys" SimpleCalciteSchema is created. But in WorkspaceSchemaFactory#create wrong WorkspaceConfig is left and "/" is combined with "sys".
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)