hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sze...@apache.org
Subject svn commit: r1669724 [1/2] - in /hive/trunk: ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/ ql/src/test/results/clientpositive/spark/ serde/src/java/org/apache/hadoop/hive/serde2/avro/
Date Sat, 28 Mar 2015 01:25:02 GMT
Author: szehon
Date: Sat Mar 28 01:25:02 2015
New Revision: 1669724

URL: http://svn.apache.org/r1669724
Log:
HIVE-10027 : Use descriptions from Avro schema files in column comments (Chaoyu Tang via Szehon)

Added:
    hive/trunk/ql/src/test/queries/clientpositive/avro_comments.q
    hive/trunk/ql/src/test/results/clientpositive/avro_comments.q.out
Modified:
    hive/trunk/ql/src/test/queries/clientpositive/avro_compression_enabled.q
    hive/trunk/ql/src/test/queries/clientpositive/avro_evolved_schemas.q
    hive/trunk/ql/src/test/queries/clientpositive/avro_joins.q
    hive/trunk/ql/src/test/results/clientpositive/avro_add_column.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_add_column2.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_add_column3.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_change_schema.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_compression_enabled.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_decimal.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_decimal_native.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_joins.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_joins_native.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_native.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_partitioned.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_partitioned_native.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_sanity_test.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out
    hive/trunk/ql/src/test/results/clientpositive/avro_schema_literal.q.out
    hive/trunk/ql/src/test/results/clientpositive/create_like.q.out
    hive/trunk/ql/src/test/results/clientpositive/index_serde.q.out
    hive/trunk/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out
    hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins.q.out
    hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins_native.q.out
    hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/avro/AvroObjectInspectorGenerator.java
    hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/avro/AvroSerDe.java

Added: hive/trunk/ql/src/test/queries/clientpositive/avro_comments.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/avro_comments.q?rev=1669724&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/avro_comments.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/avro_comments.q Sat Mar 28 01:25:02 2015
@@ -0,0 +1,150 @@
+-- verify Avro columns comments
+DROP TABLE IF EXISTS testAvroComments1;
+
+CREATE TABLE testAvroComments1
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int",
+      "doc":"Order of playing the role"
+    },
+    {
+      "name":"first_name",
+      "type":"string",
+      "doc":"first name of actor playing role"
+    },
+    {
+      "name":"last_name",
+      "type":"string",
+      "doc":"last name of actor playing role"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "doc":"an extra field not in the original file",
+      "default":"fishfingers and custard"
+    }
+  ]
+}');
+
+DESCRIBE testAvroComments1;
+DROP TABLE testAvroComments1;
+
+DROP TABLE IF EXISTS testAvroComments2;
+CREATE TABLE testAvroComments2
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int",
+      "doc":"Order of playing the role"
+    },
+    {
+      "name":"first_name",
+      "type":"string"
+    },
+    {
+      "name":"last_name",
+      "type":"string",
+      "doc":"last name of actor playing role"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "default":"fishfingers and custard"
+    }
+  ]
+}');
+
+DESCRIBE testAvroComments2;
+DROP TABLE testAvroComments2;
+
+DROP TABLE IF EXISTS testAvroComments3;
+CREATE TABLE testAvroComments3
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int"
+    },
+    {
+      "name":"first_name",
+      "type":"string"
+    },
+    {
+      "name":"last_name",
+      "type":"string"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "default":"fishfingers and custard"
+    }
+  ]
+}');
+
+DESCRIBE testAvroComments3;
+DROP TABLE testAvroComments3;
+
+DROP TABLE IF EXISTS testAvroComments4;
+
+CREATE TABLE testAvroComments4 (
+  number int COMMENT "Order of playing the role",
+  first_name string COMMENT "first name of actor playing role",
+  last_name string COMMENT "last name of actor playing role",
+  extra_field string COMMENT "an extra field not in the original file")
+STORED AS AVRO;
+
+DESCRIBE testAvroComments4;
+DROP TABLE testAvroComments4;
+
+DROP TABLE IF EXISTS testAvroComments5;
+
+CREATE TABLE testAvroComments5 (
+  number int COMMENT "Order of playing the role",
+  first_name string,
+  last_name string COMMENT "last name of actor playing role",
+  extra_field string)
+STORED AS AVRO;
+
+DESCRIBE testAvroComments5;
+DROP TABLE testAvroComments5;
+
+DROP TABLE IF EXISTS testAvroComments6;
+
+CREATE TABLE testAvroComments6 (
+  number int,
+  first_name string,
+  last_name string,
+  extra_field string)
+STORED AS AVRO;
+
+DESCRIBE testAvroComments6;
+DROP TABLE testAvroComments6;
+
+

