[
https://issues.apache.org/jira/browse/SPARK-48448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
dohongdayi updated SPARK-48448:
-------------------------------
Description:
After I executed the following Spark SQL to create Hive table with default file
format {*}text{*}:
*CREATE TABLE t1 AS SELECT '123' AS id, 'abc\ndef' AS name*
I got the following result from {*}SELECT * FROM t1{*}:
id name
123 abc
def null
How could the result be fixed without changing the file format ?
was:
After I executed the following Spark SQL to create Hive table with default file
format {*}text{*}:
*CREATE TABLE t1 AS SELECT '123' AS id, 'abc\ndef' AS name*
I got the following result from Spark SQL {*}SELECT * FROM t1{*}:
id name
123 abc
def null
How could the result be fixed without changing the file format ?
> Mismatched Row Count for Tables in Text Format Created by CTAS
> --------------------------------------------------------------
>
> Key: SPARK-48448
> URL: https://issues.apache.org/jira/browse/SPARK-48448
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.3.2, 3.2.2
> Reporter: dohongdayi
> Priority: Major
>
> After I executed the following Spark SQL to create Hive table with default
> file format {*}text{*}:
>
> *CREATE TABLE t1 AS SELECT '123' AS id, 'abc\ndef' AS name*
>
> I got the following result from {*}SELECT * FROM t1{*}:
>
> id name
> 123 abc
> def null
>
> How could the result be fixed without changing the file format ?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
