PREHOOK: query: -- SORT_BEFORE_DIFF -- union of constants, udf outputs, and columns from text table and thrift table explain SELECT key, count(1) FROM ( SELECT '1' as key from src UNION ALL SELECT reverse(key) as key from src UNION ALL SELECT key as key from src UNION ALL SELECT astring as key from src_thrift UNION ALL SELECT lstring[0] as key from src_thrift ) union_output GROUP BY key PREHOOK: type: QUERY POSTHOOK: query: -- SORT_BEFORE_DIFF -- union of constants, udf outputs, and columns from text table and thrift table explain SELECT key, count(1) FROM ( SELECT '1' as key from src UNION ALL SELECT reverse(key) as key from src UNION ALL SELECT key as key from src UNION ALL SELECT astring as key from src_thrift UNION ALL SELECT lstring[0] as key from src_thrift ) union_output GROUP BY key POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: src_thrift Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: astring (type: string) outputColumnNames: _col0 Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE Union Statistics: Num rows: 1522 Data size: 59264 Basic stats: COMPLETE Column stats: PARTIAL Group By Operator aggregations: count(1) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src_thrift Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: lstring[0] (type: string) outputColumnNames: _col0 Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE Union Statistics: Num rows: 1522 Data size: 59264 Basic stats: COMPLETE Column stats: PARTIAL Group By Operator aggregations: count(1) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Union Statistics: Num rows: 1522 Data size: 59264 Basic stats: COMPLETE Column stats: PARTIAL Group By Operator aggregations: count(1) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: '1' (type: string) outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 42500 Basic stats: COMPLETE Column stats: COMPLETE Union Statistics: Num rows: 1522 Data size: 59264 Basic stats: COMPLETE Column stats: PARTIAL Group By Operator aggregations: count(1) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: reverse(key) (type: string) outputColumnNames: _col0 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Union Statistics: Num rows: 1522 Data size: 59264 Basic stats: COMPLETE Column stats: PARTIAL Group By Operator aggregations: count(1) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false Statistics: Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: PARTIAL 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT key, count(1) FROM ( SELECT '1' as key from src UNION ALL SELECT reverse(key) as key from src UNION ALL SELECT key as key from src UNION ALL SELECT astring as key from src_thrift UNION ALL SELECT lstring[0] as key from src_thrift ) union_output GROUP BY key PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Input: default@src_thrift #### A masked pattern was here #### POSTHOOK: query: SELECT key, count(1) FROM ( SELECT '1' as key from src UNION ALL SELECT reverse(key) as key from src UNION ALL SELECT key as key from src UNION ALL SELECT astring as key from src_thrift UNION ALL SELECT lstring[0] as key from src_thrift ) union_output GROUP BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Input: default@src_thrift #### A masked pattern was here #### NULL 2 0 7 001 2 002 2 004 1 01 1 013 1 02 1 021 2 03 1 032 5 034 3 051 1 061 1 062 1 063 1 064 1 07 3 071 1 074 1 08 1 081 1 082 2 084 3 09 3 091 1 094 1 1 500 10 2 100 2 102 1 103 2 104 7 105 1 11 2 111 2 113 5 114 2 116 1 118 2 119 3 12 2 120 2 122 2 123 2 124 1 125 2 126 1 128 3 129 2 131 2 133 3 134 5 136 1 137 2 138 4 14 1 142 1 143 2 145 1 146 2 149 2 15 4 150 1 152 2 153 2 155 1 156 1 157 1 158 1 160 1 162 1 163 1 164 2 165 2 166 1 167 3 168 1 169 4 17 1 170 1 172 2 174 2 175 2 176 2 177 1 178 1 179 2 18 2 180 1 181 2 182 2 183 1 184 1 186 1 187 3 189 1 19 1 190 1 191 4 192 2 193 3 194 2 195 2 196 1 197 2 199 3 2 2 20 2 200 2 201 1 202 2 203 3 204 1 205 2 207 2 208 3 209 2 21 2 213 2 214 1 216 2 217 2 218 1 219 2 221 2 222 2 223 4 224 2 226 1 228 1 229 2 230 5 233 3 234 1 235 1 237 2 238 2 239 2 24 4 241 1 242 4 243 2 244 1 247 1 248 1 249 1 251 2 252 2 254 1 255 2 256 2 257 1 258 1 26 2 260 1 261 1 262 2 263 2 264 2 265 2 266 1 27 3 271 2 272 4 273 3 274 2 275 1 277 4 278 2 28 2 280 2 281 2 282 4 283 3 284 2 285 1 286 1 287 1 288 2 289 1 29 1 291 2 292 2 293 1 294 2 296 1 298 3 30 2 301 2 302 3 304 3 305 1 306 1 307 2 308 1 309 2 310 1 311 5 312 2 314 2 315 1 316 3 317 2 318 3 321 2 322 4 323 2 325 2 327 3 33 2 331 3 332 3 333 4 335 1 336 1 338 1 339 1 34 2 341 2 342 2 344 3 345 1 348 5 35 4 351 2 353 4 354 1 356 1 360 1 361 1 362 2 364 3 365 1 366 1 367 2 368 1 369 3 37 2 372 3 373 2 374 1 375 1 377 1 378 1 379 1 38 2 381 1 382 3 384 4 386 1 389 1 391 3 392 1 393 2 394 2 395 2 396 3 397 2 399 2 4 2 40 1 400 1 401 7 402 1 403 3 404 4 406 4 407 1 409 3 41 1 411 2 412 1 413 2 414 4 417 3 418 1 419 1 42 4 421 1 422 2 424 4 427 1 429 2 43 2 430 3 431 5 432 1 435 1 436 1 437 1 438 3 439 2 44 2 442 1 443 3 444 2 446 1 448 1 449 1 45 1 452 1 453 1 454 6 455 1 457 1 458 2 459 2 46 1 460 1 461 2 462 2 463 3 466 3 467 1 468 4 469 5 47 2 470 1 471 2 472 2 473 1 475 1 477 1 478 2 479 1 48 2 480 3 481 1 482 2 483 4 484 2 485 1 487 1 489 4 490 1 491 2 492 2 493 2 494 2 495 1 496 1 497 1 498 3 5 6 50 1 501 1 502 2 503 1 51 4 513 1 521 2 523 2 53 4 532 1 533 1 534 1 54 1 541 1 543 1 551 1 552 2 554 1 56 1 561 2 562 2 563 1 57 1 571 2 572 1 573 1 574 1 58 3 582 1 584 1 59 2 591 2 593 2 594 1 60 1 603 1 604 4 611 1 612 2 613 3 62 2 621 1 622 1 631 1 633 1 634 1 64 1 641 2 644 1 65 1 651 1 652 2 653 1 66 2 661 1 662 1 663 1 664 3 67 4 671 2 68 1 681 1 682 1 683 1 69 2 691 1 692 1 693 3 694 1 70 4 702 2 703 2 704 1 71 1 712 2 713 2 714 3 72 3 723 3 724 1 73 2 731 2 732 2 734 1 74 2 742 1 75 1 751 1 752 1 754 1 76 4 761 3 763 2 764 1 77 2 771 1 772 4 773 1 774 1 78 2 781 3 782 1 784 1 79 2 791 2 793 2 794 1 8 2 80 2 802 3 803 1 81 2 811 2 812 1 813 3 814 1 82 2 821 3 822 1 83 2 831 4 832 2 833 1 834 3 84 2 842 1 843 5 844 1 85 3 851 1 852 1 854 2 86 1 861 1 863 1 864 4 87 2 871 1 872 2 873 1 874 2 882 2 89 2 892 3 894 3 9 2 90 4 902 2 903 2 904 3 91 1 911 3 912 2 914 1 92 1 921 2 922 2 924 2 932 2 933 1 934 2 941 2 942 1 944 1 95 2 954 2 96 2 961 4 963 3 964 5 97 2 971 2 973 1 974 1 98 2 981 1 982 1 983 1 984 4 991 3 993 2 record_0 1 record_1 1 record_2 1 record_3 1 record_4 1 record_5 1 record_6 1 record_7 1 record_8 1 record_9 1