Modified: hive/trunk/ql/src/test/queries/clientpositive/avro_compression_enabled.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/avro_compression_enabled.q?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/avro_compression_enabled.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/avro_compression_enabled.q Sat Mar 28 01:25:02 2015
@@ -29,7 +29,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]

Modified: hive/trunk/ql/src/test/queries/clientpositive/avro_evolved_schemas.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/avro_evolved_schemas.q?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/avro_evolved_schemas.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/avro_evolved_schemas.q Sat Mar 28 01:25:02 2015
@@ -30,7 +30,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]

Modified: hive/trunk/ql/src/test/queries/clientpositive/avro_joins.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/avro_joins.q?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/avro_joins.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/avro_joins.q Sat Mar 28 01:25:02 2015
@@ -31,7 +31,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_add_column.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_add_column.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_add_column.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_add_column.q.out Sat Mar 28 01:25:02 2015
@@ -24,8 +24,8 @@ PREHOOK: Input: default@doctors
 POSTHOOK: query: DESCRIBE doctors
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
+number              	int                 	                    
+first_name          	string              	                    
 PREHOOK: query: ALTER TABLE doctors ADD COLUMNS (last_name string)
 PREHOOK: type: ALTERTABLE_ADDCOLS
 PREHOOK: Input: default@doctors
@@ -40,9 +40,9 @@ PREHOOK: Input: default@doctors
 POSTHOOK: query: DESCRIBE doctors
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	                    
+first_name          	string              	                    
+last_name           	string              	                    
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_add_column2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_add_column2.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_add_column2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_add_column2.q.out Sat Mar 28 01:25:02 2015
@@ -50,8 +50,8 @@ POSTHOOK: query: INSERT INTO TABLE docto
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@doctors
 POSTHOOK: Output: default@doctors_copy
