[
https://issues.apache.org/jira/browse/DRILL-2943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14525620#comment-14525620
]
Aman Sinha commented on DRILL-2943:
-----------------------------------
The cause of the failure is actually an underlying Drill parser error:
{code}
Caused by: org.apache.drill.common.exceptions.ExpressionParsingException:
Expression has syntax error! line 1:25:mismatched input 'E' expecting CParen
org.apache.drill.common.expression.parser.ExprParser.displayRecognitionError(ExprParser.java:169)
~[classes/:na]
org.antlr.runtime.BaseRecognizer.reportError(BaseRecognizer.java:186)
~[antlr-runtime-3.4.jar:na]
{code}
The reason is Drill's ExprLexer checks for lowercase 'e' in the scientific
notation but not uppercase 'E'. Adding that resolves the issue. I will post
a patch with unit test shortly.
> Deserialization error for an Order-By of floating point number in 'exponent'
> representation
> -------------------------------------------------------------------------------------------
>
> Key: DRILL-2943
> URL: https://issues.apache.org/jira/browse/DRILL-2943
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - RPC
> Affects Versions: 0.9.0
> Reporter: Aman Sinha
> Assignee: Aman Sinha
>
> When doing an order-by of values that have a multiplicative floating-point
> constant, the jackson deserialization errors out due to the 'E' in the
> exponent representation.
> {code}
> alter session set `planner.slice_target` = 1;
> select c_acctbal * 0.0001 as x from cp.`tpch/customer.parquet` order by x;
> {code}
> {code}
> Caused by: com.fasterxml.jackson.databind.JsonMappingException: Expression
> has syntax error! line 1:25:mismatched input 'E' expecting CParen (through
> reference chain: java.util.ArrayList[0])
>
> com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:210)
> ~[jackson-databind-2.4.3.jar:2.4.3]
>
> com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:189)
> ~[jackson-databind-2.4.3.jar:2.4.3]
>
> com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:249)
> ~[jackson-databind-2.4.3.jar:2.4.3]
>
> com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:206)
> ~[jackson-databind-2.4.3.jar:2.4.3]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
