You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by st...@apache.org on 2018/01/24 23:00:41 UTC
hive git commit: HIVE-18489: Automatically migrate s3n URIs to s3a
URIs (addendum)
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 <st...@cloudera.com>
Authored: Wed Jan 24 14:59:23 2018 -0800
Committer: Sahil Takiar <st...@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://%'
;