[jira] [Created] (SPARK-32685) Script transform hive serde default field.delimit is '\t'

[angerszhu (Jira)]

angerszhu created SPARK-32685:
---------------------------------

             Summary: Script transform hive serde default field.delimit is '\t'
                 Key: SPARK-32685
                 URL: https://issues.apache.org/jira/browse/SPARK-32685
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: angerszhu


 
{code:java}
select split(value, "\t") from (
SELECT TRANSFORM(a, b, c, null)
USING 'cat' 
FROM (select 1 as a, 2 as b, 3  as c) t
) temp;

result is :
_c0
["2","3","\\N"]{code}
 
{code:java}
select split(value, "\t") from (
SELECT TRANSFORM(a, b, c, null)
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
USING 'cat' 
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
  WITH SERDEPROPERTIES (
   'serialization.last.column.takes.rest' = 'true'
  )
FROM (select 1 as a, 2 as b, 3  as c) t
) temp;


result is :
_c0
["2","3","\\N"]{code}
 

 

 
{code:java}
select split(value, "\t") from (
SELECT TRANSFORM(a, b, c, null)
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
USING 'cat' 
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
FROM (select 1 as a, 2 as b, 3  as c) t
) temp;

result is :
_c0 
["2"]
{code}
 



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

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