[jira] [Assigned] (SPARK-32685) Script transform hive serde default field.delimit is '\t'
[ https://issues.apache.org/jira/browse/SPARK-32685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wenchen Fan reassigned SPARK-32685: --- Assignee: angerszhu > 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 > > > {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
[jira] [Assigned] (SPARK-32685) Script transform hive serde default field.delimit is '\t'
[ https://issues.apache.org/jira/browse/SPARK-32685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-32685: Assignee: Apache Spark > 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: Apache Spark >Priority: Major > > > {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
[jira] [Assigned] (SPARK-32685) Script transform hive serde default field.delimit is '\t'
[ https://issues.apache.org/jira/browse/SPARK-32685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-32685: Assignee: (was: Apache Spark) > 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 >Priority: Major > > > {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