set hive.fetch.task.conversion=more;

drop table tstz1;

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

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

insert overwrite table tstz1 select '2016-01-03 12:26:34.1 GMT';
select cast(t as string) from tstz1;
select cast(t as date) from tstz1;
select cast(t as timestamp) from tstz1;

insert overwrite table tstz1 select '2016-01-03 12:26:34.0123 Europe/London';
select cast(t as string) from tstz1;
select cast(t as date) from tstz1;
select cast(t as timestamp) from tstz1;

insert overwrite table tstz1 select '2016-01-03 12:26:34.012300 GMT+08:00';
select cast(t as string) from tstz1;
select cast(t as date) from tstz1;
select cast(t as timestamp) from tstz1;