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:g...@git.apache.org] Sent: Sunday, June 19, 2016 11:08 PM To: dev@drill.apache.org 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 infrastruct...@apache.org 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." **********************************************************************