I0919 16:33:49.441161 2906 runtime-state.cc:228] Error from query 5e49fea470f61576:e9abd3f5640ba9b0: Memory Limit Exceeded Process: memory limit exceeded. Limit=11.73 GB Consumption=11.73 GB RequestPool=default-pool: Consumption=4.30 GB Query(ef45fd468f0ac4f9:36b0157ef252a497) Limit: Limit=123.00 MB Consumption=8.21 MB Fragment ef45fd468f0ac4f9:36b0157ef252a49c: Consumption=8.21 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=5.74 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=32.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(884799b6e8652403:2a4e97203a2538b1) Limit: Limit=123.00 MB Consumption=9.64 MB Fragment 884799b6e8652403:2a4e97203a2538b6: Consumption=9.64 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=7.13 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=68.30 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(28419298382a0f1e:fb9cc0284b5c15a0) Limit: Limit=123.00 MB Consumption=9.68 MB Fragment 28419298382a0f1e:fb9cc0284b5c15a5: Consumption=9.68 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=7.21 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=32.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(814b5e413f683a2f:cb05dca7790064b2) Limit: Limit=123.00 MB Consumption=14.20 MB Fragment 814b5e413f683a2f:cb05dca7790064b7: Consumption=14.20 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=11.71 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=42.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(a741c768b6bcbcc9:930292b788b49181) Limit: Limit=123.00 MB Consumption=13.73 MB Fragment a741c768b6bcbcc9:930292b788b49186: Consumption=13.73 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=11.26 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=32.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(2d4f612ebbe542d0:518eaf98786ad38c) Limit: Limit=143.00 MB Consumption=69.65 MB Fragment 2d4f612ebbe542d0:518eaf98786ad38d: Consumption=4.00 KB SORT_NODE (id=27): Consumption=0 NESTED_LOOP_JOIN_NODE (id=26): Consumption=0 AGGREGATION_NODE (id=35): Consumption=4.00 KB EXCHANGE_NODE (id=34): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=43): Consumption=0 DataStreamRecvr: Consumption=0 Block Manager: Limit=43.00 MB Consumption=18.26 MB Fragment 2d4f612ebbe542d0:518eaf98786ad38e: Consumption=4.00 KB AGGREGATION_NODE (id=42): Consumption=4.00 KB EXCHANGE_NODE (id=41): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 2d4f612ebbe542d0:518eaf98786ad392: Consumption=41.02 MB AGGREGATION_NODE (id=25): Consumption=4.00 KB HASH_JOIN_NODE (id=24): Consumption=641.02 KB HASH_JOIN_NODE (id=23): Consumption=8.97 MB HASH_JOIN_NODE (id=22): Consumption=19.31 MB HASH_JOIN_NODE (id=21): Consumption=11.05 MB HASH_JOIN_NODE (id=20): Consumption=1.00 MB HDFS_SCAN_NODE (id=14): Consumption=52.00 KB EXCHANGE_NODE (id=36): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=37): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=38): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=39): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=40): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 2d4f612ebbe542d0:518eaf98786ad39b: Consumption=28.62 MB AGGREGATION_NODE (id=13): Consumption=4.00 KB HASH_JOIN_NODE (id=12): Consumption=641.02 KB HASH_JOIN_NODE (id=11): Consumption=3.00 MB HASH_JOIN_NODE (id=10): Consumption=18.00 MB HASH_JOIN_NODE (id=9): Consumption=3.71 MB HASH_JOIN_NODE (id=8): Consumption=1.22 MB HASH_JOIN_NODE (id=7): Consumption=2.01 MB HDFS_SCAN_NODE (id=0): Consumption=52.00 KB EXCHANGE_NODE (id=28): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=29): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=30): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=31): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=32): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=33): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(1f478ebed3cd17e3:2abf764fd31fc5aa) Limit: Limit=215.00 MB Consumption=43.03 MB Fragment 1f478ebed3cd17e3:2abf764fd31fc5af: Consumption=4.00 KB SORT_NODE (id=17): Consumption=4.00 KB HASH_JOIN_NODE (id=16): Consumption=0 EXCHANGE_NODE (id=28): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=29): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=115.00 MB Consumption=5.52 MB Fragment 1f478ebed3cd17e3:2abf764fd31fc5b3: Consumption=5.89 MB HASH_JOIN_NODE (id=15): Consumption=641.02 KB HASH_JOIN_NODE (id=14): Consumption=2.01 MB AGGREGATION_NODE (id=25): Consumption=3.26 MB EXCHANGE_NODE (id=24): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=26): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=27): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 1f478ebed3cd17e3:2abf764fd31fc5b9: Consumption=15.63 MB AGGREGATION_NODE (id=11): Consumption=3.58 MB Exprs: Consumption=28.00 KB HASH_JOIN_NODE (id=10): Consumption=12.00 MB HDFS_SCAN_NODE (id=8): Consumption=45.00 KB EXCHANGE_NODE (id=23): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 1f478ebed3cd17e3:2abf764fd31fc5be: Consumption=5.89 MB HASH_JOIN_NODE (id=7): Consumption=641.02 KB HASH_JOIN_NODE (id=6): Consumption=2.01 MB AGGREGATION_NODE (id=20): Consumption=3.25 MB EXCHANGE_NODE (id=19): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=21): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=22): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 1f478ebed3cd17e3:2abf764fd31fc5c4: Consumption=15.62 MB AGGREGATION_NODE (id=3): Consumption=3.59 MB Exprs: Consumption=28.00 KB HASH_JOIN_NODE (id=2): Consumption=12.00 MB HDFS_SCAN_NODE (id=0): Consumption=28.00 KB EXCHANGE_NODE (id=18): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(f348b0ef00881d40:33f506c016a7b487) Limit: Limit=205.00 MB Consumption=75.96 MB Fragment f348b0ef00881d40:33f506c016a7b488: Consumption=0 EXCHANGE_NODE (id=30): Consumption=0 DataStreamRecvr: Consumption=0 Block Manager: Limit=105.00 MB Consumption=31.25 MB Fragment f348b0ef00881d40:33f506c016a7b490: Consumption=59.96 MB AGGREGATION_NODE (id=15): Consumption=3.25 MB HASH_JOIN_NODE (id=14): Consumption=1.16 MB HASH_JOIN_NODE (id=13): Consumption=160.02 KB HASH_JOIN_NODE (id=12): Consumption=12.11 MB HASH_JOIN_NODE (id=11): Consumption=14.03 MB HASH_JOIN_NODE (id=10): Consumption=18.09 MB HASH_JOIN_NODE (id=9): Consumption=11.03 MB HDFS_SCAN_NODE (id=2): Consumption=139.65 KB EXCHANGE_NODE (id=17): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=18): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=19): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=20): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=24): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=27): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(33453674d45cc998:596aa5ac00974cb7) Limit: Limit=123.00 MB Consumption=10.65 MB Fragment 33453674d45cc998:596aa5ac00974cbc: Consumption=10.65 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=8.16 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=48.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(124eb5958e6c7421:848f0c82f33e29a3) Limit: Limit=419.00 MB Consumption=314.21 MB Fragment 124eb5958e6c7421:848f0c82f33e29a7: Consumption=163.26 MB SORT_NODE (id=14): Consumption=4.00 KB HASH_JOIN_NODE (id=13): Consumption=14.00 MB HASH_JOIN_NODE (id=12): Consumption=146.00 MB AGGREGATION_NODE (id=20): Consumption=3.26 MB EXCHANGE_NODE (id=19): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=21): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=22): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=319.00 MB Consumption=272.82 MB Fragment 124eb5958e6c7421:848f0c82f33e29ad: Consumption=22.95 MB AGGREGATION_NODE (id=9): Consumption=3.73 MB HASH_JOIN_NODE (id=8): Consumption=752.62 KB HASH_JOIN_NODE (id=7): Consumption=14.12 MB HASH_JOIN_NODE (id=6): Consumption=2.28 MB HASH_JOIN_NODE (id=5): Consumption=2.01 MB HDFS_SCAN_NODE (id=0): Consumption=78.00 KB EXCHANGE_NODE (id=15): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=16): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=17): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=18): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(7441e7c2fb813e0e:a10b1cdccc3d0f85) Limit: Limit=158.00 MB Consumption=24.65 MB Fragment 7441e7c2fb813e0e:a10b1cdccc3d0f8a: Consumption=3.26 MB SORT_NODE (id=11): Consumption=4.00 KB SELECT_NODE (id=10): Consumption=4.00 KB Exprs: Consumption=4.00 KB ANALYTIC_EVAL_NODE (id=9): Consumption=0 SORT_NODE (id=8): Consumption=0 AGGREGATION_NODE (id=16): Consumption=3.25 MB EXCHANGE_NODE (id=15): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=58.00 MB Consumption=589.02 KB Fragment 7441e7c2fb813e0e:a10b1cdccc3d0f8e: Consumption=21.39 MB AGGREGATION_NODE (id=7): Consumption=3.25 MB HASH_JOIN_NODE (id=6): Consumption=641.02 KB HASH_JOIN_NODE (id=5): Consumption=15.42 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=1): Consumption=36.00 KB EXCHANGE_NODE (id=12): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=13): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=14): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(a742e0ea37d6a896:82203e52d0ff64ae) Limit: Limit=123.00 MB Consumption=10.96 MB Fragment a742e0ea37d6a896:82203e52d0ff64b3: Consumption=10.96 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=8.49 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=32.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(3a46fbbfdc8b27b0:c087adb80a2fefae) Limit: Limit=140.00 MB Consumption=4.00 KB Fragment 3a46fbbfdc8b27b0:c087adb80a2fefaf: Consumption=4.00 KB NESTED_LOOP_JOIN_NODE (id=70): Consumption=0 NESTED_LOOP_JOIN_NODE (id=69): Consumption=0 NESTED_LOOP_JOIN_NODE (id=68): Consumption=0 NESTED_LOOP_JOIN_NODE (id=67): Consumption=0 NESTED_LOOP_JOIN_NODE (id=66): Consumption=0 NESTED_LOOP_JOIN_NODE (id=65): Consumption=0 NESTED_LOOP_JOIN_NODE (id=64): Consumption=0 AGGREGATION_NODE (id=75): Consumption=4.00 KB EXCHANGE_NODE (id=74): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=81): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=87): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=93): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=99): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=105): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=111): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=117): Consumption=0 DataStreamRecvr: Consumption=0 Block Manager: Limit=40.00 MB Consumption=0 Query(9844a879bb7dc044:4221e24a118720aa) Limit: Limit=123.00 MB Consumption=10.80 MB Fragment 9844a879bb7dc044:4221e24a118720af: Consumption=10.80 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=8.29 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=68.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(64e8de25ae6ba27:bcecaba31d5349a0) Limit: Limit=215.00 MB Consumption=43.01 MB Fragment 64e8de25ae6ba27:bcecaba31d5349a1: Consumption=0 EXCHANGE_NODE (id=30): Consumption=0 DataStreamRecvr: Consumption=0 Block Manager: Limit=115.00 MB Consumption=5.52 MB Fragment 64e8de25ae6ba27:bcecaba31d5349a5: Consumption=4.00 KB SORT_NODE (id=17): Consumption=4.00 KB HASH_JOIN_NODE (id=16): Consumption=0 EXCHANGE_NODE (id=28): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=29): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 64e8de25ae6ba27:bcecaba31d5349a9: Consumption=5.89 MB HASH_JOIN_NODE (id=15): Consumption=641.02 KB HASH_JOIN_NODE (id=14): Consumption=2.01 MB AGGREGATION_NODE (id=25): Consumption=3.25 MB EXCHANGE_NODE (id=24): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=26): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=27): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 64e8de25ae6ba27:bcecaba31d5349af: Consumption=15.62 MB AGGREGATION_NODE (id=11): Consumption=3.59 MB Exprs: Consumption=28.00 KB HASH_JOIN_NODE (id=10): Consumption=12.00 MB HDFS_SCAN_NODE (id=8): Consumption=28.00 KB EXCHANGE_NODE (id=23): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 64e8de25ae6ba27:bcecaba31d5349b4: Consumption=5.89 MB HASH_JOIN_NODE (id=7): Consumption=641.02 KB HASH_JOIN_NODE (id=6): Consumption=2.01 MB AGGREGATION_NODE (id=20): Consumption=3.25 MB EXCHANGE_NODE (id=19): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=21): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=22): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 64e8de25ae6ba27:bcecaba31d5349ba: Consumption=15.61 MB AGGREGATION_NODE (id=3): Consumption=3.58 MB Exprs: Consumption=28.00 KB HASH_JOIN_NODE (id=2): Consumption=12.00 MB HDFS_SCAN_NODE (id=0): Consumption=28.00 KB EXCHANGE_NODE (id=18): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(d1410da77aa38474:9ffc1894de865fb2) Limit: Limit=143.00 MB Consumption=63.90 MB Fragment d1410da77aa38474:9ffc1894de865fb3: Consumption=4.00 KB SORT_NODE (id=27): Consumption=0 NESTED_LOOP_JOIN_NODE (id=26): Consumption=0 AGGREGATION_NODE (id=35): Consumption=4.00 KB EXCHANGE_NODE (id=34): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=43): Consumption=0 DataStreamRecvr: Consumption=0 Block Manager: Limit=43.00 MB Consumption=18.26 MB Fragment d1410da77aa38474:9ffc1894de865fb4: Consumption=4.00 KB AGGREGATION_NODE (id=42): Consumption=4.00 KB EXCHANGE_NODE (id=41): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment d1410da77aa38474:9ffc1894de865fb8: Consumption=32.33 MB AGGREGATION_NODE (id=25): Consumption=4.00 KB HASH_JOIN_NODE (id=24): Consumption=641.02 KB HASH_JOIN_NODE (id=23): Consumption=3.00 MB HASH_JOIN_NODE (id=22): Consumption=21.14 MB HASH_JOIN_NODE (id=21): Consumption=6.49 MB HASH_JOIN_NODE (id=20): Consumption=1.00 MB HDFS_SCAN_NODE (id=14): Consumption=73.16 KB EXCHANGE_NODE (id=36): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=37): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=38): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=39): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=40): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment d1410da77aa38474:9ffc1894de865fc1: Consumption=31.56 MB AGGREGATION_NODE (id=13): Consumption=4.00 KB HASH_JOIN_NODE (id=12): Consumption=641.02 KB HASH_JOIN_NODE (id=11): Consumption=3.00 MB HASH_JOIN_NODE (id=10): Consumption=18.00 MB HASH_JOIN_NODE (id=9): Consumption=6.37 MB HASH_JOIN_NODE (id=8): Consumption=1.43 MB HASH_JOIN_NODE (id=7): Consumption=2.01 MB HDFS_SCAN_NODE (id=0): Consumption=121.84 KB EXCHANGE_NODE (id=28): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=29): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=30): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=31): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=32): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=33): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(764a8313d76fabe7:660c36d917d78eb8) Limit: Limit=140.00 MB Consumption=35.70 MB Fragment 764a8313d76fabe7:660c36d917d78ebe: Consumption=8.68 MB AGGREGATION_NODE (id=63): Consumption=4.00 KB HASH_JOIN_NODE (id=62): Consumption=2.69 MB HASH_JOIN_NODE (id=61): Consumption=3.85 MB HASH_JOIN_NODE (id=60): Consumption=2.06 MB HDFS_SCAN_NODE (id=56): Consumption=74.40 KB EXCHANGE_NODE (id=112): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=113): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=114): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=40.00 MB Consumption=704.28 KB Fragment 764a8313d76fabe7:660c36d917d78ec6: Consumption=5.71 MB AGGREGATION_NODE (id=55): Consumption=4.00 KB HASH_JOIN_NODE (id=54): Consumption=384.05 KB HASH_JOIN_NODE (id=53): Consumption=3.27 MB HASH_JOIN_NODE (id=52): Consumption=2.06 MB HDFS_SCAN_NODE (id=48): Consumption=0 EXCHANGE_NODE (id=106): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=107): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=108): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 764a8313d76fabe7:660c36d917d78ece: Consumption=6.75 MB AGGREGATION_NODE (id=47): Consumption=4.00 KB HASH_JOIN_NODE (id=46): Consumption=384.05 KB HASH_JOIN_NODE (id=45): Consumption=4.27 MB HASH_JOIN_NODE (id=44): Consumption=2.06 MB HDFS_SCAN_NODE (id=40): Consumption=48.00 KB EXCHANGE_NODE (id=100): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=101): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=102): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 764a8313d76fabe7:660c36d917d78ed6: Consumption=6.66 MB AGGREGATION_NODE (id=39): Consumption=4.00 KB HASH_JOIN_NODE (id=38): Consumption=384.05 KB HASH_JOIN_NODE (id=37): Consumption=4.18 MB HASH_JOIN_NODE (id=36): Consumption=2.06 MB HDFS_SCAN_NODE (id=32): Consumption=32.00 KB EXCHANGE_NODE (id=94): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=95): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=96): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 764a8313d76fabe7:660c36d917d78ede: Consumption=5.45 MB AGGREGATION_NODE (id=31): Consumption=4.00 KB HASH_JOIN_NODE (id=30): Consumption=384.05 KB HASH_JOIN_NODE (id=29): Consumption=2.94 MB HASH_JOIN_NODE (id=28): Consumption=2.06 MB HDFS_SCAN_NODE (id=24): Consumption=68.00 KB EXCHANGE_NODE (id=88): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=89): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=90): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 764a8313d76fabe7:660c36d917d78ee6: Consumption=2.44 MB AGGREGATION_NODE (id=23): Consumption=4.00 KB HASH_JOIN_NODE (id=22): Consumption=384.05 KB HASH_JOIN_NODE (id=21): Consumption=2.06 MB HASH_JOIN_NODE (id=20): Consumption=0 HDFS_SCAN_NODE (id=16): Consumption=0 EXCHANGE_NODE (id=82): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=83): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=84): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(16493799f9268ddc:dbdfbef2c90822b6) Limit: Limit=123.00 MB Consumption=8.05 MB Fragment 16493799f9268ddc:dbdfbef2c90822bb: Consumption=8.05 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=5.58 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=32.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Query(545319206c969ff:8a3d33759dff7c8e) Limit: Limit=123.00 MB Consumption=7.54 MB Fragment 545319206c969ff:8a3d33759dff7c8f: Consumption=4.00 KB AGGREGATION_NODE (id=12): Consumption=4.00 KB EXCHANGE_NODE (id=11): Consumption=0 DataStreamRecvr: Consumption=0 Block Manager: Limit=23.00 MB Consumption=92.05 KB Fragment 545319206c969ff:8a3d33759dff7c93: Consumption=7.54 MB AGGREGATION_NODE (id=7): Consumption=4.00 KB HASH_JOIN_NODE (id=6): Consumption=384.05 KB HASH_JOIN_NODE (id=5): Consumption=5.06 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=0): Consumption=32.00 KB EXCHANGE_NODE (id=8): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=9): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=10): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(134eb022f734750d:312e1d31aa03791) Limit: Limit=205.00 MB Consumption=13.06 MB Fragment 134eb022f734750d:312e1d31aa03792: Consumption=0 EXCHANGE_NODE (id=17): Consumption=0 DataStreamRecvr: Consumption=0 Block Manager: Limit=105.00 MB Consumption=865.02 KB Fragment 134eb022f734750d:312e1d31aa03795: Consumption=3.28 MB SORT_NODE (id=11): Consumption=4.00 KB SELECT_NODE (id=10): Consumption=4.00 KB Exprs: Consumption=4.00 KB ANALYTIC_EVAL_NODE (id=9): Consumption=0 SORT_NODE (id=8): Consumption=0 AGGREGATION_NODE (id=16): Consumption=3.27 MB EXCHANGE_NODE (id=15): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Fragment 134eb022f734750d:312e1d31aa03799: Consumption=9.78 MB AGGREGATION_NODE (id=7): Consumption=3.99 MB HASH_JOIN_NODE (id=6): Consumption=1.11 MB HASH_JOIN_NODE (id=5): Consumption=2.43 MB HASH_JOIN_NODE (id=4): Consumption=2.08 MB HDFS_SCAN_NODE (id=1): Consumption=172.09 KB EXCHANGE_NODE (id=12): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=13): Consumption=0 DataStreamRecvr: Consumption=0 EXCHANGE_NODE (id=14): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Query(eb447753283dc00a:11433c5473d6bd9b) Limit: Limit=158.00 MB Consumption=19.37 MB Fragment eb447753283dc00a:11433c5473d6bda0: Consumption=3.26 MB SORT_NODE (id=11): Consumption=4.00 KB SELECT_NODE (id=10): Consumption=4.00 KB Exprs: Consumption=4.00 KB ANALYTIC_EVAL_NODE (id=9): Consumption=0 SORT_NODE (id=8): Consumption=0 AGGREGATION_NODE (id=16): Consumption=3.25 MB EXCHANGE_NODE (id=15): Consumption=0 DataStreamRecvr: Consumption=0 DataStreamSender: Consumption=0 Block Manager: Limit=58.00 MB Consumption=589.02 KB Fragment eb447753283dc00a:11433c5473d6bda4: Consumption=16.11 MB AGGREGATION_NODE (id=7): Consumption=3.25 MB HASH_JOIN_NODE (id=6): Consumption=641.02 KB HASH_JOIN_NODE (id=5): Consumption=10.08 MB HASH_JOIN_NODE (id=4): Consumption=2.06 MB HDFS_SCAN_NODE (id=1): Consumption=93.84 KB EXCHANGE_NODE (id=12): Consumption=0 I0919 16:33:49.495591 3974 plan-fragment-executor.cc:303] Open(): instance_id=884709f65fddf584:66906f39a1b22386