Timezone Names Unsupported in Impala in CDH 6.2.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 |