ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME portrait rec_feature_feedback a TOK_INSERT TOK_DESTINATION TOK_TAB TOK_TABNAME portrait test1 TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL iid TOK_SELEXPR TOK_TABLE_OR_COL feedback_15day TOK_SELEXPR TOK_TABLE_OR_COL feedback_7day TOK_SELEXPR TOK_TABLE_OR_COL feedback_5day TOK_SELEXPR TOK_TABLE_OR_COL feedback_3day TOK_SELEXPR TOK_TABLE_OR_COL feedback_1day TOK_WHERE and = TOK_TABLE_OR_COL l_date '2015-09-09' TOK_FUNCTION in TOK_TABLE_OR_COL bid '949722CF_12F7_523A_EE21_E3D591B7E755' TOK_INSERT TOK_DESTINATION TOK_TAB TOK_TABNAME portrait test2 TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL iid TOK_SELEXPR TOK_TABLE_OR_COL feedback_15day TOK_SELEXPR TOK_TABLE_OR_COL feedback_7day TOK_SELEXPR TOK_TABLE_OR_COL feedback_5day TOK_SELEXPR TOK_TABLE_OR_COL feedback_3day TOK_SELEXPR TOK_TABLE_OR_COL feedback_1day TOK_WHERE and = TOK_TABLE_OR_COL l_date '2015-09-09' TOK_FUNCTION in TOK_TABLE_OR_COL bid 'test' TOK_INSERT TOK_DESTINATION TOK_TAB TOK_TABNAME portrait test3 TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL iid TOK_SELEXPR TOK_TABLE_OR_COL feedback_15day TOK_SELEXPR TOK_TABLE_OR_COL feedback_7day TOK_SELEXPR TOK_TABLE_OR_COL feedback_5day TOK_SELEXPR TOK_TABLE_OR_COL feedback_3day TOK_SELEXPR TOK_TABLE_OR_COL feedback_1day TOK_WHERE and = TOK_TABLE_OR_COL l_date '2015-09-09' TOK_FUNCTION in TOK_TABLE_OR_COL bid 'F7734668_CC49_8C4F_24C5_EA8B6728E394' STAGE DEPENDENCIES: Stage-3 is a root stage Stage-9 depends on stages: Stage-3 , consists of Stage-6, Stage-5, Stage-7 Stage-6 Stage-0 depends on stages: Stage-6, Stage-5, Stage-8 Stage-4 depends on stages: Stage-0 Stage-5 Stage-7 Stage-8 depends on stages: Stage-7 Stage-15 depends on stages: Stage-3 , consists of Stage-12, Stage-11, Stage-13 Stage-12 Stage-1 depends on stages: Stage-12, Stage-11, Stage-14 Stage-10 depends on stages: Stage-1 Stage-11 Stage-13 Stage-14 depends on stages: Stage-13 Stage-21 depends on stages: Stage-3 , consists of Stage-18, Stage-17, Stage-19 Stage-18 Stage-2 depends on stages: Stage-18, Stage-17, Stage-20 Stage-16 depends on stages: Stage-2 Stage-17 Stage-19 Stage-20 depends on stages: Stage-19 STAGE PLANS: Stage: Stage-3 Map Reduce Map Operator Tree: TableScan alias: a Statistics: Num rows: 857 Data size: 102890 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: (bid) IN ('949722CF_12F7_523A_EE21_E3D591B7E755') (type: boolean) Statistics: Num rows: 428 Data size: 51384 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: iid (type: string), feedback_15day (type: int), feedback_7day (type: int), feedback_5day (type: int), feedback_3day (type: int), feedback_1day (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 428 Data size: 51384 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false GlobalTableId: 1 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 NumFilesPerFileSink: 1 Statistics: Num rows: 428 Data size: 51384 Basic stats: COMPLETE Column stats: NONE Stats Publishing Key Prefix: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10000/ table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test1 TotalFiles: 1 GatherStats: true MultiFileSpray: false Filter Operator isSamplingPred: false predicate: false (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: iid (type: string), feedback_15day (type: int), feedback_7day (type: int), feedback_5day (type: int), feedback_3day (type: int), feedback_1day (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false GlobalTableId: 2 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 NumFilesPerFileSink: 1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Stats Publishing Key Prefix: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10001/ table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test2 TotalFiles: 1 GatherStats: true MultiFileSpray: false Filter Operator isSamplingPred: false predicate: (bid) IN ('F7734668_CC49_8C4F_24C5_EA8B6728E394') (type: boolean) Statistics: Num rows: 428 Data size: 51384 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: iid (type: string), feedback_15day (type: int), feedback_7day (type: int), feedback_5day (type: int), feedback_3day (type: int), feedback_1day (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 428 Data size: 51384 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false GlobalTableId: 3 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 NumFilesPerFileSink: 1 Statistics: Num rows: 428 Data size: 51384 Basic stats: COMPLETE Column stats: NONE Stats Publishing Key Prefix: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10002/ table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test3 TotalFiles: 1 GatherStats: true MultiFileSpray: false Path -> Alias: -mr-10006portrait.rec_feature_feedback{l_date=2015-09-09, cid=Cyiyaowang, bid=F7734668_CC49_8C4F_24C5_EA8B6728E394} [a] -mr-10007portrait.rec_feature_feedback{l_date=2015-09-09, cid=Czgc_pc, bid=949722CF_12F7_523A_EE21_E3D591B7E755} [a] Path -> Partition: -mr-10006portrait.rec_feature_feedback{l_date=2015-09-09, cid=Cyiyaowang, bid=F7734668_CC49_8C4F_24C5_EA8B6728E394} Partition base file name: bid=F7734668_CC49_8C4F_24C5_EA8B6728E394 input format: org.apache.hadoop.hive.ql.io.OneNullRowInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: bid F7734668_CC49_8C4F_24C5_EA8B6728E394 cid Cyiyaowang l_date 2015-09-09 properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:int:int:int:int:int field.delim file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/rec_feature_feedback/l_date=2015-09-09/cid=Cyiyaowang/bid=F7734668_CC49_8C4F_24C5_EA8B6728E394 name portrait.rec_feature_feedback numFiles 27 numRows 0 partition_columns l_date/cid/bid partition_columns.types string:string:string rawDataSize 0 serialization.ddl struct rec_feature_feedback { string iid, i32 feedback_15day, i32 feedback_7day, i32 feedback_5day, i32 feedback_3day, i32 feedback_1day} serialization.format serialization.lib org.apache.hadoop.hive.serde2.NullStructSerDe totalSize 77792 transient_lastDdlTime 1442132192 serde: org.apache.hadoop.hive.serde2.NullStructSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:int:int:int:int:int field.delim file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/rec_feature_feedback name portrait.rec_feature_feedback partition_columns l_date/cid/bid partition_columns.types string:string:string serialization.ddl struct rec_feature_feedback { string iid, i32 feedback_15day, i32 feedback_7day, i32 feedback_5day, i32 feedback_3day, i32 feedback_1day} serialization.format serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1441102832 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.rec_feature_feedback name: portrait.rec_feature_feedback -mr-10007portrait.rec_feature_feedback{l_date=2015-09-09, cid=Czgc_pc, bid=949722CF_12F7_523A_EE21_E3D591B7E755} Partition base file name: bid=949722CF_12F7_523A_EE21_E3D591B7E755 input format: org.apache.hadoop.hive.ql.io.OneNullRowInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: bid 949722CF_12F7_523A_EE21_E3D591B7E755 cid Czgc_pc l_date 2015-09-09 properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:int:int:int:int:int field.delim file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/rec_feature_feedback/l_date=2015-09-09/cid=Czgc_pc/bid=949722CF_12F7_523A_EE21_E3D591B7E755 name portrait.rec_feature_feedback numFiles 27 numRows 0 partition_columns l_date/cid/bid partition_columns.types string:string:string rawDataSize 0 serialization.ddl struct rec_feature_feedback { string iid, i32 feedback_15day, i32 feedback_7day, i32 feedback_5day, i32 feedback_3day, i32 feedback_1day} serialization.format serialization.lib org.apache.hadoop.hive.serde2.NullStructSerDe totalSize 25098 transient_lastDdlTime 1442132192 serde: org.apache.hadoop.hive.serde2.NullStructSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:int:int:int:int:int field.delim file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/rec_feature_feedback name portrait.rec_feature_feedback partition_columns l_date/cid/bid partition_columns.types string:string:string serialization.ddl struct rec_feature_feedback { string iid, i32 feedback_15day, i32 feedback_7day, i32 feedback_5day, i32 feedback_3day, i32 feedback_1day} serialization.format serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe transient_lastDdlTime 1441102832 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.rec_feature_feedback name: portrait.rec_feature_feedback Truncated Path -> Alias: -mr-10006portrait.rec_feature_feedback{l_date=2015-09-09, cid=Cyiyaowang, bid=F7734668_CC49_8C4F_24C5_EA8B6728E394} [a] -mr-10007portrait.rec_feature_feedback{l_date=2015-09-09, cid=Czgc_pc, bid=949722CF_12F7_523A_EE21_E3D591B7E755} [a] Stage: Stage-9 Conditional Operator Stage: Stage-6 Move Operator files: hdfs directory: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 destination: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10000 Stage: Stage-0 Move Operator tables: replace: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10000 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test1 Stage: Stage-4 Stats-Aggr Operator Stats Aggregation Key Prefix: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10000/ Stage: Stage-5 Map Reduce Map Operator Tree: TableScan GatherStats: false File Output Operator compressed: false GlobalTableId: 0 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10000 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test1 TotalFiles: 1 GatherStats: false MultiFileSpray: false Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003] Path -> Partition: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 Partition base file name: -ext-10003 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test1 name: portrait.test1 Truncated Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003] Stage: Stage-7 Map Reduce Map Operator Tree: TableScan GatherStats: false File Output Operator compressed: false GlobalTableId: 0 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10000 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test1 TotalFiles: 1 GatherStats: false MultiFileSpray: false Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003] Path -> Partition: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 Partition base file name: -ext-10003 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test1 name portrait.test1 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test1 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test1 name: portrait.test1 Truncated Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003] Stage: Stage-8 Move Operator files: hdfs directory: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10003 destination: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10000 Stage: Stage-15 Conditional Operator Stage: Stage-12 Move Operator files: hdfs directory: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 destination: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10001 Stage: Stage-1 Move Operator tables: replace: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10001 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test2 Stage: Stage-10 Stats-Aggr Operator Stats Aggregation Key Prefix: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10001/ Stage: Stage-11 Map Reduce Map Operator Tree: TableScan GatherStats: false File Output Operator compressed: false GlobalTableId: 0 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10001 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test2 TotalFiles: 1 GatherStats: false MultiFileSpray: false Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004] Path -> Partition: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 Partition base file name: -ext-10004 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test2 name: portrait.test2 Truncated Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004] Stage: Stage-13 Map Reduce Map Operator Tree: TableScan GatherStats: false File Output Operator compressed: false GlobalTableId: 0 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10001 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test2 TotalFiles: 1 GatherStats: false MultiFileSpray: false Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004] Path -> Partition: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 Partition base file name: -ext-10004 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test2 name portrait.test2 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test2 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 0 transient_lastDdlTime 1442387132 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test2 name: portrait.test2 Truncated Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004] Stage: Stage-14 Move Operator files: hdfs directory: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10004 destination: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10001 Stage: Stage-21 Conditional Operator Stage: Stage-18 Move Operator files: hdfs directory: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 destination: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10002 Stage: Stage-2 Move Operator tables: replace: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10002 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test3 Stage: Stage-16 Stats-Aggr Operator Stats Aggregation Key Prefix: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10002/ Stage: Stage-17 Map Reduce Map Operator Tree: TableScan GatherStats: false File Output Operator compressed: false GlobalTableId: 0 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10002 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test3 TotalFiles: 1 GatherStats: false MultiFileSpray: false Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005] Path -> Partition: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 Partition base file name: -ext-10005 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test3 name: portrait.test3 Truncated Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005] Stage: Stage-19 Map Reduce Map Operator Tree: TableScan GatherStats: false File Output Operator compressed: false GlobalTableId: 0 directory: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10002 NumFilesPerFileSink: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test3 TotalFiles: 1 GatherStats: false MultiFileSpray: false Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005] Path -> Partition: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 Partition base file name: -ext-10005 input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns iid,feedback_15day,feedback_7day,feedback_5day,feedback_3day,feedback_1day columns.comments columns.types string:string:string:string:string:string file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat location hdfs://bfdhadoopcool/warehouse/portrait.db/test3 name portrait.test3 numFiles 1 numRows 0 rawDataSize 0 serialization.ddl struct test3 { string iid, string feedback_15day, string feedback_7day, string feedback_5day, string feedback_3day, string feedback_1day} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 18 transient_lastDdlTime 1442213479 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: portrait.test3 name: portrait.test3 Truncated Path -> Alias: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 [hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005] Stage: Stage-20 Move Operator files: hdfs directory: true source: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10005 destination: hdfs://bfdhadoopcool/tmp/hive/hadoop/cfe28e34-c592-44d0-a146-b50c8325bb0a/hive_2015-09-16_15-12-52_154_2798731420392613197-1/-ext-10002