[ https://issues.apache.org/jira/browse/SPARK-32685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan resolved SPARK-32685. --------------------------------- Fix Version/s: 3.2.0 Resolution: Fixed Issue resolved by pull request 30942 [https://github.com/apache/spark/pull/30942] > 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 > Assignee: angerszhu > Priority: Major > Fix For: 3.2.0 > > > > {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