You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/08/17 03:29:51 UTC

svn commit: r1618443 - in /hive/branches/spark: itests/src/test/resources/ ql/src/test/results/clientpositive/spark/

Author: brock
Date: Sun Aug 17 01:29:50 2014
New Revision: 1618443

URL: http://svn.apache.org/r1618443
Log:
HIVE-7749 - Enable timestamp.* tests (Brock reviewed by Szehon)[Spark Branch]

Added:
    hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_1.q.out
    hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_2.q.out
    hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_3.q.out
    hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_comparison.q.out
    hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_lazy.q.out
    hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_null.q.out
    hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_udf.q.out
Modified:
    hive/branches/spark/itests/src/test/resources/testconfiguration.properties

Modified: hive/branches/spark/itests/src/test/resources/testconfiguration.properties
URL: http://svn.apache.org/viewvc/hive/branches/spark/itests/src/test/resources/testconfiguration.properties?rev=1618443&r1=1618442&r2=1618443&view=diff
==============================================================================
--- hive/branches/spark/itests/src/test/resources/testconfiguration.properties (original)
+++ hive/branches/spark/itests/src/test/resources/testconfiguration.properties Sun Aug 17 01:29:50 2014
@@ -309,4 +309,11 @@ minimr.query.negative.files=cluster_task
   minimr_broken_pipe.q,\
   udf_local_resource.q
 
