You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Prabhakar Bhosale <bh...@gmail.com> on 2022/07/01 14:53:11 UTC
Drill- Querying JSON file
Hi Team,
I am trying to query a JSON file and getting an error as below
invalid format: "2018-08-28" is malformed at "18-08-28".
I checked the JSON again and again and the JSON format is correct. The file
contains only one JSON object. Please guide.
The detailed log is below.
[Error Id: 871d14f4-edc2-463f-a7ca-21e8ef07c400 on xxxxxx.com:31010]
at
org.apache.drill.exec.server.rest.QueryWrapper.run(QueryWrapper.java:126)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(QueryResources.java:74)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:90)
~[drill-java-exec-1.16.0.jar:1.16.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_332]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_332]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_332]
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
[jersey-server-2.25.1.jar:na]
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
[jersey-server-2.25.1.jar:na]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
[jersey-common-2.25.1.jar:na]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
[jersey-common-2.25.1.jar:na]
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
[jersey-common-2.25.1.jar:na]
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
[jersey-common-2.25.1.jar:na]
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
[jersey-common-2.25.1.jar:na]
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
[jersey-common-2.25.1.jar:na]
at
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
[jersey-server-2.25.1.jar:na]
at
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
[jersey-container-servlet-core-2.25.1.jar:na]
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
[jersey-container-servlet-core-2.25.1.jar:na]
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
[jersey-container-servlet-core-2.25.1.jar:na]
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
[jersey-container-servlet-core-2.25.1.jar:na]
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
[jersey-container-servlet-core-2.25.1.jar:na]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)
[jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
[jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513)
[jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at org.eclipse.jetty.server.Server.handle(Server.java:539)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
[jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
[jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
[jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
[jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
[jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
[jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
[jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
[jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
at
org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
[jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
at java.lang.Thread.run(Thread.java:750) [na:1.8.0_332]
java.lang.IllegalArgumentException: Invalid format: "2018-08-28" is
malformed at "18-08-28"
at
org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:899)
~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
at org.joda.time.DateMidnight.parse(DateMidnight.java:152)
~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.test.generated.FiltererGen0.doEval(FilterTemplate2.java:199)
~[na:na]
at
org.apache.drill.exec.test.generated.FiltererGen0.filterBatchNoSV(FilterTemplate2.java:106)
~[na:na]
at
org.apache.drill.exec.test.generated.FiltererGen0.filterBatch(FilterTemplate2.java:76)
~[na:na]
at
org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.doWork(FilterRecordBatch.java:82)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:117)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:69)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.loadBatch(ExternalSortBatch.java:410)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.load(ExternalSortBatch.java:360)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.innerNext(ExternalSortBatch.java:315)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:83)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:296)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:283)
~[drill-java-exec-1.16.0.jar:1.16.0]
at .......(:0) ~[na:na]
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1746)
~[hadoop-common-2.7.4.jar:na]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:283)
~[drill-java-exec-1.16.0.jar:1.16.0]
at
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
~[drill-common-1.16.0.jar:1.16.0]
at .......(:0) ~[na:na]
2022-07-01 19:42:29,470 [1d40ff4b-f1fe-0837-8704-33631d4591a5:frag:0:0]
WARN o.a.d.e.w.f.QueryStateProcessor - Dropping request to move to
COMPLETED state as query is already at FAILED state (which is terminal).
Re: Drill- Querying JSON file
Posted by luoc <lu...@apache.org>.
Well, I'm happy to hear that.
> 2022年7月8日 下午4:06，Prabhakar Bhosale <bh...@gmail.com> 写道：
>
> Hi Luoc,
> The problem is resolved. It was having some incorrect format mentioned in
> the TO_DATE function. Thanks for your help.
>
> Regards
> Prabhakar
>
> On Sat, Jul 2, 2022 at 1:00 PM luoc <lu...@apache.org> wrote:
>
>>
>> Hi,
>> What is your query text?
>> Also, version 1.16 is too old, do you have a chance to upgrade to 1.20.1?
>>
>>> On Jul 1, 2022, at 22:54, Prabhakar Bhosale <bh...@gmail.com>
>> wrote:
>>>
>>> Hi Team,
>>>
>>> I am trying to query a JSON file and getting an error as below
>>> invalid format: "2018-08-28" is malformed at "18-08-28".
>>>
>>> I checked the JSON again and again and the JSON format is correct. The
>> file
>>> contains only one JSON object. Please guide.
>>>
>>> The detailed log is below.
>>> [Error Id: 871d14f4-edc2-463f-a7ca-21e8ef07c400 on xxxxxx.com:31010]
>>> at
>>> org.apache.drill.exec.server.rest.QueryWrapper.run(QueryWrapper.java:126)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(QueryResources.java:74)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:90)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> ~[na:1.8.0_332]
>>> at
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>> ~[na:1.8.0_332]
>>> at
>>>
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>> ~[na:1.8.0_332]
>>> at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_332]
>>> at
>>>
>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
>>> [jersey-server-2.25.1.jar:na]
>>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
>>> [jersey-common-2.25.1.jar:na]
>>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
>>> [jersey-common-2.25.1.jar:na]
>>> at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
>>> [jersey-common-2.25.1.jar:na]
>>> at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
>>> [jersey-common-2.25.1.jar:na]
>>> at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
>>> [jersey-common-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
>>> [jersey-common-2.25.1.jar:na]
>>> at
>>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
>>> [jersey-server-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
>>> [jersey-container-servlet-core-2.25.1.jar:na]
>>> at
>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
>>> [jersey-container-servlet-core-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
>>> [jersey-container-servlet-core-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
>>> [jersey-container-servlet-core-2.25.1.jar:na]
>>> at
>>>
>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
>>> [jersey-container-servlet-core-2.25.1.jar:na]
>>> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)
>>> [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
>>> [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513)
>>> [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at org.eclipse.jetty.server.Server.handle(Server.java:539)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
>>> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>> org.eclipse.jetty.io
>> .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
>>> [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
>>> [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>> org.eclipse.jetty.io
>> .SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
>>> [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
>>> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
>>> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
>>> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
>>> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at
>>>
>> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
>>> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
>>> at java.lang.Thread.run(Thread.java:750) [na:1.8.0_332]
>>> java.lang.IllegalArgumentException: Invalid format: "2018-08-28" is
>>> malformed at "18-08-28"
>>> at
>>>
>> org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:899)
>>> ~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
>>> at org.joda.time.DateMidnight.parse(DateMidnight.java:152)
>>> ~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.test.generated.FiltererGen0.doEval(FilterTemplate2.java:199)
>>> ~[na:na]
>>> at
>>>
>> org.apache.drill.exec.test.generated.FiltererGen0.filterBatchNoSV(FilterTemplate2.java:106)
>>> ~[na:na]
>>> at
>>>
>> org.apache.drill.exec.test.generated.FiltererGen0.filterBatch(FilterTemplate2.java:76)
>>> ~[na:na]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.doWork(FilterRecordBatch.java:82)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:117)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:69)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.loadBatch(ExternalSortBatch.java:410)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.load(ExternalSortBatch.java:360)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.innerNext(ExternalSortBatch.java:315)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:83)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>> org.apache.drill.exec.work
>> .fragment.FragmentExecutor$1.run(FragmentExecutor.java:296)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>> org.apache.drill.exec.work
>> .fragment.FragmentExecutor$1.run(FragmentExecutor.java:283)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at .......(:0) ~[na:na]
>>> at
>>>
>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1746)
>>> ~[hadoop-common-2.7.4.jar:na]
>>> at
>>> org.apache.drill.exec.work
>> .fragment.FragmentExecutor.run(FragmentExecutor.java:283)
>>> ~[drill-java-exec-1.16.0.jar:1.16.0]
>>> at
>>>
>> org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
>>> ~[drill-common-1.16.0.jar:1.16.0]
>>> at .......(:0) ~[na:na]
>>> 2022-07-01 19:42:29,470 [1d40ff4b-f1fe-0837-8704-33631d4591a5:frag:0:0]
>>> WARN o.a.d.e.w.f.QueryStateProcessor - Dropping request to move to
>>> COMPLETED state as query is already at FAILED state (which is terminal).
>>>
>>
>
Re: Drill- Querying JSON file
Posted by Prabhakar Bhosale <bh...@gmail.com>.
Hi Luoc,
The problem is resolved. It was having some incorrect format mentioned in
the TO_DATE function. Thanks for your help.
Regards
Prabhakar
On Sat, Jul 2, 2022 at 1:00 PM luoc <lu...@apache.org> wrote:
>
> Hi,
> What is your query text?
> Also, version 1.16 is too old, do you have a chance to upgrade to 1.20.1?
>
> > On Jul 1, 2022, at 22:54, Prabhakar Bhosale <bh...@gmail.com>
> wrote:
> >
> > Hi Team,
> >
> > I am trying to query a JSON file and getting an error as below
> > invalid format: "2018-08-28" is malformed at "18-08-28".
> >
> > I checked the JSON again and again and the JSON format is correct. The
> file
> > contains only one JSON object. Please guide.
> >
> > The detailed log is below.
> > [Error Id: 871d14f4-edc2-463f-a7ca-21e8ef07c400 on xxxxxx.com:31010]
> > at
> > org.apache.drill.exec.server.rest.QueryWrapper.run(QueryWrapper.java:126)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(QueryResources.java:74)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:90)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > ~[na:1.8.0_332]
> > at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> > ~[na:1.8.0_332]
> > at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > ~[na:1.8.0_332]
> > at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_332]
> > at
> >
> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
> > [jersey-server-2.25.1.jar:na]
> > at
> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
> > [jersey-server-2.25.1.jar:na]
> > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
> > [jersey-common-2.25.1.jar:na]
> > at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
> > [jersey-common-2.25.1.jar:na]
> > at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> > [jersey-common-2.25.1.jar:na]
> > at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> > [jersey-common-2.25.1.jar:na]
> > at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
> > [jersey-common-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
> > [jersey-common-2.25.1.jar:na]
> > at
> > org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
> > [jersey-server-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
> > [jersey-container-servlet-core-2.25.1.jar:na]
> > at
> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
> > [jersey-container-servlet-core-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
> > [jersey-container-servlet-core-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
> > [jersey-container-servlet-core-2.25.1.jar:na]
> > at
> >
> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
> > [jersey-container-servlet-core-2.25.1.jar:na]
> > at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)
> > [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
> > [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513)
> > [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at org.eclipse.jetty.server.Server.handle(Server.java:539)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
> > [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> > org.eclipse.jetty.io
> .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
> > [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
> > [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> > org.eclipse.jetty.io
> .SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
> > [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
> > [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
> > [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
> > [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
> > [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at
> >
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
> > [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> > at java.lang.Thread.run(Thread.java:750) [na:1.8.0_332]
> > java.lang.IllegalArgumentException: Invalid format: "2018-08-28" is
> > malformed at "18-08-28"
> > at
> >
> org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:899)
> > ~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
> > at org.joda.time.DateMidnight.parse(DateMidnight.java:152)
> > ~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.test.generated.FiltererGen0.doEval(FilterTemplate2.java:199)
> > ~[na:na]
> > at
> >
> org.apache.drill.exec.test.generated.FiltererGen0.filterBatchNoSV(FilterTemplate2.java:106)
> > ~[na:na]
> > at
> >
> org.apache.drill.exec.test.generated.FiltererGen0.filterBatch(FilterTemplate2.java:76)
> > ~[na:na]
> > at
> >
> org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.doWork(FilterRecordBatch.java:82)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:117)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:69)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.loadBatch(ExternalSortBatch.java:410)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.load(ExternalSortBatch.java:360)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.innerNext(ExternalSortBatch.java:315)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:83)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> > org.apache.drill.exec.work
> .fragment.FragmentExecutor$1.run(FragmentExecutor.java:296)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> > org.apache.drill.exec.work
> .fragment.FragmentExecutor$1.run(FragmentExecutor.java:283)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at .......(:0) ~[na:na]
> > at
> >
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1746)
> > ~[hadoop-common-2.7.4.jar:na]
> > at
> > org.apache.drill.exec.work
> .fragment.FragmentExecutor.run(FragmentExecutor.java:283)
> > ~[drill-java-exec-1.16.0.jar:1.16.0]
> > at
> >
> org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
> > ~[drill-common-1.16.0.jar:1.16.0]
> > at .......(:0) ~[na:na]
> > 2022-07-01 19:42:29,470 [1d40ff4b-f1fe-0837-8704-33631d4591a5:frag:0:0]
> > WARN o.a.d.e.w.f.QueryStateProcessor - Dropping request to move to
> > COMPLETED state as query is already at FAILED state (which is terminal).
> >
>
Re: Drill- Querying JSON file
Posted by luoc <lu...@apache.org>.
Hi,
What is your query text?
Also, version 1.16 is too old, do you have a chance to upgrade to 1.20.1?
> On Jul 1, 2022, at 22:54, Prabhakar Bhosale <bh...@gmail.com> wrote:
>
> Hi Team,
>
> I am trying to query a JSON file and getting an error as below
> invalid format: "2018-08-28" is malformed at "18-08-28".
>
> I checked the JSON again and again and the JSON format is correct. The file
> contains only one JSON object. Please guide.
>
> The detailed log is below.
> [Error Id: 871d14f4-edc2-463f-a7ca-21e8ef07c400 on xxxxxx.com:31010]
> at
> org.apache.drill.exec.server.rest.QueryWrapper.run(QueryWrapper.java:126)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(QueryResources.java:74)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:90)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_332]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_332]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_332]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_332]
> at
> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
> [jersey-server-2.25.1.jar:na]
> at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
> [jersey-server-2.25.1.jar:na]
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
> [jersey-common-2.25.1.jar:na]
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
> [jersey-common-2.25.1.jar:na]
> at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> [jersey-common-2.25.1.jar:na]
> at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> [jersey-common-2.25.1.jar:na]
> at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
> [jersey-common-2.25.1.jar:na]
> at
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
> [jersey-common-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
> [jersey-server-2.25.1.jar:na]
> at
> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
> [jersey-container-servlet-core-2.25.1.jar:na]
> at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
> [jersey-container-servlet-core-2.25.1.jar:na]
> at
> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
> [jersey-container-servlet-core-2.25.1.jar:na]
> at
> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
> [jersey-container-servlet-core-2.25.1.jar:na]
> at
> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
> [jersey-container-servlet-core-2.25.1.jar:na]
> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)
> [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
> [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513)
> [jetty-servlet-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at org.eclipse.jetty.server.Server.handle(Server.java:539)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
> [jetty-server-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
> [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
> [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
> [jetty-io-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
> [jetty-util-9.3.25.v20180904.jar:9.3.25.v20180904]
> at java.lang.Thread.run(Thread.java:750) [na:1.8.0_332]
> java.lang.IllegalArgumentException: Invalid format: "2018-08-28" is
> malformed at "18-08-28"
> at
> org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:899)
> ~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
> at org.joda.time.DateMidnight.parse(DateMidnight.java:152)
> ~[drill-hive-exec-shaded-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.test.generated.FiltererGen0.doEval(FilterTemplate2.java:199)
> ~[na:na]
> at
> org.apache.drill.exec.test.generated.FiltererGen0.filterBatchNoSV(FilterTemplate2.java:106)
> ~[na:na]
> at
> org.apache.drill.exec.test.generated.FiltererGen0.filterBatch(FilterTemplate2.java:76)
> ~[na:na]
> at
> org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.doWork(FilterRecordBatch.java:82)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:117)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:69)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.loadBatch(ExternalSortBatch.java:410)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.load(ExternalSortBatch.java:360)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.xsort.managed.ExternalSortBatch.innerNext(ExternalSortBatch.java:315)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:83)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:296)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:283)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at .......(:0) ~[na:na]
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1746)
> ~[hadoop-common-2.7.4.jar:na]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:283)
> ~[drill-java-exec-1.16.0.jar:1.16.0]
> at
> org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
> ~[drill-common-1.16.0.jar:1.16.0]
> at .......(:0) ~[na:na]
> 2022-07-01 19:42:29,470 [1d40ff4b-f1fe-0837-8704-33631d4591a5:frag:0:0]
> WARN o.a.d.e.w.f.QueryStateProcessor - Dropping request to move to
> COMPLETED state as query is already at FAILED state (which is terminal).
>