hive> explain select * from tpcds_bin_partitioned_orc_10.customer, tpcds_bin_partitioned_orc_10.customer_demographics where c_current_cdemo_sk = cd_demo_sk limit 20; OK Vertex dependency in root stage Map 2 <- Map 1 (BROADCAST_EDGE) Stage-0 Fetch Operator limit:20 Stage-1 Map 2 vectorized, llap File Output Operator [FS_25] compressed:false Statistics:Num rows: 20 Data size: 7460 Basic stats: COMPLETE Column stats: NONE table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"} Limit [LIM_24] Number of rows:20 Statistics:Num rows: 20 Data size: 7460 Basic stats: COMPLETE Column stats: NONE Select Operator [OP_23] outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26"] Statistics:Num rows: 1056440 Data size: 394578053 Basic stats: COMPLETE Column stats: NONE Filter Operator [FIL_22] predicate:(_col2 = _col21) (type: boolean) Statistics:Num rows: 1056440 Data size: 394578053 Basic stats: COMPLETE Column stats: NONE Map Join Operator [MAPJOIN_21] | condition map:[{"":"Inner Join 0 to 1"}] | keys:{"Map 1":"c_current_cdemo_sk (type: int)","Map 2":"cd_demo_sk (type: int)"} | outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29"] | Statistics:Num rows: 2112880 Data size: 789156106 Basic stats: COMPLETE Column stats: NONE |<-Map 1 [BROADCAST_EDGE] vectorized, llap | Reduce Output Operator [RS_19] | key expressions:c_current_cdemo_sk (type: int) | Map-reduce partition columns:c_current_cdemo_sk (type: int) | sort order:+ | Statistics:Num rows: 500000 Data size: 430009964 Basic stats: COMPLETE Column stats: NONE | value expressions:c_customer_sk (type: int), c_customer_id (type: string), c_current_hdemo_sk (type: int), c_current_addr_sk (type: int), c_first_shipto_date_sk (type: int), c_first_sales_date_sk (type: int), c_salutation (type: string), c_first_name (type: string), c_last_name (type: string), c_preferred_cust_flag (type: string), c_birth_day (type: int), c_birth_month (type: int), c_birth_year (type: int), c_birth_country (type: string), c_login (type: string), c_email_address (type: string), c_last_review_date (type: string) | Filter Operator [FIL_18] | predicate:c_current_cdemo_sk is not null (type: boolean) | Statistics:Num rows: 500000 Data size: 430009964 Basic stats: COMPLETE Column stats: NONE | TableScan [TS_0] | alias:customer | Statistics:Num rows: 500000 Data size: 430009964 Basic stats: COMPLETE Column stats: NONE |<-Filter Operator [FIL_20] predicate:cd_demo_sk is not null (type: boolean) Statistics:Num rows: 1920800 Data size: 717414627 Basic stats: COMPLETE Column stats: NONE TableScan [TS_1] alias:customer_demographics Statistics:Num rows: 1920800 Data size: 717414627 Basic stats: COMPLETE Column stats: NONE Time taken: 0.112 seconds, Fetched: 46 row(s)