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