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)