ql/src/test/results/clientpositive/llap/avro_joins.q.out

PREHOOK: query: CREATE TABLE doctors4_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": "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@doctors4_n2
POSTHOOK: query: CREATE TABLE doctors4_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": "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@doctors4_n2
PREHOOK: query: DESCRIBE doctors4_n2
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@doctors4_n2
POSTHOOK: query: DESCRIBE doctors4_n2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@doctors4_n2
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_n2
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@doctors4_n2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors4_n2
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@doctors4_n2
PREHOOK: query: CREATE TABLE episodes_n3
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_n3",
  "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_n3
POSTHOOK: query: CREATE TABLE episodes_n3
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_n3",
  "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_n3
PREHOOK: query: DESCRIBE episodes_n3
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@episodes_n3
POSTHOOK: query: DESCRIBE episodes_n3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@episodes_n3
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_n3
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@episodes_n3
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/episodes.avro' INTO TABLE episodes_n3
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@episodes_n3
PREHOOK: query: SELECT e.title, e.air_date, d.first_name, d.last_name, d.extra_field, e.air_date
FROM doctors4_n2 d JOIN episodes_n3 e ON (d.number=e.doctor)
PREHOOK: type: QUERY
PREHOOK: Input: default@doctors4_n2
PREHOOK: Input: default@episodes_n3
#### A masked pattern was here ####
POSTHOOK: query: SELECT e.title, e.air_date, d.first_name, d.last_name, d.extra_field, e.air_date
FROM doctors4_n2 d JOIN episodes_n3 e ON (d.number=e.doctor)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@doctors4_n2
POSTHOOK: Input: default@episodes_n3
#### A masked pattern was here ####
An Unearthly Child	23 November 1963	William	Hartnell	fishfingers and custard	23 November 1963
Castrolava	4 January 1982	Peter	Davison	fishfingers and custard	4 January 1982
Horror of Fang Rock	3 September 1977	Tom	Baker	fishfingers and custard	3 September 1977
Rose	26 March 2005	Christopher	Eccleston	fishfingers and custard	26 March 2005
The Doctor's Wife	14 May 2011	Matt	Smith	fishfingers and custard	14 May 2011
The Eleventh Hour	3 April 2010	Matt	Smith	fishfingers and custard	3 April 2010
The Mysterious Planet	6 September 1986	Colin	Baker	fishfingers and custard	6 September 1986
The Power of the Daleks	5 November 1966	Patrick	Troughton	fishfingers and custard	5 November 1966