-POSTHOOK: Lineage: doctors_copy.first_name SIMPLE [(doctors)doctors.FieldSchema(name:first_name, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: doctors_copy.number SIMPLE [(doctors)doctors.FieldSchema(name:number, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: doctors_copy.first_name SIMPLE [(doctors)doctors.FieldSchema(name:first_name, type:string, comment:), ]
+POSTHOOK: Lineage: doctors_copy.number SIMPLE [(doctors)doctors.FieldSchema(name:number, type:int, comment:), ]
 PREHOOK: query: ALTER TABLE doctors_copy ADD COLUMNS (last_name string)
 PREHOOK: type: ALTERTABLE_ADDCOLS
 PREHOOK: Input: default@doctors_copy
@@ -74,9 +74,9 @@ PREHOOK: Input: default@doctors_copy
 POSTHOOK: query: DESCRIBE doctors_copy
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors_copy
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	                    
+first_name          	string              	                    
+last_name           	string              	                    
 PREHOOK: query: SELECT * FROM doctors_copy
 PREHOOK: type: QUERY
 PREHOOK: Input: default@doctors_copy

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_add_column3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_add_column3.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_add_column3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_add_column3.q.out Sat Mar 28 01:25:02 2015
@@ -52,8 +52,8 @@ POSTHOOK: query: INSERT INTO TABLE docto
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@doctors
 POSTHOOK: Output: default@doctors_copy@part=1
-POSTHOOK: Lineage: doctors_copy PARTITION(part=1).first_name SIMPLE [(doctors)doctors.FieldSchema(name:first_name, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: doctors_copy PARTITION(part=1).number SIMPLE [(doctors)doctors.FieldSchema(name:number, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: doctors_copy PARTITION(part=1).first_name SIMPLE [(doctors)doctors.FieldSchema(name:first_name, type:string, comment:), ]
+POSTHOOK: Lineage: doctors_copy PARTITION(part=1).number SIMPLE [(doctors)doctors.FieldSchema(name:number, type:int, comment:), ]
 PREHOOK: query: ALTER TABLE doctors_copy ADD COLUMNS (last_name string)
 PREHOOK: type: ALTERTABLE_ADDCOLS
 PREHOOK: Input: default@doctors_copy
@@ -68,9 +68,9 @@ PREHOOK: Input: default@doctors_copy
 POSTHOOK: query: DESCRIBE doctors_copy
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors_copy
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	                    
+first_name          	string              	                    
+last_name           	string              	                    
 part                	int                 	                    
 	 	 
 # Partition Information	 	 

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_change_schema.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_change_schema.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_change_schema.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_change_schema.q.out Sat Mar 28 01:25:02 2015
@@ -38,8 +38,8 @@ PREHOOK: Input: default@avro2
 POSTHOOK: query: DESCRIBE avro2
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro2
-string1             	string              	from deserializer   
-string2             	string              	from deserializer   
+string1             	string              	                    
+string2             	string              	                    
 PREHOOK: query: ALTER TABLE avro2 SET TBLPROPERTIES ('avro.schema.literal'='{ "namespace": "org.apache.hive",
   "name": "second_schema",
   "type": "record",
@@ -68,6 +68,6 @@ PREHOOK: Input: default@avro2
 POSTHOOK: query: DESCRIBE avro2
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro2
-int1                	int                 	from deserializer   
-float1              	float               	from deserializer   
-double1             	double              	from deserializer   
+int1                	int                 	                    
+float1              	float               	                    
+double1             	double              	                    

Added: hive/trunk/ql/src/test/results/clientpositive/avro_comments.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_comments.q.out?rev=1669724&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_comments.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_comments.q.out Sat Mar 28 01:25:02 2015
@@ -0,0 +1,398 @@
+PREHOOK: query: -- verify Avro columns comments
+DROP TABLE IF EXISTS testAvroComments1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: -- verify Avro columns comments
+DROP TABLE IF EXISTS testAvroComments1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE testAvroComments1
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int",
+      "doc":"Order of playing the role"
+    },
+    {
+      "name":"first_name",
+      "type":"string",
+      "doc":"first name of actor playing role"
+    },
+    {
+      "name":"last_name",
+      "type":"string",
+      "doc":"last name of actor playing role"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "doc":"an extra field not in the original file",
+      "default":"fishfingers and custard"
+    }
+  ]
+}')
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAvroComments1
+POSTHOOK: query: CREATE TABLE testAvroComments1
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int",
+      "doc":"Order of playing the role"
+    },
+    {
+      "name":"first_name",
+      "type":"string",
+      "doc":"first name of actor playing role"
+    },
+    {
+      "name":"last_name",
+      "type":"string",
+      "doc":"last name of actor playing role"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "doc":"an extra field not in the original file",
+      "default":"fishfingers and custard"
+    }
+  ]
+}')
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAvroComments1
+PREHOOK: query: DESCRIBE testAvroComments1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@testavrocomments1
+POSTHOOK: query: DESCRIBE testAvroComments1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@testavrocomments1
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
+extra_field         	string              	an extra field not in the original file
+PREHOOK: query: DROP TABLE testAvroComments1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testavrocomments1
+PREHOOK: Output: default@testavrocomments1
+POSTHOOK: query: DROP TABLE testAvroComments1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testavrocomments1
+POSTHOOK: Output: default@testavrocomments1
+PREHOOK: query: DROP TABLE IF EXISTS testAvroComments2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE IF EXISTS testAvroComments2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE testAvroComments2
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int",
+      "doc":"Order of playing the role"
+    },
+    {
+      "name":"first_name",
+      "type":"string"
+    },
+    {
+      "name":"last_name",
+      "type":"string",
+      "doc":"last name of actor playing role"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "default":"fishfingers and custard"
+    }
+  ]
+}')
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAvroComments2
+POSTHOOK: query: CREATE TABLE testAvroComments2
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int",
+      "doc":"Order of playing the role"
+    },
+    {
+      "name":"first_name",
+      "type":"string"
+    },
+    {
+      "name":"last_name",
+      "type":"string",
+      "doc":"last name of actor playing role"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "default":"fishfingers and custard"
+    }
+  ]
+}')
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAvroComments2
+PREHOOK: query: DESCRIBE testAvroComments2
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@testavrocomments2
+POSTHOOK: query: DESCRIBE testAvroComments2
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@testavrocomments2
+number              	int                 	Order of playing the role
+first_name          	string              	                    
+last_name           	string              	last name of actor playing role
+extra_field         	string              	                    
+PREHOOK: query: DROP TABLE testAvroComments2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testavrocomments2
+PREHOOK: Output: default@testavrocomments2
+POSTHOOK: query: DROP TABLE testAvroComments2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testavrocomments2
+POSTHOOK: Output: default@testavrocomments2
+PREHOOK: query: DROP TABLE IF EXISTS testAvroComments3
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE IF EXISTS testAvroComments3
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE testAvroComments3
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int"
+    },
+    {
+      "name":"first_name",
+      "type":"string"
+    },
+    {
+      "name":"last_name",
+      "type":"string"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "default":"fishfingers and custard"
+    }
+  ]
+}')
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAvroComments3
+POSTHOOK: query: CREATE TABLE testAvroComments3
+ROW FORMAT
+SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
+STORED AS
+INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
+OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
+TBLPROPERTIES ('avro.schema.literal'='{
+  "namespace": "testing.hive.avro.serde",
+  "name": "doctors",
+  "type": "record",
+  "fields": [
+    {
+      "name":"number",
+      "type":"int"
+    },
+    {
+      "name":"first_name",
+      "type":"string"
+    },
+    {
+      "name":"last_name",
+      "type":"string"
+    },
+    {
+      "name":"extra_field",
+      "type":"string",
+      "default":"fishfingers and custard"
+    }
+  ]
+}')
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAvroComments3
+PREHOOK: query: DESCRIBE testAvroComments3
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@testavrocomments3
+POSTHOOK: query: DESCRIBE testAvroComments3
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@testavrocomments3
+number              	int                 	                    
+first_name          	string              	                    
+last_name           	string              	                    
+extra_field         	string              	                    
+PREHOOK: query: DROP TABLE testAvroComments3
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testavrocomments3
+PREHOOK: Output: default@testavrocomments3
+POSTHOOK: query: DROP TABLE testAvroComments3
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testavrocomments3
+POSTHOOK: Output: default@testavrocomments3
+PREHOOK: query: DROP TABLE IF EXISTS testAvroComments4
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE IF EXISTS testAvroComments4
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE testAvroComments4 (
+  number int COMMENT "Order of playing the role",
+  first_name string COMMENT "first name of actor playing role",
+  last_name string COMMENT "last name of actor playing role",
+  extra_field string COMMENT "an extra field not in the original file")
+STORED AS AVRO
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAvroComments4
+POSTHOOK: query: CREATE TABLE testAvroComments4 (
+  number int COMMENT "Order of playing the role",
+  first_name string COMMENT "first name of actor playing role",
+  last_name string COMMENT "last name of actor playing role",
+  extra_field string COMMENT "an extra field not in the original file")
+STORED AS AVRO
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAvroComments4
+PREHOOK: query: DESCRIBE testAvroComments4
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@testavrocomments4
+POSTHOOK: query: DESCRIBE testAvroComments4
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@testavrocomments4
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
+extra_field         	string              	an extra field not in the original file
+PREHOOK: query: DROP TABLE testAvroComments4
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testavrocomments4
+PREHOOK: Output: default@testavrocomments4
+POSTHOOK: query: DROP TABLE testAvroComments4
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testavrocomments4
+POSTHOOK: Output: default@testavrocomments4
+PREHOOK: query: DROP TABLE IF EXISTS testAvroComments5
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE IF EXISTS testAvroComments5
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE testAvroComments5 (
+  number int COMMENT "Order of playing the role",
+  first_name string,
+  last_name string COMMENT "last name of actor playing role",
+  extra_field string)
+STORED AS AVRO
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAvroComments5
+POSTHOOK: query: CREATE TABLE testAvroComments5 (
+  number int COMMENT "Order of playing the role",
+  first_name string,
+  last_name string COMMENT "last name of actor playing role",
+  extra_field string)
+STORED AS AVRO
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAvroComments5
+PREHOOK: query: DESCRIBE testAvroComments5
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@testavrocomments5
+POSTHOOK: query: DESCRIBE testAvroComments5
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@testavrocomments5
+number              	int                 	Order of playing the role
+first_name          	string              	                    
+last_name           	string              	last name of actor playing role
+extra_field         	string              	                    
+PREHOOK: query: DROP TABLE testAvroComments5
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testavrocomments5
+PREHOOK: Output: default@testavrocomments5
+POSTHOOK: query: DROP TABLE testAvroComments5
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testavrocomments5
+POSTHOOK: Output: default@testavrocomments5
+PREHOOK: query: DROP TABLE IF EXISTS testAvroComments6
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE IF EXISTS testAvroComments6
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE testAvroComments6 (
+  number int,
+  first_name string,
+  last_name string,
+  extra_field string)
+STORED AS AVRO
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAvroComments6
+POSTHOOK: query: CREATE TABLE testAvroComments6 (
+  number int,
+  first_name string,
+  last_name string,
+  extra_field string)
+STORED AS AVRO
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAvroComments6
+PREHOOK: query: DESCRIBE testAvroComments6
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@testavrocomments6
+POSTHOOK: query: DESCRIBE testAvroComments6
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@testavrocomments6
+number              	int                 	                    
+first_name          	string              	                    
+last_name           	string              	                    
+extra_field         	string              	                    
+PREHOOK: query: DROP TABLE testAvroComments6
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testavrocomments6
+PREHOOK: Output: default@testavrocomments6
+POSTHOOK: query: DROP TABLE testAvroComments6
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testavrocomments6
+POSTHOOK: Output: default@testavrocomments6

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_compression_enabled.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_compression_enabled.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_compression_enabled.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_compression_enabled.q.out Sat Mar 28 01:25:02 2015
@@ -29,7 +29,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]
@@ -68,7 +68,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_decimal.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_decimal.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_decimal.q.out Sat Mar 28 01:25:02 2015
@@ -79,8 +79,8 @@ PREHOOK: Input: default@avro_dec
 POSTHOOK: query: DESC avro_dec
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro_dec
-name                	string              	from deserializer   
-value               	decimal(5,2)        	from deserializer   
+name                	string              	                    
+value               	decimal(5,2)        	                    
 PREHOOK: query: INSERT OVERWRITE TABLE avro_dec select name, value from dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dec
