[
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)
