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