Saving all output to "!!{outputDirectory}!!/timestamp_3.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/timestamp_3.q
>>>  drop table timestamp_3;
No rows affected 
>>>  
>>>  create table timestamp_3 (t timestamp);
No rows affected 
>>>  alter table timestamp_3 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe';
No rows affected 
>>>  
>>>  insert overwrite table timestamp_3 
select cast(cast('1.3041352164485E9' as double) as timestamp) from src limit 1;
'_c0'
No rows selected 
>>>  select cast(t as boolean) from timestamp_3 limit 1;
'_c0'
'true'
1 row selected 
>>>  select cast(t as tinyint) from timestamp_3 limit 1;
'_c0'
'48'
1 row selected 
>>>  select cast(t as smallint) from timestamp_3 limit 1;
'_c0'
'-31184'
1 row selected 
>>>  select cast(t as int) from timestamp_3 limit 1;
'_c0'
'1304135216'
1 row selected 
>>>  select cast(t as bigint) from timestamp_3 limit 1;
'_c0'
'1304135216'
1 row selected 
>>>  select cast(t as float) from timestamp_3 limit 1;
'_c0'
'1.304135168E9'
1 row selected 
>>>  select cast(t as double) from timestamp_3 limit 1;
'_c0'
'1.3041352164485E9'
1 row selected 
>>>  select cast(t as string) from timestamp_3 limit 1;
'_c0'
'2011-04-29 20:46:56.4485'
1 row selected 
>>>  
>>>  drop table timestamp_3;
No rows affected 
>>>  !record