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

[jira] [Updated] (SPARK-32608) Script Transform DELIMIT value error

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

angerszhu updated SPARK-32608:
------------------------------
    Description: 
For SQL

 
{code:java}
SELECT TRANSFORM(a, b, c)
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY ','
  LINES TERMINATED BY '\n'
  NULL DEFINED AS 'null'
  USING 'cat' AS (a, b, c)
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY ','
  LINES TERMINATED BY '\n'
  NULL DEFINED AS 'NULL'
FROM testData
{code}
The correct 

TOK_TABLEROWFORMATFIELD should be , nut actually  ','

TOK_TABLEROWFORMATLINES should be \n  but actually '\n'

> Script Transform DELIMIT  value error
> -------------------------------------
>
>                 Key: SPARK-32608
>                 URL: https://issues.apache.org/jira/browse/SPARK-32608
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: angerszhu
>            Priority: Major
>
> For SQL
>  
> {code:java}
> SELECT TRANSFORM(a, b, c)
>   ROW FORMAT DELIMITED
>   FIELDS TERMINATED BY ','
>   LINES TERMINATED BY '\n'
>   NULL DEFINED AS 'null'
>   USING 'cat' AS (a, b, c)
>   ROW FORMAT DELIMITED
>   FIELDS TERMINATED BY ','
>   LINES TERMINATED BY '\n'
>   NULL DEFINED AS 'NULL'
> FROM testData
> {code}
> The correct 
> TOK_TABLEROWFORMATFIELD should be , nut actually  ','
> TOK_TABLEROWFORMATLINES should be \n  but actually '\n'



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