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

["Vova Vysotskyi (Jira)" <ji...@apache.org>]

Vova Vysotskyi created DRILL-7472:
-------------------------------------

             Summary: Complex queries on INFORMATION_SCHEMA fail when `planner.slice_target`is small
                 Key: DRILL-7472
                 URL: https://issues.apache.org/jira/browse/DRILL-7472
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.16.0
            Reporter: Vova Vysotskyi


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}
select * from information_schema.`tables` where TABLE_NAME='lineitem' order by TABLE_NAME;
{noformat}

Even when deserialization is fixed, it will fail when creating InfoSchemaBatchCreator:
{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)