Anton Gozhiy created DRILL-8143: ----------------------------------- Summary: 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 Attachments: extended.json
*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 -- This message was sent by Atlassian Jira (v8.20.1#820001)