Yuming Wang created SPARK-33617:
-----------------------------------
Summary: Avoid generating small files for INSERT INTO TABLE from
VALUES
Key: SPARK-33617
URL: https://issues.apache.org/jira/browse/SPARK-33617
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.1.0
Reporter: Yuming Wang
How to reproduce this issue:
{code:sql}
create table t1(id int) stored as textfile;
insert into table t1 values (1), (2), (3), (4), (5), (6), (7), (8);
{code}
It will generate these files:
{noformat}
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00000-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00001-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00002-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00003-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00004-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00005-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00006-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
-rwxr-xr-x 1 root root 2 Nov 30 23:07
part-00007-76a5ddf9-10df-41f8-ac19-8186449d958d-c000
{noformat}
--
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
