[
https://issues.apache.org/jira/browse/DRILL-8143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17495450#comment-17495450
]
ASF GitHub Bot commented on DRILL-8143:
---------------------------------------
agozhiy commented on pull request #2469:
URL: https://github.com/apache/drill/pull/2469#issuecomment-1046728785
@luocooong, it appears that in Java 8 only +-HH:mm offset format is
supported (while in Java 11 minutes are optional).
I suppose I need to add a custom formatter then, as there is no perfect
solution in predefined ones.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> 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
> Assignee: 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)
