[
https://issues.apache.org/jira/browse/SPARK-24702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16531388#comment-16531388
]
Takeshi Yamamuro edited comment on SPARK-24702 at 7/3/18 1:36 PM:
------------------------------------------------------------------
In postgresql, we can do so;
{code}
postgres=# select CAST(CAST(interval '1 hour' AS varchar) AS interval);
interval
----------
01:00:00
(1 row)
{code}
But, not sure this cast is meaningful.
was (Author: maropu):
In postgresql, we can do so;
{code}
postgres=# select CAST(CAST(interval '1 hour' AS varchar) AS interval);
interval
----------
01:00:00
(1 row)
{cod
But, not sure this cast is meaningful.
> Unable to cast to calendar interval in spark sql.
> -------------------------------------------------
>
> Key: SPARK-24702
> URL: https://issues.apache.org/jira/browse/SPARK-24702
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.3.1
> Reporter: Priyanka Garg
> Priority: Major
>
> when I am trying to cast string type to calendar interval type, I am getting
> the following error:
> spark.sql("select cast(cast(interval '1' day as string) as
> calendarinterval)").show()
> ------------------------------------------------^^^
>
> at
> org.apache.spark.sql.catalyst.parser.AstBuilder$$anonfun$visitPrimitiveDataType$1.apply(AstBuilder.scala:1673)
> at
> org.apache.spark.sql.catalyst.parser.AstBuilder$$anonfun$visitPrimitiveDataType$1.apply(AstBuilder.scala:1651)
> at
> org.apache.spark.sql.catalyst.parser.ParserUtils$.withOrigin(ParserUtils.scala:108)
> at
> org.apache.spark.sql.catalyst.parser.AstBuilder.visitPrimitiveDataType(AstBuilder.scala:1651)
> at
> org.apache.spark.sql.catalyst.parser.AstBuilder.visitPrimitiveDataType(AstBuilder.scala:49)
> at
> org.apache.spark.sql.catalyst.parser.SqlBaseParser$PrimitiveDataTypeContext.accept(SqlBaseParser.java:13779)
> at
> org.apache.spark.sql.catalyst.parser.AstBuilder.typedVisit(AstBuilder.scala:55)
> at
> org.apache.spark.sql.catalyst.parser.AstBuilder.org$apache$spark$sql$catalyst$parser$AstBuilder$$visitSparkDataType(AstBuilde
--
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