@@ -153,8 +153,8 @@ PREHOOK: Input: default@avro_dec1
 POSTHOOK: query: DESC avro_dec1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro_dec1
-name                	string              	from deserializer   
-value               	decimal(4,1)        	from deserializer   
+name                	string              	                    
+value               	decimal(4,1)        	                    
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.avro' into TABLE avro_dec1
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_decimal_native.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_decimal_native.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_decimal_native.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_decimal_native.q.out Sat Mar 28 01:25:02 2015
@@ -65,8 +65,8 @@ PREHOOK: Input: default@avro_dec
 POSTHOOK: query: DESC avro_dec
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro_dec
-name                	string              	from deserializer   
-value               	decimal(5,2)        	from deserializer   
+name                	string              	                    
+value               	decimal(5,2)        	                    
 PREHOOK: query: INSERT OVERWRITE TABLE avro_dec SELECT name, value FROM dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dec
@@ -121,8 +121,8 @@ PREHOOK: Input: default@avro_dec1
 POSTHOOK: query: DESC avro_dec1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro_dec1
-name                	string              	from deserializer   
-value               	decimal(4,1)        	from deserializer   
+name                	string              	                    
+value               	decimal(4,1)        	                    
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.avro' INTO TABLE avro_dec1
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out Sat Mar 28 01:25:02 2015
@@ -30,7 +30,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]
@@ -70,7 +70,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]
@@ -84,10 +84,10 @@ PREHOOK: Input: default@doctors_with_new
 POSTHOOK: query: DESCRIBE doctors_with_new_field
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors_with_new_field
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
-extra_field         	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
+extra_field         	string              	an extra field not in the original file
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors_with_new_field
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_joins.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_joins.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_joins.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_joins.q.out Sat Mar 28 01:25:02 2015
@@ -31,7 +31,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]
@@ -72,7 +72,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]
@@ -86,10 +86,10 @@ PREHOOK: Input: default@doctors4
 POSTHOOK: query: DESCRIBE doctors4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors4
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
-extra_field         	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
+extra_field         	string              	an extra field not in the original file
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors4
 PREHOOK: type: LOAD
 #### A masked pattern was here ####