-spark.query.files=spark_test.q
+spark.query.files=spark_test.q \
+   timestamp_1.q \
+   timestamp_2.q \
+   timestamp_3.q \
+   timestamp_comparison.q \
+   timestamp_lazy.q \
+   timestamp_null.q \
+   timestamp_udf.q

Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_1.q.out?rev=1618443&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_1.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_1.q.out Sun Aug 17 01:29:50 2014
@@ -0,0 +1,532 @@
+PREHOOK: query: drop table timestamp_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table timestamp_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table timestamp_1 (t timestamp)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@timestamp_1
+POSTHOOK: query: create table timestamp_1 (t timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@timestamp_1
+PREHOOK: query: alter table timestamp_1 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@timestamp_1
+PREHOOK: Output: default@timestamp_1
+POSTHOOK: query: alter table timestamp_1 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@timestamp_1
+POSTHOOK: Output: default@timestamp_1
+PREHOOK: query: insert overwrite table timestamp_1
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_1
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_1
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_1
+POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.293872461E9
+PREHOOK: query: select cast(t as string) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+2011-01-01 01:01:01
+PREHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_1
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_1
+POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.293872461E9
+PREHOOK: query: select cast(t as string) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+2011-01-01 01:01:01
+PREHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_1
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_1
+POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.2938724611E9
+PREHOOK: query: select cast(t as string) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+2011-01-01 01:01:01.1
+PREHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_1
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_1
+POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.2938724610001E9
+PREHOOK: query: select cast(t as string) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+2011-01-01 01:01:01.0001
+PREHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_1
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_1
+POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.2938724610001E9
+PREHOOK: query: select cast(t as string) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+2011-01-01 01:01:01.0001
+PREHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_1
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_1
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_1
+POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+1.293872461001E9
+PREHOOK: query: select cast(t as string) from timestamp_1 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_1
+#### A masked pattern was here ####
+2011-01-01 01:01:01.001000011
+PREHOOK: query: drop table timestamp_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@timestamp_1
+PREHOOK: Output: default@timestamp_1
+POSTHOOK: query: drop table timestamp_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@timestamp_1
+POSTHOOK: Output: default@timestamp_1

Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_2.q.out?rev=1618443&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_2.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_2.q.out Sun Aug 17 01:29:50 2014
@@ -0,0 +1,532 @@
+PREHOOK: query: drop table timestamp_2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table timestamp_2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table timestamp_2 (t timestamp)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: create table timestamp_2 (t timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@timestamp_2
+PREHOOK: query: alter table timestamp_2 set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: alter table timestamp_2 set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: default@timestamp_2
+PREHOOK: query: insert overwrite table timestamp_2
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_2
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.293872461E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+2011-01-01 01:01:01
+PREHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.293872461E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+2011-01-01 01:01:01
+PREHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.2938724611E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+2011-01-01 01:01:01.1
+PREHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.2938724610001E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+2011-01-01 01:01:01.0001
+PREHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.2938724610001E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+2011-01-01 01:01:01.0001
+PREHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_2
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+1.293872461001E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+#### A masked pattern was here ####
+2011-01-01 01:01:01.001000011
+PREHOOK: query: drop table timestamp_2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: drop table timestamp_2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: default@timestamp_2

Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_3.q.out?rev=1618443&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_3.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_3.q.out Sun Aug 17 01:29:50 2014
@@ -0,0 +1,121 @@
+PREHOOK: query: drop table timestamp_3
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table timestamp_3
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table timestamp_3 (t timestamp)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@timestamp_3
+POSTHOOK: query: create table timestamp_3 (t timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@timestamp_3
+PREHOOK: query: alter table timestamp_3 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@timestamp_3
+PREHOOK: Output: default@timestamp_3
+POSTHOOK: query: alter table timestamp_3 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@timestamp_3
+POSTHOOK: Output: default@timestamp_3
+PREHOOK: query: insert overwrite table timestamp_3
+  select cast(cast('1.3041352164485E9' as double) as timestamp) from src tablesample (1 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_3
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_3
+  select cast(cast('1.3041352164485E9' as double) as timestamp) from src tablesample (1 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_3
+POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as boolean) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as tinyint) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+48
+PREHOOK: query: select cast(t as smallint) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as smallint) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+-31184
+PREHOOK: query: select cast(t as int) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as int) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+1304135216
+PREHOOK: query: select cast(t as bigint) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as bigint) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+1304135216
+PREHOOK: query: select cast(t as float) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as float) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+1.30413517E9
+PREHOOK: query: select cast(t as double) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as double) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+1.3041352164485E9
+PREHOOK: query: select cast(t as string) from timestamp_3 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select cast(t as string) from timestamp_3 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+2011-04-29 20:46:56.4485
+PREHOOK: query: select t, sum(t), count(*), sum(t)/count(*), avg(t) from timestamp_3 group by t
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+POSTHOOK: query: select t, sum(t), count(*), sum(t)/count(*), avg(t) from timestamp_3 group by t
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_3
+#### A masked pattern was here ####
+2011-04-29 20:46:56.4485	1.3041352164485E9	1	1.3041352164485E9	1.3041352164485E9
+PREHOOK: query: drop table timestamp_3
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@timestamp_3
+PREHOOK: Output: default@timestamp_3
+POSTHOOK: query: drop table timestamp_3
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@timestamp_3
+POSTHOOK: Output: default@timestamp_3

Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_comparison.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_comparison.q.out?rev=1618443&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_comparison.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_comparison.q.out Sun Aug 17 01:29:50 2014
@@ -0,0 +1,99 @@
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+false
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+false
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) = 
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) = 
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <>
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <>
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+false
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >=
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >=
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <=
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <=
+  cast('2011-05-06 07:08:09' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >=
+  cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >=
+  cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+false
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <
+  cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) <
+  cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true
+PREHOOK: query: select cast('2011-05-06 07:08:09.1000' as timestamp) =
+  cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select cast('2011-05-06 07:08:09.1000' as timestamp) =
+  cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true

Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_lazy.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_lazy.q.out?rev=1618443&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_lazy.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_lazy.q.out Sun Aug 17 01:29:50 2014
@@ -0,0 +1,50 @@
+PREHOOK: query: drop table timestamp_lazy
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table timestamp_lazy
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table timestamp_lazy (t timestamp, key string, value string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@timestamp_lazy
+POSTHOOK: query: create table timestamp_lazy (t timestamp, key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@timestamp_lazy
+PREHOOK: query: insert overwrite table timestamp_lazy select cast('2011-01-01 01:01:01' as timestamp), key, value from src tablesample (5 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_lazy
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: insert overwrite table timestamp_lazy select cast('2011-01-01 01:01:01' as timestamp), key, value from src tablesample (5 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_lazy
+POSTHOOK: Lineage: timestamp_lazy.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: timestamp_lazy.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_lazy.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: select t,key,value from timestamp_lazy ORDER BY key ASC, value ASC
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_lazy
+#### A masked pattern was here ####
+POSTHOOK: query: select t,key,value from timestamp_lazy ORDER BY key ASC, value ASC
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_lazy
+#### A masked pattern was here ####
+2011-01-01 01:01:01	165	val_165
+2011-01-01 01:01:01	238	val_238
+2011-01-01 01:01:01	27	val_27
+2011-01-01 01:01:01	311	val_311
+2011-01-01 01:01:01	86	val_86
+PREHOOK: query: select t,key,value from timestamp_lazy distribute by t sort by key ASC, value ASC
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_lazy
+#### A masked pattern was here ####
+POSTHOOK: query: select t,key,value from timestamp_lazy distribute by t sort by key ASC, value ASC
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_lazy
+#### A masked pattern was here ####
+2011-01-01 01:01:01	165	val_165
+2011-01-01 01:01:01	238	val_238
+2011-01-01 01:01:01	27	val_27
+2011-01-01 01:01:01	311	val_311
+2011-01-01 01:01:01	86	val_86

Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_null.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_null.q.out?rev=1618443&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_null.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_null.q.out Sun Aug 17 01:29:50 2014
@@ -0,0 +1,38 @@
+PREHOOK: query: DROP TABLE IF EXISTS timestamp_null
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE IF EXISTS timestamp_null
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE timestamp_null (t1 TIMESTAMP)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@timestamp_null
+POSTHOOK: query: CREATE TABLE timestamp_null (t1 TIMESTAMP)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@timestamp_null
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/test.dat' OVERWRITE INTO TABLE timestamp_null
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@timestamp_null
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/test.dat' OVERWRITE INTO TABLE timestamp_null
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@timestamp_null
+PREHOOK: query: SELECT * FROM timestamp_null LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_null
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM timestamp_null LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_null
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: SELECT t1 FROM timestamp_null LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_null
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t1 FROM timestamp_null LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_null
+#### A masked pattern was here ####
+NULL

Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_udf.q.out?rev=1618443&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_udf.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/timestamp_udf.q.out Sun Aug 17 01:29:50 2014
@@ -0,0 +1,222 @@
+PREHOOK: query: drop table timestamp_udf
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table timestamp_udf
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table timestamp_udf_string
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table timestamp_udf_string
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table timestamp_udf (t timestamp)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@timestamp_udf
+POSTHOOK: query: create table timestamp_udf (t timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@timestamp_udf
+PREHOOK: query: create table timestamp_udf_string (t string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@timestamp_udf_string
+POSTHOOK: query: create table timestamp_udf_string (t string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@timestamp_udf_string
+PREHOOK: query: from (select * from src tablesample (1 rows)) s
+  insert overwrite table timestamp_udf 
+    select '2011-05-06 07:08:09.1234567'
+  insert overwrite table timestamp_udf_string
+    select '2011-05-06 07:08:09.1234567'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_udf
+PREHOOK: Output: default@timestamp_udf_string
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: from (select * from src tablesample (1 rows)) s
+  insert overwrite table timestamp_udf 
+    select '2011-05-06 07:08:09.1234567'
+  insert overwrite table timestamp_udf_string
+    select '2011-05-06 07:08:09.1234567'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_udf
+POSTHOOK: Output: default@timestamp_udf_string
+POSTHOOK: Lineage: timestamp_udf.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE []
+PREHOOK: query: -- Test UDFs with Timestamp input
+select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+    weekofyear(t), hour(t), minute(t), second(t), to_date(t)
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: -- Test UDFs with Timestamp input
+select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+    weekofyear(t), hour(t), minute(t), second(t), to_date(t)
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+1304690889	2011	5	6	6	18	7	8	9	2011-05-06
+PREHOOK: query: select date_add(t, 5), date_sub(t, 10)
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select date_add(t, 5), date_sub(t, 10)
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+2011-05-11	2011-04-26
+PREHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t)
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t)
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+0	3333	-3333
+PREHOOK: query: select from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+2011-05-06 02:08:09.1234567
+PREHOOK: query: select to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+2011-05-06 12:08:09.1234567
+PREHOOK: query: select t, from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select t, from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+2011-05-06 07:08:09.1234567	2011-05-06 02:08:09.1234567
+PREHOOK: query: select t, from_utc_timestamp(t, 'America/Chicago'), t, from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select t, from_utc_timestamp(t, 'America/Chicago'), t, from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+2011-05-06 07:08:09.1234567	2011-05-06 02:08:09.1234567	2011-05-06 07:08:09.1234567	2011-05-06 02:08:09.1234567
+PREHOOK: query: select t, to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select t, to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+2011-05-06 07:08:09.1234567	2011-05-06 12:08:09.1234567
+PREHOOK: query: select t, to_utc_timestamp(t, 'America/Chicago'), t, to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+POSTHOOK: query: select t, to_utc_timestamp(t, 'America/Chicago'), t, to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf
+#### A masked pattern was here ####
+2011-05-06 07:08:09.1234567	2011-05-06 12:08:09.1234567	2011-05-06 07:08:09.1234567	2011-05-06 12:08:09.1234567
+PREHOOK: query: -- Test UDFs with string input
+select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t), 
+    weekofyear(t), hour(t), minute(t), second(t), to_date(t)
+  from timestamp_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: -- Test UDFs with string input
+select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t), 
+    weekofyear(t), hour(t), minute(t), second(t), to_date(t)
+  from timestamp_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+1304690889	2011	5	6	6	18	7	8	9	2011-05-06
+PREHOOK: query: select date_add(t, 5), date_sub(t, 10)  from timestamp_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: select date_add(t, 5), date_sub(t, 10)  from timestamp_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+2011-05-11	2011-04-26
+PREHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t)
+  from timestamp_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t)
+  from timestamp_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+0	3333	-3333
+PREHOOK: query: select from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: select from_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+2011-05-06 02:08:09.1234567
+PREHOOK: query: select to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf_string
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+POSTHOOK: query: select to_utc_timestamp(t, 'America/Chicago')
+  from timestamp_udf_string
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_udf_string
+#### A masked pattern was here ####
+2011-05-06 12:08:09.1234567
+PREHOOK: query: drop table timestamp_udf
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@timestamp_udf
+PREHOOK: Output: default@timestamp_udf
+POSTHOOK: query: drop table timestamp_udf
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@timestamp_udf
+POSTHOOK: Output: default@timestamp_udf
+PREHOOK: query: drop table timestamp_udf_string
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@timestamp_udf_string
+PREHOOK: Output: default@timestamp_udf_string
+POSTHOOK: query: drop table timestamp_udf_string
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@timestamp_udf_string
+POSTHOOK: Output: default@timestamp_udf_string