Saving all output to "!!{outputDirectory}!!/timestamp_1.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/timestamp_1.q
>>>  drop table timestamp_1;
No rows affected 
>>>  
>>>  create table timestamp_1 (t timestamp);
No rows affected 
>>>  alter table timestamp_1 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe';
No rows affected 
>>>  
>>>  insert overwrite table timestamp_1 
select cast('2011-01-01 01:01:01' as timestamp) from src limit 1;
'_c0'
No rows selected 
>>>  select cast(t as boolean) from timestamp_1 limit 1;
'_c0'
'true'
1 row selected 
>>>  select cast(t as tinyint) from timestamp_1 limit 1;
'_c0'
'77'
1 row selected 
>>>  select cast(t as smallint) from timestamp_1 limit 1;
'_c0'
'-4787'
1 row selected 
>>>  select cast(t as int) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as bigint) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as float) from timestamp_1 limit 1;
'_c0'
'1.293872512E9'
1 row selected 
>>>  select cast(t as double) from timestamp_1 limit 1;
'_c0'
'1.293872461E9'
1 row selected 
>>>  select cast(t as string) from timestamp_1 limit 1;
'_c0'
'2011-01-01 01:01:01'
1 row selected 
>>>  
>>>  insert overwrite table timestamp_1 
select '2011-01-01 01:01:01' from src limit 1;
'_col0'
No rows selected 
>>>  select cast(t as boolean) from timestamp_1 limit 1;
'_c0'
'true'
1 row selected 
>>>  select cast(t as tinyint) from timestamp_1 limit 1;
'_c0'
'77'
1 row selected 
>>>  select cast(t as smallint) from timestamp_1 limit 1;
'_c0'
'-4787'
1 row selected 
>>>  select cast(t as int) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as bigint) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as float) from timestamp_1 limit 1;
'_c0'
'1.293872512E9'
1 row selected 
>>>  select cast(t as double) from timestamp_1 limit 1;
'_c0'
'1.293872461E9'
1 row selected 
>>>  select cast(t as string) from timestamp_1 limit 1;
'_c0'
'2011-01-01 01:01:01'
1 row selected 
>>>  
>>>  insert overwrite table timestamp_1 
select '2011-01-01 01:01:01.1' from src limit 1;
'_col0'
No rows selected 
>>>  select cast(t as boolean) from timestamp_1 limit 1;
'_c0'
'true'
1 row selected 
>>>  select cast(t as tinyint) from timestamp_1 limit 1;
'_c0'
'77'
1 row selected 
>>>  select cast(t as smallint) from timestamp_1 limit 1;
'_c0'
'-4787'
1 row selected 
>>>  select cast(t as int) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as bigint) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as float) from timestamp_1 limit 1;
'_c0'
'1.293872512E9'
1 row selected 
>>>  select cast(t as double) from timestamp_1 limit 1;
'_c0'
'1.2938724611E9'
1 row selected 
>>>  select cast(t as string) from timestamp_1 limit 1;
'_c0'
'2011-01-01 01:01:01.1'
1 row selected 
>>>  
>>>  insert overwrite table timestamp_1 
select '2011-01-01 01:01:01.0001' from src limit 1;
'_col0'
No rows selected 
>>>  select cast(t as boolean) from timestamp_1 limit 1;
'_c0'
'true'
1 row selected 
>>>  select cast(t as tinyint) from timestamp_1 limit 1;
'_c0'
'77'
1 row selected 
>>>  select cast(t as smallint) from timestamp_1 limit 1;
'_c0'
'-4787'
1 row selected 
>>>  select cast(t as int) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as bigint) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as float) from timestamp_1 limit 1;
'_c0'
'1.293872512E9'
1 row selected 
>>>  select cast(t as double) from timestamp_1 limit 1;
'_c0'
'1.2938724610001E9'
1 row selected 
>>>  select cast(t as string) from timestamp_1 limit 1;
'_c0'
'2011-01-01 01:01:01.0001'
1 row selected 
>>>  
>>>  insert overwrite table timestamp_1 
select '2011-01-01 01:01:01.000100000' from src limit 1;
'_col0'
No rows selected 
>>>  select cast(t as boolean) from timestamp_1 limit 1;
'_c0'
'true'
1 row selected 
>>>  select cast(t as tinyint) from timestamp_1 limit 1;
'_c0'
'77'
1 row selected 
>>>  select cast(t as smallint) from timestamp_1 limit 1;
'_c0'
'-4787'
1 row selected 
>>>  select cast(t as int) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as bigint) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as float) from timestamp_1 limit 1;
'_c0'
'1.293872512E9'
1 row selected 
>>>  select cast(t as double) from timestamp_1 limit 1;
'_c0'
'1.2938724610001E9'
1 row selected 
>>>  select cast(t as string) from timestamp_1 limit 1;
'_c0'
'2011-01-01 01:01:01.0001'
1 row selected 
>>>  
>>>  insert overwrite table timestamp_1 
select '2011-01-01 01:01:01.001000011' from src limit 1;
'_col0'
No rows selected 
>>>  select cast(t as boolean) from timestamp_1 limit 1;
'_c0'
'true'
1 row selected 
>>>  select cast(t as tinyint) from timestamp_1 limit 1;
'_c0'
'77'
1 row selected 
>>>  select cast(t as smallint) from timestamp_1 limit 1;
'_c0'
'-4787'
1 row selected 
>>>  select cast(t as int) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as bigint) from timestamp_1 limit 1;
'_c0'
'1293872461'
1 row selected 
>>>  select cast(t as float) from timestamp_1 limit 1;
'_c0'
'1.293872512E9'
1 row selected 
>>>  select cast(t as double) from timestamp_1 limit 1;
'_c0'
'1.293872461001E9'
1 row selected 
>>>  select cast(t as string) from timestamp_1 limit 1;
'_c0'
'2011-01-01 01:01:01.001000011'
1 row selected 
>>>  
>>>  drop table timestamp_1;
No rows affected 
>>>  !record