[
https://issues.apache.org/jira/browse/IMPALA-12287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Smith resolved IMPALA-12287.
------------------------------------
Fix Version/s: Impala 4.3.0
Resolution: Fixed
> For dataload, use "INSERT OVERWRITE TABLE" syntax rather than "INSERT
> OVERWRITE"
> --------------------------------------------------------------------------------
>
> Key: IMPALA-12287
> URL: https://issues.apache.org/jira/browse/IMPALA-12287
> Project: IMPALA
> Issue Type: Improvement
> Components: Infrastructure
> Affects Versions: Impala 4.3.0
> Reporter: Joe McDonnell
> Priority: Major
> Fix For: Impala 4.3.0
>
>
> In dataload, we have some Hive statements that use the "INSERT OVERWRITE"
> syntax rather than the "INSERT OVERWRITE TABLE" syntax:
> {noformat}
> INSERT OVERWRITE {db_name}{db_suffix}.{table_name} VALUES
> (1,
> map(true, "true", if(false, false, NULL), "null"),
> map(-1Y, "one", if(false, 1Y, NULL), "null"),
> map(-1S, "one", if(false, 1S, NULL), "null"),
> map(-1L, "one", if(false, 1L, NULL), "null"),
> map(cast(-1.75 as FLOAT), "a", if(false, cast(1.5 as FLOAT), NULL),
> "null"),
> map(cast(-1.75 as DOUBLE), "a", if(false, cast(1.5 as DOUBLE), NULL),
> "null"),
> map(-1.8, "a",if(false, 1.5, NULL), "null"),
> map("one", 1, if(false, "", NULL), NULL),
> map(cast("Mon" as CHAR(3)), 1,
> if(false, cast("NUL" as CHAR(3)), NULL), NULL),
> map(cast("a" as VARCHAR(3)), "A", if(false, cast("" as VARCHAR(3)), NULL),
> NULL),
> map(to_utc_timestamp("2022-12-10 08:15:12", "UTC"), "Saturday morning",
> if(false, to_utc_timestamp("2022-12-10 08:15:12", "UTC"), NULL),
> "null"),
> map(to_date("2022-12-10"), "Saturday", if(false, to_date("2022-12-10"),
> NULL), "null"),
> named_struct("m", map(1, "one", if(false, 1, NULL), "null"), "s",
> "some_string")
> );{noformat}
> Older Hive versions do not support the "INSERT OVERWRITE" syntax, so it would
> be better to convert all of these to "INSERT OVERWRITE TABLE"
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
