[
https://issues.apache.org/jira/browse/SPARK-46617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adrian Stratulat updated SPARK-46617:
-------------------------------------
Description:
h2. Description:
*Encountered behavior:* Using "CREATE TABLE IF NOT EXISTS" in a spark session,
on a table that already exists, while Hive is not enabled, results in the table
being {*}silently overwritten{*}.
*Expected behavior:* "CREATE TABLE IF NOT EXISTS" on a a table that already
exists results in the statement being skipped. See test-matrix below.
h2. Test matrix & test scenarios:{{{{}}{}}}
{noformat}
+----------------------------+-------------------------------------+
| sql statement | Behavior when overwriting a table |
| +---------------+---------------------+
| | hive-enabled | hive-disabled |
+----------------------------+---------------+---------------------+
| create-table | exception (1) | exception (2) |
| create-table-if-not-exists | skip (3) | OVERWRITE *BUG* (4) |
+----------------------------+---------------+---------------------+
{noformat}
was:
h2. Description:
*Encountered behavior:* Using "CREATE TABLE IF NOT EXISTS" in a spark session,
on a table that already exists, while Hive is not enabled, results in the table
being {*}silently overwritten{*}.
*Expected behavior:* "CREATE TABLE IF NOT EXISTS" on a a table that already
exists results in the statement being skipped. See test-matrix below.
h2. Test matrix & test scenarios:{{{}{}}}
+----------------------------+-------------------------------------+
| sql statement | Behavior when overwriting a table |
| +---------------+---------------------+
| | hive-enabled | hive-disabled |
+----------------------------+---------------+---------------------+
| create-table | exception (1) | exception (2) |
| create-table-if-not-exists | skip (3) | OVERWRITE *BUG* (4) |
+----------------------------+---------------+---------------------+
{{ }}
> Create-table-if-not-exists overwrites tables
> --------------------------------------------
>
> Key: SPARK-46617
> URL: https://issues.apache.org/jira/browse/SPARK-46617
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.5.0
> Reporter: Adrian Stratulat
> Priority: Minor
>
> h2. Description:
> *Encountered behavior:* Using "CREATE TABLE IF NOT EXISTS" in a spark
> session, on a table that already exists, while Hive is not enabled, results
> in the table being {*}silently overwritten{*}.
> *Expected behavior:* "CREATE TABLE IF NOT EXISTS" on a a table that already
> exists results in the statement being skipped. See test-matrix below.
> h2. Test matrix & test scenarios:{{{{}}{}}}
> {noformat}
> +----------------------------+-------------------------------------+
> | sql statement | Behavior when overwriting a table |
> | +---------------+---------------------+
> | | hive-enabled | hive-disabled |
> +----------------------------+---------------+---------------------+
> | create-table | exception (1) | exception (2) |
> | create-table-if-not-exists | skip (3) | OVERWRITE *BUG* (4) |
> +----------------------------+---------------+---------------------+
> {noformat}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
