[ https://issues.apache.org/jira/browse/SPARK-24703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16529656#comment-16529656 ]
Priyanka Garg commented on SPARK-24703: --------------------------------------- Yeah... That's why I thought to add this. I am currently working on this, will raise a PR in a day or two. > Unable to multiply calender interval with long/int > -------------------------------------------------- > > Key: SPARK-24703 > URL: https://issues.apache.org/jira/browse/SPARK-24703 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.3.1 > Reporter: Priyanka Garg > Priority: Major > > When i am trying to multiply calender interval with long/int , I am getting > below error. The same syntax is supported in Postgres. > spark.sql("select 3 * interval '1' day").show() > org.apache.spark.sql.AnalysisException: cannot resolve '(3 * interval 1 > days)' due to data type mismatch: differing types in '(3 * interval 1 days)' > (int and calendarinterval).; line 1 pos 7; > 'Project [unresolvedalias((3 * interval 1 days), None)] > +- OneRowRelation > > at > org.apache.spark.sql.catalyst.analysis.package$AnalysisErrorAt.failAnalysis(package.scala:42) > at > org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$checkAnalysis$1$$anonfun$apply$2.applyOrElse(CheckAnalysis.scala:93) > at > org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$checkAnalysis$1$$anonfun$apply$2.applyOrElse(CheckAnalysis.scala:85) > at > org.apache.spark.sql.catalyst.trees.TreeNode$$anonfun$transformUp$1.apply(TreeNode.scala:289) -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org