I ran the Windows TestDecimal unit tests with ExecConstants.java modified as
suggested. The failure looks like follows:
Operating system: Windows 7
Windows hack for parquet: setting hadoop.home.dir to c:\winutil\
Running org.apache.drill.exec.physical.impl.TestDecimal#testCastFromFloat
Query: {
"head" : {
"version" : 1,
"generator" : {
"type" : "org.apache.drill.exec.planner.logical.DrillImplementor",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"resultMode" : "EXEC"
},
graph:[
{
@id:1,
pop:"fs-scan",
format: {type: "json"},
storage:{type: "file", connection: "classpath:///"},
files:["/input_simple_decimal.json"]
}, {
"pop" : "project",
"@id" : 2,
"exprs" : [ {
"ref" : "F4",
"expr" : " (cast(DEC9 as float4)) "
},
{ "ref" : "F8", "expr": "(cast(DEC18 as float8))" }
],
"child" : 1
},
{
"pop" : "project",
"@id" : 4,
"exprs" : [ {
"ref" : "DECIMAL_9",
"expr" : " cast(F4 as decimal9(9, 4)) "
},
{"ref": "DECIMAL38", "expr" : "cast(F8 as decimal38sparse(38, 4))"}
],
"child" : 2
},
{
"pop" : "screen",
"@id" : 5,
"child" : 4
} ]
}
mapException1: java.util.concurrent.ExecutionException:
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
PatternSyntaxException: Unexpected internal error near index 1
\
^
[Error Id: f99ad9ee-bc5b-4001-9568-cb806a1a2875 on
DaveOshinsky-PC.gp.cv.commvault.com:31010]
(org.apache.drill.exec.work.foreman.ForemanSetupException) Failure while
parsing physical plan.
org.apache.drill.exec.work.foreman.Foreman.parseAndRunPhysicalPlan():391
org.apache.drill.exec.work.foreman.Foreman.run():248
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (com.fasterxml.jackson.databind.JsonMappingException) Instantiation
of [simple type, class org.apache.drill.exec.store.dfs.easy.EasyGroupScan]
value failed (java.util.regex.PatternSyntaxException): Unexpected internal
error near index 1
\
^
at [Source: {
"head" : {
"version" : 1,
"generator" : {
"type" : "org.apache.drill.exec.planner.logical.DrillImplementor",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"resultMode" : "EXEC"
},
graph:[
{
@id:1,
pop:"fs-scan",
format: {type: "json"},
storage:{type: "file", connection: "classpath:///"},
files:["/input_simple_decimal.json"]
}, {
"pop" : "project",
"@id" : 2,
"exprs" : [ {
"ref" : "F4",
"expr" : " (cast(DEC9 as float4)) "
},
{ "ref" : "F8", "expr": "(cast(DEC18 as float8))" }
],
"child" : 1
},
{
"pop" : "project",
"@id" : 4,
"exprs" : [ {
"ref" : "DECIMAL_9",
"expr" : " cast(F4 as decimal9(9, 4)) "
},
{"ref": "DECIMAL38", "expr" : "cast(F8 as decimal38sparse(38, 4))"}
],
"child" : 2
},
{
"pop" : "screen",
"@id" : 5,
"child" : 4
} ]
}; line: 18, column: 3] (through reference chain:
org.apache.drill.exec.physical.PhysicalPlan["graph"]->java.util.ArrayList[0])
com.fasterxml.jackson.databind.JsonMappingException.from():223
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.wrapAsJsonMappingException():445
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.rewrapCtorProblem():464
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.createFromObjectWith():258
com.fasterxml.jackson.databind.deser.impl.PropertyBasedCreator.build():135
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():444
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1094
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142
com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize():279
com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize():249
com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize():26
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():490
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():380
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():133
com.fasterxml.jackson.databind.ObjectReader._bindAndClose():1575
com.fasterxml.jackson.databind.ObjectReader.readValue():1200
org.apache.drill.exec.planner.PhysicalPlanReader.readPhysicalPlan():89
org.apache.drill.exec.work.foreman.Foreman.parseAndRunPhysicalPlan():388
org.apache.drill.exec.work.foreman.Foreman.run():248
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (java.util.regex.PatternSyntaxException) Unexpected internal error
near index 1
\
^
java.util.regex.Pattern.error():1955
java.util.regex.Pattern.compile():1702
java.util.regex.Pattern.<init>():1351
java.util.regex.Pattern.compile():1028
java.lang.String.split():2380
java.lang.String.split():2422
org.apache.drill.exec.store.dfs.FileSelection.commonPathForFiles():197
org.apache.drill.exec.store.dfs.FileSelection.create():261
org.apache.drill.exec.store.dfs.easy.EasyGroupScan.<init>():81
sun.reflect.NativeConstructorAccessorImpl.newInstance0():-2
sun.reflect.NativeConstructorAccessorImpl.newInstance():62
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
com.fasterxml.jackson.databind.introspect.AnnotatedConstructor.call():114
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.createFromObjectWith():256
com.fasterxml.jackson.databind.deser.impl.PropertyBasedCreator.build():135
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():444
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1094
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142
com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize():279
com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize():249
com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize():26
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():490
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():380
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():133
com.fasterxml.jackson.databind.ObjectReader._bindAndClose():1575
com.fasterxml.jackson.databind.ObjectReader.readValue():1200
org.apache.drill.exec.planner.PhysicalPlanReader.readPhysicalPlan():89
org.apache.drill.exec.work.foreman.Foreman.parseAndRunPhysicalPlan():388
org.apache.drill.exec.work.foreman.Foreman.run():248
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
-----Original Message-----
From: amansinha100 [mailto:[email protected]]
Sent: Sunday, June 19, 2016 11:08 PM
To: [email protected]
Subject: [GitHub] drill issue #517: DRILL-4704 fix
Github user amansinha100 commented on the issue:
https://github.com/apache/drill/pull/517
Sorry for the delay. Can you force the following flag to TRUE to get the
more detailed stack trace ?
https://github.com/apache/drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/ExecConstants.java#L262
(normally, one would do an 'alter session ...' but TestDecimal is doing a
plan submission instead of sql string).
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket with
INFRA.
---
***************************Legal Disclaimer***************************
"This communication may contain confidential and privileged material for the
sole use of the intended recipient. Any unauthorized review, use or distribution
by others is strictly prohibited. If you have received the message by mistake,
please advise the sender by reply email and delete the message. Thank you."
**********************************************************************
