spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Priyanka Garg (JIRA)" <>
Subject [jira] [Created] (SPARK-24703) Unable to multiply calender interval with long/int
Date Sat, 30 Jun 2018 06:30:00 GMT
Priyanka Garg created SPARK-24703:

             Summary: Unable to multiply calender interval with long/int
                 Key: SPARK-24703
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.3.1
            Reporter: Priyanka Garg

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

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message