[ 
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)

Reply via email to