mitigate_duplicates.sh

#! /bin/bash
# Allow to suplicated CTAS to run on the same transaction
: '
* Copyright 2018, Amazon.com, Inc. or its affiliates. All Rights Reserved.
*
* Licensed under the Amazon Software License (the "License").
* You may not use this file except in compliance with the License.
* A copy of the License is located at
*
* http://aws.amazon.com/asl/
*
* This file is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either
* express or implied. See the License for the specific language governing
* permissions and limitations under the License.

10/26/2016 : Initial Release.
'
sed -i -e "s/^CREATE TEMPORARY TABLE \\(.*\) /DROP TABLE IF EXISTS \1\; CREATE TEMPORARY TABLE \1 /g"