Repository: hive Updated Branches: refs/heads/master 4183ea900 -> 6dc245241
HIVE-18489: Automatically migrate s3n URIs to s3a URIs (addendum) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/6dc24524 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/6dc24524 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/6dc24524 Branch: refs/heads/master Commit: 6dc24524127fc165f212de739bfbf8425d6d2226 Parents: 4183ea9 Author: Sahil Takiar <stak...@cloudera.com> Authored: Wed Jan 24 14:59:23 2018 -0800 Committer: Sahil Takiar <stak...@cloudera.com> Committed: Wed Jan 24 14:59:23 2018 -0800 ---------------------------------------------------------------------- .../postgres/048-HIVE-18489.postgres.sql | 24 ++++++++++---------- 1 file changed, 12 insertions(+), 12 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/6dc24524/metastore/scripts/upgrade/postgres/048-HIVE-18489.postgres.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/postgres/048-HIVE-18489.postgres.sql b/metastore/scripts/upgrade/postgres/048-HIVE-18489.postgres.sql index fb4d0a2..ddedfe2 100644 --- a/metastore/scripts/upgrade/postgres/048-HIVE-18489.postgres.sql +++ b/metastore/scripts/upgrade/postgres/048-HIVE-18489.postgres.sql @@ -1,23 +1,23 @@ -UPDATE FUNC_RU - SET RESOURCE_URI = 's3a' || SUBSTR(RESOURCE_URI, 4) +UPDATE "FUNC_RU" + SET "RESOURCE_URI" = 's3a' || SUBSTR("RESOURCE_URI", 4) WHERE - RESOURCE_URI LIKE 's3n://%' + "RESOURCE_URI" LIKE 's3n://%' ; -UPDATE SKEWED_COL_VALUE_LOC_MAP - SET LOCATION = 's3a' || SUBSTR(LOCATION, 4) +UPDATE "SKEWED_COL_VALUE_LOC_MAP" + SET "LOCATION" = 's3a' || SUBSTR("LOCATION", 4) WHERE - LOCATION LIKE 's3n://%' + "LOCATION" LIKE 's3n://%' ; -UPDATE SDS - SET LOCATION = 's3a' || SUBSTR(LOCATION, 4) +UPDATE "SDS" + SET "LOCATION" = 's3a' || SUBSTR("LOCATION", 4) WHERE - LOCATION LIKE 's3n://%' + "LOCATION" LIKE 's3n://%' ; -UPDATE DBS - SET DB_LOCATION_URI = 's3a' || SUBSTR(DB_LOCATION_URI, 4) +UPDATE "DBS" + SET "DB_LOCATION_URI" = 's3a' || SUBSTR("DB_LOCATION_URI", 4) WHERE - DB_LOCATION_URI LIKE 's3n://%' + "DB_LOCATION_URI" LIKE 's3n://%' ;