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 <[email protected]> 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 <[email protected]> > 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). > > >
