[
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 with default hive file format 'text':
*CREATE TABLE t1 AS SELECT '123' AS id, 'abc\ndef' AS test*
I got the following result from Spark SQL {*}SELECT * FROM t1{*}:
id test
123 abc
def null
was:
After I executed the following Spark SQL with default hive file format 'text':
`create table t1 as select '123' as id, 'abc\ndef' as test`
I got the following result from Spark SQL `select * from t1`:
id test
123 abc
def null
> 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 with default hive file format 'text':
>
> *CREATE TABLE t1 AS SELECT '123' AS id, 'abc\ndef' AS test*
>
> I got the following result from Spark SQL {*}SELECT * FROM t1{*}:
>
> id test
> 123 abc
> def null
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
