You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "copperybean (Jira)" <ji...@apache.org> on 2021/05/18 00:51:00 UTC

[jira] [Comment Edited] (SPARK-35130) Construct day-time interval column from integral fields

    [ https://issues.apache.org/jira/browse/SPARK-35130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17346515#comment-17346515 ] 

copperybean edited comment on SPARK-35130 at 5/18/21, 12:50 AM:
----------------------------------------------------------------

It has been supported by function make_interval already. For example:

 
{code:java}
SELECT make_interval(100, 11);
{code}
 

Which gives output like following:
{quote}100 years 11 months
{quote}
 

All parameters number from 1 to 7 are supported by function make_interval.


was (Author: copperybean):
It has been supported by function make_interval already. For example:

 
{code:java}
SELECT make_interval(100, 11);
{code}
 

Which gives output like following:
{quote}100 years 11 months
{quote}

> Construct day-time interval column from integral fields
> -------------------------------------------------------
>
>                 Key: SPARK-35130
>                 URL: https://issues.apache.org/jira/browse/SPARK-35130
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.2.0
>            Reporter: Max Gekk
>            Priority: Major
>
> Create new function similar to make_interval() (or extend the make_interval() function) which can construct DayTimeIntervalType values from day, hour, minute, second fields.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org