PREHOOK: query: CREATE TABLE episodes_n2
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": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@episodes_n2
POSTHOOK: query: CREATE TABLE episodes_n2
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": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@episodes_n2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/episodes.avro' INTO TABLE episodes_n2
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@episodes_n2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/episodes.avro' INTO TABLE episodes_n2
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@episodes_n2
PREHOOK: query: CREATE TABLE episodes_partitioned_n1
PARTITIONED BY (doctor_pt INT)
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": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@episodes_partitioned_n1
POSTHOOK: query: CREATE TABLE episodes_partitioned_n1
PARTITIONED BY (doctor_pt INT)
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": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@episodes_partitioned_n1
PREHOOK: query: INSERT OVERWRITE TABLE episodes_partitioned_n1 PARTITION (doctor_pt) SELECT title, air_date, doctor, doctor as doctor_pt FROM episodes_n2
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_n2
PREHOOK: Output: default@episodes_partitioned_n1
POSTHOOK: query: INSERT OVERWRITE TABLE episodes_partitioned_n1 PARTITION (doctor_pt) SELECT title, air_date, doctor, doctor as doctor_pt FROM episodes_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_n2
POSTHOOK: Output: default@episodes_partitioned_n1
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=1
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=11
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=2
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=4
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=5
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=6
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=9
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=11).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=11).doctor SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=11).title SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=1).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=1).doctor SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=1).title SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=2).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=2).doctor SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=2).title SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=4).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=4).doctor SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=4).title SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=5).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=5).doctor SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=5).title SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=6).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=6).doctor SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=6).title SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=9).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=9).doctor SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:doctor, type:int, comment:main actor playing the Doctor in episode), ]
POSTHOOK: Lineage: episodes_partitioned_n1 PARTITION(doctor_pt=9).title SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
PREHOOK: query: SELECT * FROM episodes_partitioned_n1 WHERE doctor_pt > 6
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_partitioned_n1
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=11
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=9
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM episodes_partitioned_n1 WHERE doctor_pt > 6
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_partitioned_n1
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=11
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=9
#### A masked pattern was here ####
Rose	26 March 2005	9	9
The Doctor's Wife	14 May 2011	11	11
The Eleventh Hour	3 April 2010	11	11
PREHOOK: query: SELECT * FROM episodes_partitioned_n1 ORDER BY air_date LIMIT 5
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_partitioned_n1
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=1
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=11
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=2
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=4
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=5
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=6
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=9
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM episodes_partitioned_n1 ORDER BY air_date LIMIT 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_partitioned_n1
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=1
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=11
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=2
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=4
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=5
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=6
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=9
#### A masked pattern was here ####
An Unearthly Child	23 November 1963	1	1
Horror of Fang Rock	3 September 1977	4	4
Rose	26 March 2005	9	9
The Doctor's Wife	14 May 2011	11	11
The Eleventh Hour	3 April 2010	11	11
PREHOOK: query: SELECT * FROM episodes_partitioned_n1 WHERE doctor_pt = 6
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_partitioned_n1
PREHOOK: Input: default@episodes_partitioned_n1@doctor_pt=6
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM episodes_partitioned_n1 WHERE doctor_pt = 6
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_partitioned_n1
POSTHOOK: Input: default@episodes_partitioned_n1@doctor_pt=6
#### A masked pattern was here ####
The Mysterious Planet	6 September 1986	6	6
PREHOOK: query: SELECT * FROM episodes_partitioned_n1 WHERE doctor_pt = 7 LIMIT 5
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_partitioned_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM episodes_partitioned_n1 WHERE doctor_pt = 7 LIMIT 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_partitioned_n1
#### A masked pattern was here ####
PREHOOK: query: ALTER TABLE episodes_partitioned_n1 ADD PARTITION (doctor_pt=7)
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Output: default@episodes_partitioned_n1
POSTHOOK: query: ALTER TABLE episodes_partitioned_n1 ADD PARTITION (doctor_pt=7)
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Output: default@episodes_partitioned_n1
POSTHOOK: Output: default@episodes_partitioned_n1@doctor_pt=7
PREHOOK: query: SELECT COUNT(*) FROM episodes_partitioned_n1
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_partitioned_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM episodes_partitioned_n1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_partitioned_n1
#### A masked pattern was here ####
8
PREHOOK: query: CREATE TABLE episodes_partitioned_serdeproperties
PARTITIONED BY (doctor_pt INT)
ROW FORMAT
SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
WITH SERDEPROPERTIES ('avro.schema.literal'='{
  "namespace": "testing.hive.avro.serde",
  "name": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
STORED AS
INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@episodes_partitioned_serdeproperties
POSTHOOK: query: CREATE TABLE episodes_partitioned_serdeproperties
PARTITIONED BY (doctor_pt INT)
ROW FORMAT
SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
WITH SERDEPROPERTIES ('avro.schema.literal'='{
  "namespace": "testing.hive.avro.serde",
  "name": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
STORED AS
INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@episodes_partitioned_serdeproperties
PREHOOK: query: INSERT INTO TABLE episodes_partitioned_serdeproperties PARTITION (doctor_pt) SELECT title, air_date, doctor, doctor as doctor_pt FROM episodes_n2
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_n2
PREHOOK: Output: default@episodes_partitioned_serdeproperties
POSTHOOK: query: INSERT INTO TABLE episodes_partitioned_serdeproperties PARTITION (doctor_pt) SELECT title, air_date, doctor, doctor as doctor_pt FROM episodes_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_n2
POSTHOOK: Output: default@episodes_partitioned_serdeproperties
POSTHOOK: Output: default@episodes_partitioned_serdeproperties@doctor_pt=1
POSTHOOK: Output: default@episodes_partitioned_serdeproperties@doctor_pt=11
POSTHOOK: Output: default@episodes_partitioned_serdeproperties@doctor_pt=2
POSTHOOK: Output: default@episodes_partitioned_serdeproperties@doctor_pt=4
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_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=11).doctor SIMPLE [(episodes_n2)episodes_n2.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_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=1).doctor SIMPLE [(episodes_n2)episodes_n2.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_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=2).doctor SIMPLE [(episodes_n2)episodes_n2.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_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=4).doctor SIMPLE [(episodes_n2)episodes_n2.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_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=5).doctor SIMPLE [(episodes_n2)episodes_n2.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_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=6).doctor SIMPLE [(episodes_n2)episodes_n2.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_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).air_date SIMPLE [(episodes_n2)episodes_n2.FieldSchema(name:air_date, type:string, comment:initial date), ]
POSTHOOK: Lineage: episodes_partitioned_serdeproperties PARTITION(doctor_pt=9).doctor SIMPLE [(episodes_n2)episodes_n2.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_n2)episodes_n2.FieldSchema(name:title, type:string, comment:episode title), ]
PREHOOK: query: ALTER TABLE episodes_partitioned_serdeproperties
SET SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
WITH SERDEPROPERTIES ('avro.schema.literal'='{
  "namespace": "testing.hive.avro.serde",
  "name": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"cast_and_crew",
      "type":{"type":"array","items":"string"},
      "default":[]
    },
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
PREHOOK: type: ALTERTABLE_SERIALIZER
PREHOOK: Input: default@episodes_partitioned_serdeproperties
PREHOOK: Output: default@episodes_partitioned_serdeproperties
POSTHOOK: query: ALTER TABLE episodes_partitioned_serdeproperties
SET SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
WITH SERDEPROPERTIES ('avro.schema.literal'='{
  "namespace": "testing.hive.avro.serde",
  "name": "episodes_n2",
  "type": "record",
  "fields": [
    {
      "name":"cast_and_crew",
      "type":{"type":"array","items":"string"},
      "default":[]
    },
    {
      "name":"title",
      "type":"string",
      "doc":"episode title"
    },
    {
      "name":"air_date",
      "type":"string",
      "doc":"initial date"
    },
    {
      "name":"doctor",
      "type":"int",
      "doc":"main actor playing the Doctor in episode"
    }
  ]
}')
POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@episodes_partitioned_serdeproperties
POSTHOOK: Output: default@episodes_partitioned_serdeproperties
PREHOOK: query: SELECT * FROM episodes_partitioned_serdeproperties
PREHOOK: type: QUERY
PREHOOK: Input: default@episodes_partitioned_serdeproperties
PREHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=1
PREHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=11
PREHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=2
PREHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=4
PREHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=5
PREHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=6
PREHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=9
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM episodes_partitioned_serdeproperties
POSTHOOK: type: QUERY
POSTHOOK: Input: default@episodes_partitioned_serdeproperties
POSTHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=1
POSTHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=11
POSTHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=2
POSTHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=4
POSTHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=5
POSTHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=6
POSTHOOK: Input: default@episodes_partitioned_serdeproperties@doctor_pt=9
#### A masked pattern was here ####
[]	An Unearthly Child	23 November 1963	1	1
[]	Castrolava	4 January 1982	5	5
[]	Horror of Fang Rock	3 September 1977	4	4
[]	Rose	26 March 2005	9	9
[]	The Doctor's Wife	14 May 2011	11	11
[]	The Eleventh Hour	3 April 2010	11	11
[]	The Mysterious Planet	6 September 1986	6	6
[]	The Power of the Daleks	5 November 1966	2	2