| PREHOOK: query: drop table store_sales_n0 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table store_sales_n0 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: drop table store_n0 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table store_n0 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: drop table customer_address |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table customer_address |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: create table store_sales_n0 |
| ( |
| ss_sold_date_sk int, |
| ss_sold_time_sk int, |
| ss_item_sk int, |
| ss_customer_sk int, |
| ss_cdemo_sk int, |
| ss_hdemo_sk int, |
| ss_addr_sk int, |
| ss_store_sk int, |
| ss_promo_sk int, |
| ss_ticket_number int, |
| ss_quantity int, |
| ss_wholesale_cost float, |
| ss_list_price float, |
| ss_sales_price float, |
| ss_ext_discount_amt float, |
| ss_ext_sales_price float, |
| ss_ext_wholesale_cost float, |
| ss_ext_list_price float, |
| ss_ext_tax float, |
| ss_coupon_amt float, |
| ss_net_paid float, |
| ss_net_paid_inc_tax float, |
| ss_net_profit float |
| ) |
| row format delimited fields terminated by '|' |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@store_sales_n0 |
| POSTHOOK: query: create table store_sales_n0 |
| ( |
| ss_sold_date_sk int, |
| ss_sold_time_sk int, |
| ss_item_sk int, |
| ss_customer_sk int, |
| ss_cdemo_sk int, |
| ss_hdemo_sk int, |
| ss_addr_sk int, |
| ss_store_sk int, |
| ss_promo_sk int, |
| ss_ticket_number int, |
| ss_quantity int, |
| ss_wholesale_cost float, |
| ss_list_price float, |
| ss_sales_price float, |
| ss_ext_discount_amt float, |
| ss_ext_sales_price float, |
| ss_ext_wholesale_cost float, |
| ss_ext_list_price float, |
| ss_ext_tax float, |
| ss_coupon_amt float, |
| ss_net_paid float, |
| ss_net_paid_inc_tax float, |
| ss_net_profit float |
| ) |
| row format delimited fields terminated by '|' |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@store_sales_n0 |
| PREHOOK: query: create table store_n0 |
| ( |
| s_store_sk int, |
| s_store_id string, |
| s_rec_start_date string, |
| s_rec_end_date string, |
| s_closed_date_sk int, |
| s_store_name string, |
| s_number_employees int, |
| s_floor_space int, |
| s_hours string, |
| s_manager string, |
| s_market_id int, |
| s_geography_class string, |
| s_market_desc string, |
| s_market_manager string, |
| s_division_id int, |
| s_division_name string, |
| s_company_id int, |
| s_company_name string, |
| s_street_number string, |
| s_street_name string, |
| s_street_type string, |
| s_suite_number string, |
| s_city string, |
| s_county string, |
| s_state string, |
| s_zip string, |
| s_country string, |
| s_gmt_offset float, |
| s_tax_precentage float |
| ) |
| row format delimited fields terminated by '|' |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@store_n0 |
| POSTHOOK: query: create table store_n0 |
| ( |
| s_store_sk int, |
| s_store_id string, |
| s_rec_start_date string, |
| s_rec_end_date string, |
| s_closed_date_sk int, |
| s_store_name string, |
| s_number_employees int, |
| s_floor_space int, |
| s_hours string, |
| s_manager string, |
| s_market_id int, |
| s_geography_class string, |
| s_market_desc string, |
| s_market_manager string, |
| s_division_id int, |
| s_division_name string, |
| s_company_id int, |
| s_company_name string, |
| s_street_number string, |
| s_street_name string, |
| s_street_type string, |
| s_suite_number string, |
| s_city string, |
| s_county string, |
| s_state string, |
| s_zip string, |
| s_country string, |
| s_gmt_offset float, |
| s_tax_precentage float |
| ) |
| row format delimited fields terminated by '|' |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@store_n0 |
| PREHOOK: query: create table store_bigint |
| ( |
| s_store_sk bigint, |
| s_store_id string, |
| s_rec_start_date string, |
| s_rec_end_date string, |
| s_closed_date_sk int, |
| s_store_name string, |
| s_number_employees int, |
| s_floor_space int, |
| s_hours string, |
| s_manager string, |
| s_market_id int, |
| s_geography_class string, |
| s_market_desc string, |
| s_market_manager string, |
| s_division_id int, |
| s_division_name string, |
| s_company_id int, |
| s_company_name string, |
| s_street_number string, |
| s_street_name string, |
| s_street_type string, |
| s_suite_number string, |
| s_city string, |
| s_county string, |
| s_state string, |
| s_zip string, |
| s_country string, |
| s_gmt_offset float, |
| s_tax_precentage float |
| ) |
| row format delimited fields terminated by '|' |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@store_bigint |
| POSTHOOK: query: create table store_bigint |
| ( |
| s_store_sk bigint, |
| s_store_id string, |
| s_rec_start_date string, |
| s_rec_end_date string, |
| s_closed_date_sk int, |
| s_store_name string, |
| s_number_employees int, |
| s_floor_space int, |
| s_hours string, |
| s_manager string, |
| s_market_id int, |
| s_geography_class string, |
| s_market_desc string, |
| s_market_manager string, |
| s_division_id int, |
| s_division_name string, |
| s_company_id int, |
| s_company_name string, |
| s_street_number string, |
| s_street_name string, |
| s_street_type string, |
| s_suite_number string, |
| s_city string, |
| s_county string, |
| s_state string, |
| s_zip string, |
| s_country string, |
| s_gmt_offset float, |
| s_tax_precentage float |
| ) |
| row format delimited fields terminated by '|' |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@store_bigint |
| PREHOOK: query: create table customer_address |
| ( |
| ca_address_sk int, |
| ca_address_id string, |
| ca_street_number string, |
| ca_street_name string, |
| ca_street_type string, |
| ca_suite_number string, |
| ca_city string, |
| ca_county string, |
| ca_state string, |
| ca_zip string, |
| ca_country string, |
| ca_gmt_offset float, |
| ca_location_type string |
| ) |
| row format delimited fields terminated by '|' |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@customer_address |
| POSTHOOK: query: create table customer_address |
| ( |
| ca_address_sk int, |
| ca_address_id string, |
| ca_street_number string, |
| ca_street_name string, |
| ca_street_type string, |
| ca_suite_number string, |
| ca_city string, |
| ca_county string, |
| ca_state string, |
| ca_zip string, |
| ca_country string, |
| ca_gmt_offset float, |
| ca_location_type string |
| ) |
| row format delimited fields terminated by '|' |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@customer_address |
| PREHOOK: query: load data local inpath '../../data/files/store.txt' overwrite into table store_n0 |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@store_n0 |
| POSTHOOK: query: load data local inpath '../../data/files/store.txt' overwrite into table store_n0 |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@store_n0 |
| PREHOOK: query: load data local inpath '../../data/files/store.txt' overwrite into table store_bigint |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@store_bigint |
| POSTHOOK: query: load data local inpath '../../data/files/store.txt' overwrite into table store_bigint |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@store_bigint |
| PREHOOK: query: load data local inpath '../../data/files/store_sales.txt' overwrite into table store_sales_n0 |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@store_sales_n0 |
| POSTHOOK: query: load data local inpath '../../data/files/store_sales.txt' overwrite into table store_sales_n0 |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@store_sales_n0 |
| PREHOOK: query: load data local inpath '../../data/files/customer_address.txt' overwrite into table customer_address |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@customer_address |
| POSTHOOK: query: load data local inpath '../../data/files/customer_address.txt' overwrite into table customer_address |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@customer_address |
| PREHOOK: query: analyze table store_n0 compute statistics |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Output: default@store_n0 |
| POSTHOOK: query: analyze table store_n0 compute statistics |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Output: default@store_n0 |
| PREHOOK: query: analyze table store_n0 compute statistics for columns s_store_sk, s_floor_space |
| PREHOOK: type: ANALYZE_TABLE |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Output: default@store_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: analyze table store_n0 compute statistics for columns s_store_sk, s_floor_space |
| POSTHOOK: type: ANALYZE_TABLE |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Output: default@store_n0 |
| #### A masked pattern was here #### |
| PREHOOK: query: analyze table store_bigint compute statistics |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_bigint |
| PREHOOK: Output: default@store_bigint |
| POSTHOOK: query: analyze table store_bigint compute statistics |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_bigint |
| POSTHOOK: Output: default@store_bigint |
| PREHOOK: query: analyze table store_bigint compute statistics for columns s_store_sk, s_floor_space |
| PREHOOK: type: ANALYZE_TABLE |
| PREHOOK: Input: default@store_bigint |
| PREHOOK: Output: default@store_bigint |
| #### A masked pattern was here #### |
| POSTHOOK: query: analyze table store_bigint compute statistics for columns s_store_sk, s_floor_space |
| POSTHOOK: type: ANALYZE_TABLE |
| POSTHOOK: Input: default@store_bigint |
| POSTHOOK: Output: default@store_bigint |
| #### A masked pattern was here #### |
| PREHOOK: query: analyze table store_sales_n0 compute statistics |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_sales_n0 |
| PREHOOK: Output: default@store_sales_n0 |
| POSTHOOK: query: analyze table store_sales_n0 compute statistics |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_sales_n0 |
| POSTHOOK: Output: default@store_sales_n0 |
| PREHOOK: query: analyze table store_sales_n0 compute statistics for columns ss_store_sk, ss_addr_sk, ss_quantity |
| PREHOOK: type: ANALYZE_TABLE |
| PREHOOK: Input: default@store_sales_n0 |
| PREHOOK: Output: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: analyze table store_sales_n0 compute statistics for columns ss_store_sk, ss_addr_sk, ss_quantity |
| POSTHOOK: type: ANALYZE_TABLE |
| POSTHOOK: Input: default@store_sales_n0 |
| POSTHOOK: Output: default@store_sales_n0 |
| #### A masked pattern was here #### |
| PREHOOK: query: analyze table customer_address compute statistics |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@customer_address |
| PREHOOK: Output: default@customer_address |
| POSTHOOK: query: analyze table customer_address compute statistics |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@customer_address |
| POSTHOOK: Output: default@customer_address |
| PREHOOK: query: analyze table customer_address compute statistics for columns ca_address_sk |
| PREHOOK: type: ANALYZE_TABLE |
| PREHOOK: Input: default@customer_address |
| PREHOOK: Output: default@customer_address |
| #### A masked pattern was here #### |
| POSTHOOK: query: analyze table customer_address compute statistics for columns ca_address_sk |
| POSTHOOK: type: ANALYZE_TABLE |
| POSTHOOK: Input: default@customer_address |
| POSTHOOK: Output: default@customer_address |
| #### A masked pattern was here #### |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 3 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_bigint s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_bigint |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_bigint s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_bigint |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: bigint) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: bigint) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: bigint) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 3 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: UDFToLong(ss_store_sk) is not null (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: UDFToLong(ss_store_sk) is not null (type: boolean) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: UDFToLong(ss_store_sk) (type: bigint) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 7440 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: bigint) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: bigint) |
| Statistics: Num rows: 964 Data size: 7440 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: bigint) |
| 1 _col0 (type: bigint) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 7712 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 964 Data size: 7712 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: (s_store_sk > 0) (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (s_store_sk > 0) (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 3 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: (ss_store_sk > 0) (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (ss_store_sk > 0) (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1000 Data size: 4000 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1000 Data size: 4000 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_company_id > 0 and ss.ss_quantity > 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_company_id > 0 and ss.ss_quantity > 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: ((s_company_id > 0) and s_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: PARTIAL |
| Filter Operator |
| predicate: ((s_company_id > 0) and s_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: PARTIAL |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: PARTIAL |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: PARTIAL |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 3 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: ((ss_quantity > 10) and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 1000 Data size: 7676 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((ss_quantity > 10) and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 876 Data size: 6724 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 876 Data size: 3380 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 876 Data size: 3380 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: PARTIAL |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: PARTIAL |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: ((s_floor_space > 0) and s_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((s_floor_space > 0) and s_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 3 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 3 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: ((ss_quantity > 10) and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 1000 Data size: 7676 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((ss_quantity > 10) and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 876 Data size: 6724 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 876 Data size: 3380 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 876 Data size: 3380 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 876 Data size: 3504 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 876 Data size: 3504 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) |
| Reducer 3 <- Map 4 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 4 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 964 Data size: 7576 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 964 Data size: 7576 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: int) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col1 |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col1 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 1000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 1000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) |
| Reducer 3 <- Map 4 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: (ss_store_sk > 1000) (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (ss_store_sk > 1000) (type: boolean) |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 4 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: (s_store_sk > 1000) (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (s_store_sk > 1000) (type: boolean) |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: int) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col1 |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col1 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 1000 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 1000 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) |
| Reducer 3 <- Map 4 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 1000 Data size: 3860 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ss_store_sk is not null (type: boolean) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 964 Data size: 3720 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 4 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: (((s_floor_space > 1000) and s_store_sk is not null) or s_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((s_floor_space > 1000) and s_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 12 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 964 Data size: 7576 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 964 Data size: 7576 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: int) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col1 |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col1 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 964 Data size: 3856 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) |
| Reducer 3 <- Map 4 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: ((ss_quantity > 10) and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 1000 Data size: 7676 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((ss_quantity > 10) and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 876 Data size: 6724 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 876 Data size: 3380 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 876 Data size: 3380 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 4 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 876 Data size: 6884 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 876 Data size: 6884 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: int) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col1 |
| Statistics: Num rows: 876 Data size: 3504 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col1 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 876 Data size: 3504 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 876 Data size: 3504 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join customer_address ca on (ca.ca_address_sk = ss.ss_addr_sk) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@customer_address |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join customer_address ca on (ca.ca_address_sk = ss.ss_addr_sk) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@customer_address |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Input: default@store_sales_n0 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) |
| Reducer 3 <- Map 5 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: ss |
| filterExpr: (ss_addr_sk is not null and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 1000 Data size: 7664 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (ss_addr_sk is not null and ss_store_sk is not null) (type: boolean) |
| Statistics: Num rows: 916 Data size: 7020 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ss_addr_sk (type: int), ss_store_sk (type: int) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 916 Data size: 7020 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col1 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col1 (type: int) |
| Statistics: Num rows: 916 Data size: 7020 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: int) |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 4 |
| Map Operator Tree: |
| TableScan |
| alias: s |
| filterExpr: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: s_store_sk is not null (type: boolean) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: s_store_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 12 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 5 |
| Map Operator Tree: |
| TableScan |
| alias: ca |
| filterExpr: ca_address_sk is not null (type: boolean) |
| Statistics: Num rows: 20 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ca_address_sk is not null (type: boolean) |
| Statistics: Num rows: 20 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: ca_address_sk (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 20 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 20 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col1 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col2 |
| Statistics: Num rows: 916 Data size: 7148 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 916 Data size: 7148 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col2 (type: int) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col2 |
| Statistics: Num rows: 223 Data size: 892 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col2 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 223 Data size: 892 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 223 Data size: 892 Basic stats: COMPLETE Column stats: COMPLETE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: drop table store_sales_n0 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@store_sales_n0 |
| PREHOOK: Output: default@store_sales_n0 |
| POSTHOOK: query: drop table store_sales_n0 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@store_sales_n0 |
| POSTHOOK: Output: default@store_sales_n0 |
| PREHOOK: query: drop table store_n0 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@store_n0 |
| PREHOOK: Output: default@store_n0 |
| POSTHOOK: query: drop table store_n0 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@store_n0 |
| POSTHOOK: Output: default@store_n0 |
| PREHOOK: query: drop table store_bigint |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@store_bigint |
| PREHOOK: Output: default@store_bigint |
| POSTHOOK: query: drop table store_bigint |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@store_bigint |
| POSTHOOK: Output: default@store_bigint |
| PREHOOK: query: drop table customer_address |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@customer_address |
| PREHOOK: Output: default@customer_address |
| POSTHOOK: query: drop table customer_address |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@customer_address |
| POSTHOOK: Output: default@customer_address |