Timezone Names Unsupported in Impala in CDH 6.0.1
The following table lists the time zone names / aliases no longer supported in Impala along with the canonical names you can use to replace the unsupported aliases with.
| Deprecated | Replace with |
| ACDT | Australia/South |
| ACST | Australia/Darwin |
| ACWST | Australia/Eucla |
| ADT | America/Thule |
| AEDT | Australia/Sydney |
| AEST | Australia/Sydney |
| AFT | Asia/Kabul |
| AKDT | America/Anchorage |
| AKST | America/Anchorage |
| ALMT | Asia/Almaty |
| AMST | America/Cuiaba |
| AMT | Asia/Yerevan |
| ANAT | Asia/Anadyr |
| AQTT | Asia/Aqtau |
| AWST | Australia/West |
| AZOST | Atlantic/Azores |
| AZOT | Atlantic/Azores |
| AZST | Asia/Baku |
| AZT | Asia/Baku |
| Acre Time | Brazil/Acre |
| Afghanistan Time | Asia/Kabul |
| Alaska Daylight Time | America/Anchorage |
| Alaska Standard Time | America/Anchorage |
| Alma-Ata Time | Asia/Almaty |
| Amazon Summer Time | America/Cuiaba |
| Amazon Time | Brazil/West |
| Anadyr Time | Asia/Anadyr |
| Aqtau Time | Asia/Aqtau |
| Aqtobe Time | Asia/Aqtobe |
| Arabia Standard Time | Asia/Aden |
| Argentine Time | America/Argentina/Buenos_Aires |
| Armenia Time | Asia/Yerevan |
| Asia/Riyadh87 | - |
| Asia/Riyadh88 | - |
| Asia/Riyadh89 | - |
| Atlantic Daylight Time | America/Thule |
| Atlantic Standard Time | America/Puerto_Rico |
| Australian Central Daylight Time (South Australia) | Australia/South |
| Australian Central Daylight Time (South Australia/New South Wales) | Australia/Yancowinna |
| Australian Central Standard Time (Northern Territory) | Australia/Darwin |
| Australian Central Standard Time (South Australia) | Australia/South |
| Australian Central Standard Time (South Australia/New South Wales) | Australia/Yancowinna |
| Australian Central Western Standard Time | Australia/Eucla |
| Australian Eastern Daylight Time (New South Wales) | Australia/Sydney |
| Australian Eastern Daylight Time (Tasmania) | Australia/Hobart |
| Australian Eastern Daylight Time (Victoria) | Australia/Victoria |
| Australian Eastern Standard Time (New South Wales) | Australia/Sydney |
| Australian Eastern Standard Time (Queensland) | Australia/Brisbane |
| Australian Eastern Standard Time (Tasmania) | Australia/Hobart |
| Australian Eastern Standard Time (Victoria) | Australia/Victoria |
| Australian Western Standard Time | Australia/West |
| Azerbaijan Summer Time | Asia/Baku |
| Azerbaijan Time | Asia/Baku |
| Azores Summer Time | Atlantic/Azores |
| Azores Time | Atlantic/Azores |
| BDT | Asia/Dhaka |
| BNT | Asia/Brunei |
| BOT | America/La_Paz |
| BRST | America/Sao_Paulo |
| BRT | America/Sao_Paulo |
| BTT | Asia/Thimbu |
| Bangladesh Time | Asia/Dhaka |
| Bhutan Time | Asia/Thimbu |
| Bolivia Time | America/La_Paz |
| Bougainville Standard Time | Pacific/Bougainville |
| Brasilia Summer Time | America/Sao_Paulo |
| Brasilia Time | America/Sao_Paulo |
| British Summer Time | GB |
| Brunei Time | Asia/Brunei |
| CCT | Indian/Cocos |
| CDT | America/Chicago |
| CEST | CET |
| CHADT | NZ-CHAT |
| CHAST | NZ-CHAT |
| CHOT | Asia/Choibalsan |
| CHUT | Pacific/Yap |
| CKT | Pacific/Rarotonga |
| CLST | America/Santiago |
| CLT | America/Santiago |
| COT | America/Bogota |
| CVT | Atlantic/Cape_Verde |
| CXT | Indian/Christmas |
| Canada/East-Saskatchewan | America/Regina |
| Cape Verde Time | Atlantic/Cape_Verde |
| Central African Time | Africa/Harare |
| Central Daylight Time | America/Chicago |
| Central European Summer Time | CET |
| Central European Time | CET |
| Central Indonesia Time | Asia/Makassar |
| Central Standard Time | America/Chicago |
| ChST | Pacific/Guam |
| Chamorro Standard Time | Pacific/Guam |
| Chatham Daylight Time | NZ-CHAT |
| Chatham Standard Time | NZ-CHAT |
| Chile Summer Time | America/Santiago |
| Chile Time | America/Santiago |
| China Standard Time | Asia/Shanghai |
| Choibalsan Time | Asia/Choibalsan |
| Christmas Island Time | Indian/Christmas |
| Chuuk Time | Pacific/Yap |
| Cocos Islands Time | Indian/Cocos |
| Colombia Time | America/Bogota |
| Cook Is. Time | Pacific/Rarotonga |
| Coordinated Universal Time | UCT |
| Cuba Daylight Time | Cuba |
| Cuba Standard Time | Cuba |
| DAVT | Antarctica/Davis |
| DDUT | Antarctica/DumontDUrville |
| Davis Time | Antarctica/Davis |
| Dumont-d'Urville Time | Antarctica/DumontDUrville |
| EASST | Pacific/Easter |
| EAST | Pacific/Easter |
| EDT | America/Indiana/Indianapolis |
| EEST | Africa/Cairo |
| EGST | America/Scoresbysund |
| EGT | America/Scoresbysund |
| East Indonesia Time | Asia/Jayapura |
| Easter Is. Summer Time | Pacific/Easter |
| Easter Is. Time | Pacific/Easter |
| Eastern African Time | Africa/Addis_Ababa |
| Eastern Daylight Time | America/Indiana/Indianapolis |
| Eastern European Summer Time | Africa/Cairo |
| Eastern European Time | Africa/Cairo |
| Eastern Greenland Summer Time | America/Scoresbysund |
| Eastern Greenland Time | America/Scoresbysund |
| Eastern Standard Time | EST |
| Ecuador Time | America/Guayaquil |
| FJST | Pacific/Fiji |
| FJT | Pacific/Fiji |
| FKT | Atlantic/Stanley |
| FNT | America/Noronha |
| Falkland Is. Time | Atlantic/Stanley |
| Fernando de Noronha Time | America/Noronha |
| Fiji Summer Time | Pacific/Fiji |
| Fiji Time | Pacific/Fiji |
| French Guiana Time | America/Cayenne |
| French Southern & Antarctic Lands Time | Indian/Kerguelen |
| GALT | Pacific/Galapagos |
| GAMT | Pacific/Gambier |
| GET | Asia/Tbilisi |
| GFT | America/Cayenne |
| GILT | Pacific/Tarawa |
| GMT+00:00 | GMT0 |
| GMT+01:00 | Etc/GMT-1 |
| GMT+02:00 | Etc/GMT-2 |
| GMT+03:00 | Etc/GMT-3 |
| GMT+04:00 | Etc/GMT-4 |
| GMT+05:00 | Etc/GMT-5 |
| GMT+06:00 | Etc/GMT-6 |
| GMT+07:00 | Etc/GMT-7 |
| GMT+08:00 | Etc/GMT-8 |
| GMT+09:00 | Etc/GMT-9 |
| GMT+10:00 | Etc/GMT-10 |
| GMT+11:00 | Etc/GMT-11 |
| GMT+12:00 | Etc/GMT-12 |
| GMT+13:00 | Etc/GMT-13 |
| GMT+14:00 | Etc/GMT-14 |
| GMT-01:00 | Etc/GMT+1 |
| GMT-02:00 | Etc/GMT+2 |
| GMT-03:00 | Etc/GMT+3 |
| GMT-04:00 | Etc/GMT+4 |
| GMT-05:00 | Etc/GMT+5 |
| GMT-06:00 | Etc/GMT+6 |
| GMT-07:00 | Etc/GMT+7 |
| GMT-08:00 | Etc/GMT+8 |
| GMT-09:00 | Etc/GMT+9 |
| GMT-10:00 | Etc/GMT+10 |
| GMT-11:00 | Etc/GMT+11 |
| GMT-12:00 | Etc/GMT+12 |
| GST | Asia/Dubai |
| GYT | America/Guyana |
| Galapagos Time | Pacific/Galapagos |
| Gambier Time | Pacific/Gambier |
| Georgia Time | Asia/Tbilisi |
| Ghana Mean Time | Africa/Accra |
| Gilbert Is. Time | Pacific/Tarawa |
| Greenwich Mean Tim | GB |
| Gulf Standard Time | Asia/Dubai |
| Guyana Time | America/Guyana |
| HADT | US/Aleutian |
| HAST | US/Aleutian |
| HKT | Hongkong |
| HOVT | Asia/Hovd |
| Hawaii Standard Time | HST |
| Hawaii-Aleutian Daylight Time | US/Aleutian |
| Hawaii-Aleutian Standard Time | US/Aleutian |
| Hong Kong Time | Hongkong |
| Hovd Time | Asia/Hovd |
| ICT | Asia/Ho_Chi_Minh |
| IDT | Israel |
| IOT | Indian/Chagos |
| IRDT | Iran |
| IRKT | Asia/Chita |
| IRST | Iran |
| India Standard Time | Asia/Kolkata |
| Indian Ocean Territory Time | Indian/Chagos |
| Indochina Time | Asia/Ho_Chi_Minh |
| Iran Daylight Time | Iran |
| Iran Standard Time | Iran |
| Irish Summer Time | Eire |
| Irkutsk Time | Asia/Chita |
| Israel Daylight Time | Israel |
| Israel Standard Time | Israel |
| Japan Standard Time | Asia/Tokyo |
| KGT | Asia/Bishkek |
| KOST | Pacific/Kosrae |
| KRAT | Asia/Krasnoyarsk |
| KST | ROK |
| Khandyga Time | Asia/Khandyga |
| Kirgizstan Time | Asia/Bishkek |
| Korea Standard Time | ROK |
| Kosrae Time | Pacific/Kosrae |
| Krasnoyarsk Time | Asia/Krasnoyarsk |
| LHDT | Australia/LHI |
| LHST | Australia/LHI |
| LINT | Pacific/Kiritimati |
| Line Is. Time | Pacific/Kiritimati |
| Lord Howe Daylight Time | Australia/LHI |
| Lord Howe Standard Time | Australia/LHI |
| MAGT | Asia/Magadan |
| MART | Pacific/Marquesas |
| MAWT | Antarctica/Mawson |
| MDT | Navajo |
| MEST | MET |
| MHT | Kwajalein |
| MIST | Antarctica/Macquarie |
| MMT | Asia/Rangoon |
| MSK | W-SU |
| MUT | Indian/Mauritius |
| MVT | Indian/Maldives |
| MYT | Asia/Kuching |
| Macquarie Island Standard Time | Antarctica/Macquarie |
| Magadan Time | Asia/Magadan |
| Malaysia Time | Asia/Kuching |
| Maldives Time | Indian/Maldives |
| Marquesas Time | Pacific/Marquesas |
| Marshall Islands Time | Kwajalein |
| Mauritius Time | Indian/Mauritius |
| Mawson Time | Antarctica/Mawson |
| Middle Europe Summer Time | MET |
| Middle Europe Time | MET |
| Mideast/Riyadh87 | - |
| Mideast/Riyadh88 | - |
| Mideast/Riyadh89 | - |
| Moscow Standard Time | W-SU |
| Mountain Daylight Time | Navajo |
| Mountain Standard Time | MST |
| Myanmar Time | Asia/Rangoon |
| NCT | Pacific/Noumea |
| NDT | America/St_Johns |
| NFT | Pacific/Norfolk |
| NOVT | Asia/Novosibirsk |
| NPT | Asia/Katmandu |
| NRT | Pacific/Nauru |
| NUT | Pacific/Niue |
| NZDT | NZ |
| NZST | NZ |
| Nauru Time | Pacific/Nauru |
| Nepal Time | Asia/Katmandu |
| New Caledonia Time | Pacific/Noumea |
| New Zealand Daylight Time | NZ |
| New Zealand Standard Time | NZ |
| Newfoundland Daylight Time | America/St_Johns |
| Newfoundland Standard Time | America/St_Johns |
| Niue Time | Pacific/Niue |
| Norfolk Time | Pacific/Norfolk |
| Novosibirsk Time | Asia/Novosibirsk |
| OMST | Asia/Omsk |
| ORAT | Asia/Oral |
| Omsk Time | Asia/Omsk |
| Oral Time | Asia/Oral |
| PDT | America/Los_Angeles |
| PET | America/Lima |
| PETT | Asia/Kamchatka |
| PGT | Pacific/Port_Moresby |
| PHOT | Pacific/Enderbury |
| PHT | Asia/Manila |
| PKT | Asia/Karachi |
| PMDT | America/Miquelon |
| PMST | America/Miquelon |
| PONT | Pacific/Ponape |
| PWT | Pacific/Palau |
| PYST | America/Asuncion |
| PYT | America/Asuncion |
| Pacific Daylight Time | America/Los_Angeles |
| Pacific Standard Time | America/Los_Angeles |
| Pakistan Time | Asia/Karachi |
| Palau Time | Pacific/Palau |
| Papua New Guinea Time | Pacific/Port_Moresby |
| Paraguay Summer Time | America/Asuncion |
| Paraguay Time | America/Asuncion |
| Peru Time | America/Lima |
| Petropavlovsk-Kamchatski Time | Asia/Kamchatka |
| Philippines Time | Asia/Manila |
| Phoenix Is. Time | Pacific/Enderbury |
| Pierre & Miquelon Daylight Time | America/Miquelon |
| Pierre & Miquelon Standard Time | America/Miquelon |
| Pitcairn Standard Time | Pacific/Pitcairn |
| Pohnpei Time | Pacific/Ponape |
| QYZT | Asia/Qyzylorda |
| Qyzylorda Time | Asia/Qyzylorda |
| RET | Indian/Reunion |
| ROTT | Antarctica/Rothera |
| Reunion Time | Indian/Reunion |
| Rothera Time | Antarctica/Rothera |
| SAKT | Asia/Sakhalin |
| SAMT | Europe/Samara |
| SAST | Africa/Maseru |
| SBT | Pacific/Guadalcanal |
| SCT | Indian/Mahe |
| SGT | Singapore |
| SRET | Asia/Srednekolymsk |
| SRT | America/Paramaribo |
| SYOT | Antarctica/Syowa |
| Sakhalin Time | Asia/Sakhalin |
| Samara Time | Europe/Samara |
| Samoa Standard Time | US/Samoa |
| Seychelles Time | Indian/Mahe |
| Singapore Time | Singapore |
| Solomon Is. Time | Pacific/Guadalcanal |
| South Africa Standard Time | Africa/Maseru |
| South Georgia Standard Time | Atlantic/South_Georgia |
| Srednekolymsk Time | Asia/Srednekolymsk |
| Suriname Time | America/Paramaribo |
| Syowa Time | Antarctica/Syowa |
| SystemV/AST4 | America/Puerto_Rico |
| SystemV/AST4ADT | Canada/Atlantic |
| SystemV/CST6 | Canada/Saskatchewan |
| SystemV/CST6CDT | US/Central |
| SystemV/EST5 | America/Cayman |
| SystemV/EST5EDT | America/New_York |
| SystemV/HST10 | US/Hawaii |
| SystemV/MST7 | US/Arizona |
| SystemV/MST7MDT | America/Denver |
| SystemV/PST8 | Pacific/Pitcairn |
| SystemV/PST8PDT | US/Pacific |
| SystemV/YST9 | Pacific/Gambier |
| SystemV/YST9YDT | US/Alaska |
| TAHT | Pacific/Tahiti |
| TFT | Indian/Kerguelen |
| TJT | Asia/Dushanbe |
| TKT | Pacific/Fakaofo |
| TLT | Asia/Dili |
| TMT | Asia/Ashgabat |
| TOT | Pacific/Tongatapu |
| TVT | Pacific/Funafuti |
| Tahiti Time | Pacific/Tahiti |
| Tajikistan Time | Asia/Dushanbe |
| Timor-Leste Time | Asia/Dili |
| Tokelau Time | Pacific/Fakaofo |
| Tonga Time | Pacific/Tongatapu |
| Turkmenistan Time | Asia/Ashgabat |
| Tuvalu Time | Pacific/Funafuti |
| ULAT | Asia/Ulan_Bator |
| UYST | America/Montevideo |
| UYT | America/Montevideo |
| UZT | Asia/Tashkent |
| Ulaanbaatar Time | Asia/Ulan_Bator |
| Uruguay Summer Time | America/Montevideo |
| Uruguay Time | America/Montevideo |
| Ust-Nera Time | Asia/Ust-Nera |
| Uzbekistan Time | Asia/Tashkent |
| VET | America/Caracas |
| VLAT | Asia/Ust-Nera |
| VOST | Antarctica/Vostok |
| VUT | Pacific/Efate |
| Vanuatu Time | Pacific/Efate |
| Venezuela Time | America/Caracas |
| Vladivostok Time | Asia/Vladivostok |
| Vostok Time | Antarctica/Vostok |
| WAKT | Pacific/Wake |
| WAST | Africa/Windhoek |
| WAT | Africa/Lagos |
| WEST | WET |
| WFT | Pacific/Wallis |
| WGST | America/Godthab |
| WGT | America/Godthab |
| WIB | Asia/Jakarta |
| WIT | Asia/Jayapura |
| WITA | Asia/Makassar |
| WSDT | Pacific/Apia |
| WSST | Pacific/Apia |
| Wake Time | Pacific/Wake |
| Wallis & Futuna Time | Pacific/Wallis |
| West Indonesia Time | Asia/Jakarta |
| West Samoa Daylight Time | Pacific/Apia |
| West Samoa Standard Time | Pacific/Apia |
| Western African Summer Time | Africa/Windhoek |
| Western African Time | Africa/Lagos |
| Western European Summer Time | WET |
| Western European Time | WET |
| Western Greenland Summer Time | America/Godthab |
| Western Greenland Time | America/Godthab |
| XJT | Asia/Urumqi |
| Xinjiang Standard Time | Asia/Urumqi |
| YAKT | Asia/Yakutsk |
| YEKT | Asia/Yekaterinburg |
| Yakutsk Time | Asia/Yakutsk |
| Yekaterinburg Time | Asia/Yekaterinburg |