[
https://issues.apache.org/jira/browse/DRILL-6251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vitalii Diravka reassigned DRILL-6251:
--------------------------------------
Assignee: Vitalii Diravka
> 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
> Assignee: Vitalii Diravka
> Priority: Major
>
> 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 | [email protected] | 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 no failure on local debian machine with Drill 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)
