[ https://issues.apache.org/jira/browse/DRILL-8143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anton Gozhiy updated DRILL-8143: -------------------------------- Description: *Test Data:* [^extended.json] attached. *Query:* {code:sql} select * from dfs.drillTestDir.`complex/drill-2879/extended.json` where name = 'd' {code} *Expected Results:* Query successful, no exception should be thrown. *Actual Result:* Exception happened: {noformat} UserRemoteException : INTERNAL_ERROR ERROR: Text '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR: Text '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 Fragment: 0:0 Please, refer to logs for more information. [Error Id: c984adbf-a455-4e0e-b3cd-b5aa7d83a765 on userf87d-pc:31010] (java.time.format.DateTimeParseException) Text '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 java.time.format.DateTimeFormatter.parseResolved0():2046 java.time.format.DateTimeFormatter.parse():1948 java.time.Instant.parse():395 org.apache.drill.exec.vector.complex.fn.VectorOutput$MapVectorOutput.writeTimestamp():364 org.apache.drill.exec.vector.complex.fn.VectorOutput.innerRun():115 org.apache.drill.exec.vector.complex.fn.VectorOutput$MapVectorOutput.run():308 org.apache.drill.exec.vector.complex.fn.JsonReader.writeMapDataIfTyped():386 org.apache.drill.exec.vector.complex.fn.JsonReader.writeData():262 org.apache.drill.exec.vector.complex.fn.JsonReader.writeDataSwitch():192 org.apache.drill.exec.vector.complex.fn.JsonReader.writeDocument():178 org.apache.drill.exec.store.easy.json.reader.BaseJsonReader.writeToVector():99 org.apache.drill.exec.store.easy.json.reader.BaseJsonReader.write():70 org.apache.drill.exec.store.easy.json.JSONRecordReader.next():234 org.apache.drill.exec.physical.impl.ScanBatch.internalNext():234 org.apache.drill.exec.physical.impl.ScanBatch.next():298 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.physical.impl.BaseRootExec.next():103 org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 org.apache.drill.exec.physical.impl.BaseRootExec.next():93 org.apache.drill.exec.work.fragment.FragmentExecutor.lambda$run$0():321 java.security.AccessController.doPrivileged():-2 javax.security.auth.Subject.doAs():423 org.apache.hadoop.security.UserGroupInformation.doAs():1762 org.apache.drill.exec.work.fragment.FragmentExecutor.run():310 org.apache.drill.common.SelfCleaningRunnable.run():38 java.util.concurrent.ThreadPoolExecutor.runWorker():1128 java.util.concurrent.ThreadPoolExecutor$Worker.run():628 java.lang.Thread.run():834 {noformat} *Note:* It is not reproducible in Drill 1.19.0 was: *Test Data:* extended.json attached. *Query:* # select * from dfs.drillTestDir.`complex/drill-2879/extended.json` where name = 'd' *Expected Results:* Query successful, no exception should be thrown. *Actual Result:* Exception happened: {noformat} UserRemoteException : INTERNAL_ERROR ERROR: Text '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR: Text '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 Fragment: 0:0 Please, refer to logs for more information. [Error Id: c984adbf-a455-4e0e-b3cd-b5aa7d83a765 on userf87d-pc:31010] (java.time.format.DateTimeParseException) Text '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 java.time.format.DateTimeFormatter.parseResolved0():2046 java.time.format.DateTimeFormatter.parse():1948 java.time.Instant.parse():395 org.apache.drill.exec.vector.complex.fn.VectorOutput$MapVectorOutput.writeTimestamp():364 org.apache.drill.exec.vector.complex.fn.VectorOutput.innerRun():115 org.apache.drill.exec.vector.complex.fn.VectorOutput$MapVectorOutput.run():308 org.apache.drill.exec.vector.complex.fn.JsonReader.writeMapDataIfTyped():386 org.apache.drill.exec.vector.complex.fn.JsonReader.writeData():262 org.apache.drill.exec.vector.complex.fn.JsonReader.writeDataSwitch():192 org.apache.drill.exec.vector.complex.fn.JsonReader.writeDocument():178 org.apache.drill.exec.store.easy.json.reader.BaseJsonReader.writeToVector():99 org.apache.drill.exec.store.easy.json.reader.BaseJsonReader.write():70 org.apache.drill.exec.store.easy.json.JSONRecordReader.next():234 org.apache.drill.exec.physical.impl.ScanBatch.internalNext():234 org.apache.drill.exec.physical.impl.ScanBatch.next():298 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():111 org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 org.apache.drill.exec.record.AbstractRecordBatch.next():170 org.apache.drill.exec.physical.impl.BaseRootExec.next():103 org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 org.apache.drill.exec.physical.impl.BaseRootExec.next():93 org.apache.drill.exec.work.fragment.FragmentExecutor.lambda$run$0():321 java.security.AccessController.doPrivileged():-2 javax.security.auth.Subject.doAs():423 org.apache.hadoop.security.UserGroupInformation.doAs():1762 org.apache.drill.exec.work.fragment.FragmentExecutor.run():310 org.apache.drill.common.SelfCleaningRunnable.run():38 java.util.concurrent.ThreadPoolExecutor.runWorker():1128 java.util.concurrent.ThreadPoolExecutor$Worker.run():628 java.lang.Thread.run():834 {noformat} *Note:* It is not reproducible in Drill 1.19.0 > Error querying json with $date field > ------------------------------------ > > Key: DRILL-8143 > URL: https://issues.apache.org/jira/browse/DRILL-8143 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.20.0 > Reporter: Anton Gozhiy > Priority: Major > Attachments: extended.json > > > *Test Data:* > [^extended.json] attached. > *Query:* > {code:sql} > select * from dfs.drillTestDir.`complex/drill-2879/extended.json` where name > = 'd' > {code} > *Expected Results:* > Query successful, no exception should be thrown. > *Actual Result:* > Exception happened: > {noformat} > UserRemoteException : INTERNAL_ERROR ERROR: Text > '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 > > org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR: > Text '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 > Fragment: 0:0 > Please, refer to logs for more information. > [Error Id: c984adbf-a455-4e0e-b3cd-b5aa7d83a765 on userf87d-pc:31010] > (java.time.format.DateTimeParseException) Text > '2015-03-12T21:54:31.809+0530' could not be parsed at index 23 > java.time.format.DateTimeFormatter.parseResolved0():2046 > java.time.format.DateTimeFormatter.parse():1948 > java.time.Instant.parse():395 > > org.apache.drill.exec.vector.complex.fn.VectorOutput$MapVectorOutput.writeTimestamp():364 > org.apache.drill.exec.vector.complex.fn.VectorOutput.innerRun():115 > > org.apache.drill.exec.vector.complex.fn.VectorOutput$MapVectorOutput.run():308 > > org.apache.drill.exec.vector.complex.fn.JsonReader.writeMapDataIfTyped():386 > org.apache.drill.exec.vector.complex.fn.JsonReader.writeData():262 > org.apache.drill.exec.vector.complex.fn.JsonReader.writeDataSwitch():192 > org.apache.drill.exec.vector.complex.fn.JsonReader.writeDocument():178 > > org.apache.drill.exec.store.easy.json.reader.BaseJsonReader.writeToVector():99 > org.apache.drill.exec.store.easy.json.reader.BaseJsonReader.write():70 > org.apache.drill.exec.store.easy.json.JSONRecordReader.next():234 > org.apache.drill.exec.physical.impl.ScanBatch.internalNext():234 > org.apache.drill.exec.physical.impl.ScanBatch.next():298 > org.apache.drill.exec.record.AbstractRecordBatch.next():119 > org.apache.drill.exec.record.AbstractRecordBatch.next():111 > org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 > org.apache.drill.exec.record.AbstractRecordBatch.next():170 > org.apache.drill.exec.record.AbstractRecordBatch.next():119 > org.apache.drill.exec.record.AbstractRecordBatch.next():111 > org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 > org.apache.drill.exec.record.AbstractRecordBatch.next():170 > org.apache.drill.exec.record.AbstractRecordBatch.next():119 > org.apache.drill.exec.record.AbstractRecordBatch.next():111 > org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 > org.apache.drill.exec.record.AbstractRecordBatch.next():170 > org.apache.drill.exec.record.AbstractRecordBatch.next():119 > org.apache.drill.exec.record.AbstractRecordBatch.next():111 > org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 > org.apache.drill.exec.record.AbstractRecordBatch.next():170 > org.apache.drill.exec.record.AbstractRecordBatch.next():119 > org.apache.drill.exec.record.AbstractRecordBatch.next():111 > org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext():59 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():85 > org.apache.drill.exec.record.AbstractRecordBatch.next():170 > org.apache.drill.exec.physical.impl.BaseRootExec.next():103 > > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 > org.apache.drill.exec.physical.impl.BaseRootExec.next():93 > org.apache.drill.exec.work.fragment.FragmentExecutor.lambda$run$0():321 > java.security.AccessController.doPrivileged():-2 > javax.security.auth.Subject.doAs():423 > org.apache.hadoop.security.UserGroupInformation.doAs():1762 > org.apache.drill.exec.work.fragment.FragmentExecutor.run():310 > org.apache.drill.common.SelfCleaningRunnable.run():38 > java.util.concurrent.ThreadPoolExecutor.runWorker():1128 > java.util.concurrent.ThreadPoolExecutor$Worker.run():628 > java.lang.Thread.run():834 > {noformat} > *Note:* It is not reproducible in Drill 1.19.0 -- This message was sent by Atlassian Jira (v8.20.1#820001)