You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Ravi Kiran (Jira)" <ji...@apache.org> on 2022/11/07 06:40:00 UTC

[jira] [Updated] (DRILL-8351) org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: Schema [root] is not valid with respect to either root schema or current default schema.

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

Ravi Kiran updated DRILL-8351:
------------------------------
    Description: 
Hi Team,

I have more than 100k records in my directory, but I am able to fetch only 100k records, not able to fetch after 100k records by using limit and offset.

I am attaching files also.

 

if i use 1.17 or 1.14 able to fetch all records.

 

SELECT * FROM dfs. `C:\Users\ravik\Downloads\test_folder` LIMIT 10000 OFFSET 90000

  was:
Hi Team,

I have more than 100k records in my directory, but I am able to fetch only 100k records, not able to fetch after 100k records by using limit and offset.

I am attaching files also.

 

if i use 1.17 or 1.14 able to fetch all records.

 

SELECT * FROM dfs. `C:\Users\ravik\Downloads\test_folder` OFFSET 100000


> org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: Schema [root] is not valid with respect to either root schema or current default schema.
> ------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-8351
>                 URL: https://issues.apache.org/jira/browse/DRILL-8351
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - Java
>         Environment: version 1.19 and 1.20.2
>            Reporter: Ravi Kiran
>            Priority: Critical
>
> Hi Team,
> I have more than 100k records in my directory, but I am able to fetch only 100k records, not able to fetch after 100k records by using limit and offset.
> I am attaching files also.
>  
> if i use 1.17 or 1.14 able to fetch all records.
>  
> SELECT * FROM dfs. `C:\Users\ravik\Downloads\test_folder` LIMIT 10000 OFFSET 90000



--
This message was sent by Atlassian Jira
(v8.20.10#820010)