[jira] [Commented] (DRILL-8404) not able read the values properly if column value has double quotes("")
[
https://issues.apache.org/jira/browse/DRILL-8404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693104#comment-17693104
]
Ravi Kiran commented on DRILL-8404:
---
we are getting extra slashesh(\\\), i don't want slashesh actually
"Nikita,"test"" just i want show like this and my actual value is
"Nikita,"test"".
> not able read the values properly if column value has double quotes("")
> ---
>
> Key: DRILL-8404
> URL: https://issues.apache.org/jira/browse/DRILL-8404
> Project: Apache Drill
> Issue Type: Bug
>Reporter: Ravi Kiran
>Priority: Major
> Attachments: Screenshot_20230224_151019.png,
> WFTABLE-20230224144653.csv
>
>
> Hi Team,
> I am trying to read csv file seperated with Cap(^) symbol and that csv file
> has columns but some of the column value is "Nikita,\"test\"" like this but
> while trying to read this value from drill i am getting "Nikita,\\\"test\\\"
> like this, could you please help on this.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Created] (DRILL-8404) not able read the values properly if column value has double quotes("")
Ravi Kiran created DRILL-8404:
-
Summary: not able read the values properly if column value has
double quotes("")
Key: DRILL-8404
URL: https://issues.apache.org/jira/browse/DRILL-8404
Project: Apache Drill
Issue Type: Bug
Reporter: Ravi Kiran
Attachments: Screenshot_20230224_151019.png, WFTABLE-20230224144653.csv
Hi Team,
I am trying to read csv file seperated with Cap(^) symbol and that csv file has
columns but some of the column value is "Nikita,\"test\"" like this but while
trying to read this value from drill i am getting "Nikita,\\\"test\\\" like
this, could you please help on this.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Commented] (DRILL-8351) UserRemoteException : SYSTEM ERROR: NullPointerException: Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a
[ https://issues.apache.org/jira/browse/DRILL-8351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17631468#comment-17631468 ] Ravi Kiran commented on DRILL-8351: --- [~dzamo] checking with client. > UserRemoteException :SYSTEM ERROR: NullPointerException: Schema is > currently null. You must call buildSchema(SelectionVectorMode) before this > container can return a 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 > Attachments: SUPPLIERS-20220720082618924.csv, > SUPPLIERS-20220720082618936-2.csv, SUPPLIERS-20220720082618946-1.csv, > SUPPLIERS-20220720082618958-2.csv, SUPPLIERS-2022072008261930.csv > > > 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 1 OFFSET > 9 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (DRILL-8351) UserRemoteException : SYSTEM ERROR: NullPointerException: Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a
[ https://issues.apache.org/jira/browse/DRILL-8351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17630492#comment-17630492 ] Ravi Kiran commented on DRILL-8351: --- Thanks James, but my project will not allow snapshot version, so when can we except next release version wit h drill master 2.0. > UserRemoteException :SYSTEM ERROR: NullPointerException: Schema is > currently null. You must call buildSchema(SelectionVectorMode) before this > container can return a 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 > Attachments: SUPPLIERS-20220720082618924.csv, > SUPPLIERS-20220720082618936-2.csv, SUPPLIERS-20220720082618946-1.csv, > SUPPLIERS-20220720082618958-2.csv, SUPPLIERS-2022072008261930.csv > > > 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 1 OFFSET > 9 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (DRILL-8351) UserRemoteException : SYSTEM ERROR: NullPointerException: Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a
[ https://issues.apache.org/jira/browse/DRILL-8351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17630262#comment-17630262 ] Ravi Kiran commented on DRILL-8351: --- please find the logs org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: NullPointerException: Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a schema.Fragment: 1:0Please, refer to logs for more information.[Error Id: b8d2ac8e-ecbf-48f1-93ba-b1c1d50709c5 on DESKTOP-PHN06EQ:31010] at org.apache.drill.exec.server.rest.RestQueryRunner.submitQuery(RestQueryRunner.java:99) at org.apache.drill.exec.server.rest.RestQueryRunner.run(RestQueryRunner.java:54) at org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:158) at jdk.internal.reflect.GeneratedMethodAccessor244.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) at org.glassfish.jersey.internal.Errors.process(Errors.java:292) at org.glassfish.jersey.internal.Errors.process(Errors.java:274) at org.glassfish.jersey.internal.Errors.process(Errors.java:244) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1631) at org.apache.drill.exec.server.rest.header.ResponseHeadersSettingFilter.doFilter(ResponseHeadersSettingFilter.java:71) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) at org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter(CsrfTokenValidateFilter.java:55) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) at org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(CsrfTokenInjectFilter.java:54) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) at
[jira] [Updated] (DRILL-8351) UserRemoteException : SYSTEM ERROR: NullPointerException: Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a s
[ https://issues.apache.org/jira/browse/DRILL-8351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ravi Kiran updated DRILL-8351: -- Attachment: SUPPLIERS-2022072008261930.csv SUPPLIERS-20220720082618924.csv SUPPLIERS-20220720082618936-2.csv SUPPLIERS-20220720082618946-1.csv SUPPLIERS-20220720082618958-2.csv > UserRemoteException :SYSTEM ERROR: NullPointerException: Schema is > currently null. You must call buildSchema(SelectionVectorMode) before this > container can return a 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 > Attachments: SUPPLIERS-20220720082618924.csv, > SUPPLIERS-20220720082618936-2.csv, SUPPLIERS-20220720082618946-1.csv, > SUPPLIERS-20220720082618958-2.csv, SUPPLIERS-2022072008261930.csv > > > 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 1 OFFSET > 9 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (DRILL-8351) UserRemoteException : SYSTEM ERROR: NullPointerException: Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a s
[ https://issues.apache.org/jira/browse/DRILL-8351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ravi Kiran updated DRILL-8351: -- Summary: UserRemoteException : SYSTEM ERROR: NullPointerException: Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a schema. (was: org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: Schema [root] is not valid with respect to either root schema or current default schema.) > UserRemoteException :SYSTEM ERROR: NullPointerException: Schema is > currently null. You must call buildSchema(SelectionVectorMode) before this > container can return a 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 1 OFFSET > 9 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[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 1 OFFSET 9 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 10 > 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 1 OFFSET > 9 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (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.
Ravi Kiran created DRILL-8351: - Summary: 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 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 10 -- This message was sent by Atlassian Jira (v8.20.10#820010)
