[ https://issues.apache.org/jira/browse/SPARK-4928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14256509#comment-14256509 ]
Apache Spark commented on SPARK-4928: ------------------------------------- User 'guowei2' has created a pull request for this issue: https://github.com/apache/spark/pull/3767 > Operator ">,<,>=,<=" with decimal between different precision report error > -------------------------------------------------------------------------- > > Key: SPARK-4928 > URL: https://issues.apache.org/jira/browse/SPARK-4928 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.3.0 > Reporter: guowei > > create table test (a Decimal(10,1)); > select * from test where a>1; > WARN TaskSetManager: Lost task 0.0 in stage 0.0 (TID 0, localhost): > org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Types do not > match DecimalType(10,1) != DecimalType(10,0), tree: (input[0] > 1) > at > org.apache.spark.sql.catalyst.expressions.Expression.c2(Expression.scala:249) > at > org.apache.spark.sql.catalyst.expressions.GreaterThan.eval(predicates.scala:204) > at > org.apache.spark.sql.catalyst.expressions.InterpretedPredicate$$anonfun$apply$1.apply(predicates.scala:30) > at > org.apache.spark.sql.catalyst.expressions.InterpretedPredicate$$anonfun$apply$1.apply(predicates.scala:30) > at scala.collection.Iterator$$anon$14.hasNext(Iterator.scala:390) > at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327) > at scala.collection.Iterator$class.foreach(Iterator.scala:727) > at scala.collection.AbstractIterator.foreach(Iterator.scala:1157) > at > scala.collection.generic.Growable$class.$plus$plus$eq(Growable.scala:48) > at > scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:103) > at > scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:47) > at scala.collection.TraversableOnce$class.to(TraversableOnce.scala:273) > at scala.collection.AbstractIterator.to(Iterator.scala:1157) > at > scala.collection.TraversableOnce$class.toBuffer(TraversableOnce.scala:265) > at scala.collection.AbstractIterator.toBuffer(Iterator.scala:1157) > at > scala.collection.TraversableOnce$class.toArray(TraversableOnce.scala:252) > at scala.collection.AbstractIterator.toArray(Iterator.scala:1157) > at org.apache.spark.rdd.RDD$$anonfun$16.apply(RDD.scala:794) > at org.apache.spark.rdd.RDD$$anonfun$16.apply(RDD.scala:794) > at > org.apache.spark.SparkContext$$anonfun$runJob$4.apply(SparkContext.scala:1324) > at > org.apache.spark.SparkContext$$anonfun$runJob$4.apply(SparkContext.scala:1324) > at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:61) > at org.apache.spark.scheduler.Task.run(Task.scala:56) > at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:195) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:744) -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org