You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Wenchen Fan (Jira)" <ji...@apache.org> on 2020/08/21 07:38:00 UTC

[jira] [Resolved] (SPARK-32667) Scrip transformation no-serde mode when column less then output length , Use null fill

     [ https://issues.apache.org/jira/browse/SPARK-32667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wenchen Fan resolved SPARK-32667.
---------------------------------
    Fix Version/s: 3.1.0
       Resolution: Fixed

Issue resolved by pull request 29500
[https://github.com/apache/spark/pull/29500]

> Scrip transformation no-serde mode when column less then output length ,  Use null fill
> ---------------------------------------------------------------------------------------
>
>                 Key: SPARK-32667
>                 URL: https://issues.apache.org/jira/browse/SPARK-32667
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: angerszhu
>            Assignee: angerszhu
>            Priority: Major
>             Fix For: 3.1.0
>
>
> Scrip transform no-serde mode should pad null value to filling column
> {code:java}
> hive> SELECT TRANSFORM(a, b)
>     >   ROW FORMAT DELIMITED
>     >   FIELDS TERMINATED BY '|'
>     >   LINES TERMINATED BY '\n'
>     >   NULL DEFINED AS 'NULL'
>     > USING 'cat' as (a string, b string, c string, d string)
>     >   ROW FORMAT DELIMITED
>     >   FIELDS TERMINATED BY '|'
>     >   LINES TERMINATED BY '\n'
>     >   NULL DEFINED AS 'NULL'
>     > FROM (
>     > select 1 as a, 2 as b
>     > ) tmp ;
> OK
> 1	2	NULL	NULL
> Time taken: 24.626 seconds, Fetched: 1 row(s)
> {code}



--
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