@@ -166,9 +166,9 @@ PREHOOK: Input: default@episodes
 POSTHOOK: query: DESCRIBE episodes
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@episodes
-title               	string              	from deserializer   
-air_date            	string              	from deserializer   
-doctor              	int                 	from deserializer   
+title               	string              	episode title       
+air_date            	string              	initial date        
+doctor              	int                 	main actor playing the Doctor in episode
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/episodes.avro' INTO TABLE episodes
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_joins_native.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_joins_native.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_joins_native.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_joins_native.q.out Sat Mar 28 01:25:02 2015
@@ -28,9 +28,9 @@ PREHOOK: Input: default@doctors4
 POSTHOOK: query: DESCRIBE doctors4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors4
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors4
 PREHOOK: type: LOAD
 #### A masked pattern was here ####
@@ -61,9 +61,9 @@ PREHOOK: Input: default@episodes
 POSTHOOK: query: DESCRIBE episodes
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@episodes
-title               	string              	from deserializer   
-air_date            	string              	from deserializer   
-doctor              	int                 	from deserializer   
+title               	string              	episode title       
+air_date            	string              	initial date        
+doctor              	int                 	main actor playing the Doctor in episode
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/episodes.avro' INTO TABLE episodes
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_native.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_native.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_native.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_native.q.out Sat Mar 28 01:25:02 2015
@@ -26,9 +26,9 @@ PREHOOK: Input: default@doctors
 POSTHOOK: query: DESCRIBE doctors
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	                    
+first_name          	string              	                    
+last_name           	string              	                    
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_partitioned.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_partitioned.q.out Sat Mar 28 01:25:02 2015
@@ -150,27 +150,27 @@ POSTHOOK: Output: default@episodes_parti
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=5
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=6
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=9
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
 PREHOOK: query: SELECT * FROM episodes_partitioned WHERE doctor_pt > 6
 PREHOOK: type: QUERY
 PREHOOK: Input: default@episodes_partitioned
