You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (Jira)" <ji...@apache.org> on 2020/01/02 14:15:00 UTC

[jira] [Updated] (DRILL-7488) Complex queries on INFORMATION_SCHEMA fail when `planner.slice_target` is small

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

Arina Ielchiieva updated DRILL-7488:
------------------------------------
    Summary: Complex queries on INFORMATION_SCHEMA fail when `planner.slice_target` is small  (was: Complex queries on INFORMATION_SCHEMA fail when `planner.slice_target`is small)

> Complex queries on INFORMATION_SCHEMA fail when `planner.slice_target` is small
> -------------------------------------------------------------------------------
>
>                 Key: DRILL-7488
>                 URL: https://issues.apache.org/jira/browse/DRILL-7488
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.16.0
>            Reporter: Arina Ielchiieva
>            Priority: Major
>
> Set small value for slice_target:
> {code:sql}
> alter session set `planner.slice_target`=1;
> {code}
> Run query on INFORMATION_SCHEMA:
> {code:sql}
> select * from information_schema.`tables` where TABLE_NAME='lineitem' order by TABLE_NAME;
> {code}
> It will fail with the following exception:
> {noformat}
> java.lang.Exception: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: UnsupportedOperationException: Schema tree can only be created in root fragment. This is a non-root fragment.
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)