[ https://issues.apache.org/jira/browse/HIVE-18489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16333896#comment-16333896 ]
Sahil Takiar commented on HIVE-18489: ------------------------------------- [~aihuaxu] yeah its probably safer that way. Attached an updated patch that matches on {{s3n://%}} so if the string starts with {{s3n://}} it will replace {{s3n}} with {{s3a}} (I didn't used the SQL REPLACE method intentionally to avoid replacing any other occurrences of {{s3n}} in the URI; by using {{SUBSTRING}} and the {{CONCAT}} operator the update only updates the start of the string). > Automatically migration s3n URIs to s3a URIs > -------------------------------------------- > > Key: HIVE-18489 > URL: https://issues.apache.org/jira/browse/HIVE-18489 > Project: Hive > Issue Type: Sub-task > Reporter: Sahil Takiar > Assignee: Sahil Takiar > Priority: Major > Attachments: HIVE-18489.1.patch, HIVE-18489.2.patch, > HIVE-18489.3.patch, HIVE-18489.4.patch > > > {{s3n}} has been removed from Hadoop 3.x, we should auto-migrate tables with > {{s3n}} URIs to the {{s3a}} URIs -- This message was sent by Atlassian JIRA (v7.6.3#76005)