set hive.fetch.task.conversion=more;

drop table tstz1_n1;

create table tstz1_n1(t timestamp with local time zone);

insert overwrite table tstz1_n1 select cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone);

select cast(t as timestamp) from tstz1_n1;
select cast(to_epoch_milli(t) as timestamp) from tstz1_n1;

set time zone UTC;

select cast(t as timestamp) from tstz1_n1;
select cast(to_epoch_milli(t) as timestamp) from tstz1_n1;