| SELECT '< HIVE-3649 Hive List Bucketing - enhance DDL to specify list bucketing table >'; | |
| -- Add new not null column into SDS table in three steps | |
| -- Step 1: Add the column allowing null | |
| ALTER TABLE "SDS" ADD COLUMN "IS_STOREDASSUBDIRECTORIES" boolean NULL; | |
| -- Step 2: Replace the null with default value (false) | |
| UPDATE "SDS" SET "IS_STOREDASSUBDIRECTORIES" = false; | |
| -- Step 3: Alter the column to disallow null values | |
| ALTER TABLE "SDS" ALTER COLUMN "IS_STOREDASSUBDIRECTORIES" SET NOT NULL; |