@@ -360,27 +360,27 @@ POSTHOOK: Output: default@episodes_parti
 POSTHOOK: Output: default@episodes_partitioned_serdeproperties@doctor_pt=5
 POSTHOOK: Output: default@episodes_partitioned_serdeproperties@doctor_pt=6
 POSTHOOK: Output: default@episodes_partitioned_serdeproperties@doctor_pt=9
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
 PREHOOK: query: -- Evolve the table schema by adding new array field "cast_and_crew"
 ALTER TABLE episodes_partitioned_serdeproperties
 SET SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_partitioned_native.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_partitioned_native.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_partitioned_native.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_partitioned_native.q.out Sat Mar 28 01:25:02 2015
@@ -60,27 +60,27 @@ POSTHOOK: Output: default@episodes_parti
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=5
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=6
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=9
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
 PREHOOK: query: SELECT * FROM episodes_partitioned WHERE doctor_pt > 6
 PREHOOK: type: QUERY
 PREHOOK: Input: default@episodes_partitioned

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_sanity_test.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_sanity_test.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_sanity_test.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_sanity_test.q.out Sat Mar 28 01:25:02 2015
@@ -72,9 +72,9 @@ PREHOOK: Input: default@doctors
 POSTHOOK: query: DESCRIBE doctors
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out Sat Mar 28 01:25:02 2015
@@ -60,27 +60,27 @@ POSTHOOK: Output: default@episodes_parti
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=5
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=6
 POSTHOOK: Output: default@episodes_partitioned@doctor_pt=9
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ]
-POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:initial date), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
+POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:episode title), ]
 PREHOOK: query: ALTER TABLE episodes_partitioned
 SET SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
 WITH

