Timezone Names Unsupported in Impala in CDH 6.1.0

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