Modified: hive/trunk/ql/src/test/results/clientpositive/avro_schema_literal.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/avro_schema_literal.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/avro_schema_literal.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/avro_schema_literal.q.out Sat Mar 28 01:25:02 2015
@@ -70,20 +70,20 @@ PREHOOK: Input: default@avro1
 POSTHOOK: query: DESCRIBE avro1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro1
-string1             	string              	from deserializer   
-int1                	int                 	from deserializer   
-tinyint1            	int                 	from deserializer   
-smallint1           	int                 	from deserializer   
-bigint1             	bigint              	from deserializer   
-boolean1            	boolean             	from deserializer   
-float1              	float               	from deserializer   
-double1             	double              	from deserializer   
-list1               	array<string>       	from deserializer   
-map1                	map<string,int>     	from deserializer   
-struct1             	struct<sint:int,sboolean:boolean,sstring:string>	from deserializer   
-union1              	uniontype<float,boolean,string>	from deserializer   
-enum1               	string              	from deserializer   
-nullableint         	int                 	from deserializer   
-bytes1              	binary              	from deserializer   
-fixed1              	binary              	from deserializer   
-dec1                	decimal(5,2)        	from deserializer   
+string1             	string              	                    
+int1                	int                 	                    
+tinyint1            	int                 	                    
+smallint1           	int                 	                    
+bigint1             	bigint              	                    
+boolean1            	boolean             	                    
+float1              	float               	                    
+double1             	double              	                    
+list1               	array<string>       	                    
+map1                	map<string,int>     	                    
+struct1             	struct<sint:int,sboolean:boolean,sstring:string>	                    
+union1              	uniontype<float,boolean,string>	                    
+enum1               	string              	                    
+nullableint         	int                 	                    
+bytes1              	binary              	                    
+fixed1              	binary              	                    
+dec1                	decimal(5,2)        	                    

Modified: hive/trunk/ql/src/test/results/clientpositive/create_like.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like.q.out Sat Mar 28 01:25:02 2015
@@ -331,9 +331,9 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors
 # col_name            	data_type           	comment             
 	 	 
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
 	 	 
 # Detailed Table Information	 	 
 Database:           	default             	 
@@ -380,9 +380,9 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors2
 # col_name            	data_type           	comment             
 	 	 
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
 	 	 
 # Detailed Table Information	 	 
 Database:           	default             	 

Modified: hive/trunk/ql/src/test/results/clientpositive/index_serde.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_serde.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_serde.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_serde.q.out Sat Mar 28 01:25:02 2015
@@ -72,9 +72,9 @@ PREHOOK: Input: default@doctors
 POSTHOOK: query: DESCRIBE doctors
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors
 PREHOOK: type: LOAD
 #### A masked pattern was here ####
@@ -98,7 +98,7 @@ PREHOOK: Input: default@default__doctors
 POSTHOOK: query: DESCRIBE EXTENDED default__doctors_doctors_index__
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@default__doctors_doctors_index__
-number              	int                 	from deserializer   
+number              	int                 	Order of playing the role
 _bucketname         	string              	                    
 _offsets            	array<bigint>       	                    
 	 	 
@@ -113,7 +113,7 @@ POSTHOOK: Input: default@doctors
 POSTHOOK: Output: default@default__doctors_doctors_index__
 POSTHOOK: Lineage: default__doctors_doctors_index__._bucketname SIMPLE [(doctors)doctors.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: default__doctors_doctors_index__._offsets EXPRESSION [(doctors)doctors.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
-POSTHOOK: Lineage: default__doctors_doctors_index__.number SIMPLE [(doctors)doctors.FieldSchema(name:number, type:int, comment:from deserializer), ]
+POSTHOOK: Lineage: default__doctors_doctors_index__.number SIMPLE [(doctors)doctors.FieldSchema(name:number, type:int, comment:Order of playing the role), ]
 PREHOOK: query: EXPLAIN SELECT * FROM doctors WHERE number > 6
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT * FROM doctors WHERE number > 6

Modified: hive/trunk/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out Sat Mar 28 01:25:02 2015
@@ -65,8 +65,8 @@ PREHOOK: Input: default@avro_dec
 POSTHOOK: query: DESC avro_dec
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro_dec
-name                	string              	from deserializer   
-value               	decimal(5,2)        	from deserializer   
+name                	string              	                    
+value               	decimal(5,2)        	                    
 PREHOOK: query: INSERT OVERWRITE TABLE avro_dec SELECT name, value FROM dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dec
@@ -121,8 +121,8 @@ PREHOOK: Input: default@avro_dec1
 POSTHOOK: query: DESC avro_dec1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@avro_dec1
-name                	string              	from deserializer   
-value               	decimal(4,1)        	from deserializer   
+name                	string              	                    
+value               	decimal(4,1)        	                    
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dec.avro' INTO TABLE avro_dec1
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins.q.out Sat Mar 28 01:25:02 2015
@@ -31,7 +31,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]
@@ -72,7 +72,7 @@ TBLPROPERTIES ('avro.schema.literal'='{
     {
       "name":"extra_field",
       "type":"string",
-      "doc:":"an extra field not in the original file",
+      "doc":"an extra field not in the original file",
       "default":"fishfingers and custard"
     }
   ]
@@ -86,10 +86,10 @@ PREHOOK: Input: default@doctors4
 POSTHOOK: query: DESCRIBE doctors4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors4
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
-extra_field         	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
+extra_field         	string              	an extra field not in the original file
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors4
 PREHOOK: type: LOAD
 #### A masked pattern was here ####
@@ -166,9 +166,9 @@ PREHOOK: Input: default@episodes
 POSTHOOK: query: DESCRIBE episodes
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@episodes
-title               	string              	from deserializer   
-air_date            	string              	from deserializer   
-doctor              	int                 	from deserializer   
+title               	string              	episode title       
+air_date            	string              	initial date        
+doctor              	int                 	main actor playing the Doctor in episode
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/episodes.avro' INTO TABLE episodes
 PREHOOK: type: LOAD
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins_native.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins_native.q.out?rev=1669724&r1=1669723&r2=1669724&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins_native.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/spark/avro_joins_native.q.out Sat Mar 28 01:25:02 2015
@@ -28,9 +28,9 @@ PREHOOK: Input: default@doctors4
 POSTHOOK: query: DESCRIBE doctors4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@doctors4
-number              	int                 	from deserializer   
-first_name          	string              	from deserializer   
-last_name           	string              	from deserializer   
+number              	int                 	Order of playing the role
+first_name          	string              	first name of actor playing role
+last_name           	string              	last name of actor playing role
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors4
 PREHOOK: type: LOAD
 #### A masked pattern was here ####
@@ -61,9 +61,9 @@ PREHOOK: Input: default@episodes
 POSTHOOK: query: DESCRIBE episodes
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@episodes
-title               	string              	from deserializer   
-air_date            	string              	from deserializer   
-doctor              	int                 	from deserializer   
+title               	string              	episode title       
+air_date            	string              	initial date        
+doctor              	int                 	main actor playing the Doctor in episode
 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/episodes.avro' INTO TABLE episodes
 PREHOOK: type: LOAD
 #### A masked pattern was here ####



Mime
View raw message