Skip to content

Instantly share code, notes, and snippets.

@andypern

andypern/gist:af19ddcd0fb7174169e8

Created April 22, 2015 18:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andypern/af19ddcd0fb7174169e8 to your computer and use it in GitHub Desktop.
Save andypern/af19ddcd0fb7174169e8 to your computer and use it in GitHub Desktop.
Download ZIP
A019 sum()
Raw
gistfile1.txt
0: jdbc:drill:> explain plan for select prdct_id_val, sum(notional_amount_leg_1) from posA18 where r_date >= '2014-01-01' and r_date <= '2014-12-31' group by prdct_id_val order by prdct_id_val LIMIT 50;
+------------+------------+
| text | json |
+------------+------------+
| 00-00 Screen
00-01 Project(prdct_id_val=[$0], EXPR$1=[$1])
00-02 SelectionVectorRemover
00-03 Limit(fetch=[50])
00-04 SingleMergeExchange(sort0=[0 ASC])
01-01 SelectionVectorRemover
01-02 TopN(limit=[50])
01-03 HashAgg(group=[{0}], EXPR$1=[SUM($1)])
01-04 HashToRandomExchange(dist0=[[$0]])
02-01 HashAgg(group=[{0}], EXPR$1=[SUM($1)])
02-02 Project(prdct_id_val=[CAST($2):CHAR(200) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], notional_amount_leg_1=[CAST($1):DECIMAL(35, 10)])
02-03 SelectionVectorRemover
02-04 Filter(condition=[AND(>=($0, '2014-01-01'), <=($0, '2014-12-31'))])
02-05 Project(dir1=[$1], notional_amount_leg_1=[$2], prdct_id_val=[$0])
02-06 Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-03-26/214c279334946e65-7e32c56eed93cbc1_1051246080_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-04-02/214c279334946e65-7e32c56eed93cbc1_192659286_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-04-01/214c279334946e65-7e32c56eed93cbc2_371458216_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-06-21/894b9942f8411e85-7d163997afdf2587_940200931_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-07-29/214c279334946e65-7e32c56eed93cbc2_664248475_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-06-19/214c279334946e65-7e32c56eed93cbc0_2053035507_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-06-30/214c279334946e65-7e32c56eed93cbbf_1281606632_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-03-05/214c279334946e65-7e32c56eed93cbc0_1369385312_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-09-01/d4dab6bbcfb75d9-641cc2a57b756486_1553652051_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-06-20/214c279334946e65-7e32c56eed93cbc0_328577881_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-06-27/214c279334946e65-7e32c56eed93cbbf_753269315_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-03-31/214c279334946e65-7e32c56eed93cbc1_1467857798_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-04-03/214c279334946e65-7e32c56eed93cbc0_274342802_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-09-02/d940124da9265b62-db78d733b4e41a9d_1017833885_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-07-03/214c279334946e65-7e32c56eed93cbc2_37298498_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-07-15/214c279334946e65-7e32c56eed93cbbf_1237344643_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-06-26/214c279334946e65-7e32c56eed93cbc2_1847884103_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/GT06;WSB4/2014-03-27/214c279334946e65-7e32c56eed93cbc0_9210719_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-07-02/214c279334946e65-7e32c56eed93cbc0_1371477905_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-06-21/894b9942f8411e85-7d163997afdf2587_69864010_data.1.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-06-21/894b9942f8411e85-7d163997afdf2587_69864010_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-07-29/214c279334946e65-7e32c56eed93cbc1_680866327_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-06-19/214c279334946e65-7e32c56eed93cbc1_488271693_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-06-30/214c279334946e65-7e32c56eed93cbc2_452230455_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-09-01/d4dab6bbcfb75d9-641cc2a57b756486_1114217993_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-09-01/d4dab6bbcfb75d9-641cc2a57b756486_1114217993_data.1.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-06-20/214c279334946e65-7e32c56eed93cbc1_604208402_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-06-27/214c279334946e65-7e32c56eed93cbc2_35452641_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-09-02/d940124da9265b62-db78d733b4e41a9d_121272728_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-09-02/d940124da9265b62-db78d733b4e41a9d_121272728_data.1.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-07-03/214c279334946e65-7e32c56eed93cbc1_594862257_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-07-15/214c279334946e65-7e32c56eed93cbc0_37656589_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/TD06/2014-06-26/214c279334946e65-7e32c56eed93cbbf_956289869_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB52/2014-06-21/894b9942f8411e85-7d163997afdf2585_873498190_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB52/2014-06-30/214c279334946e65-7e32c56eed93cbc0_1914683943_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB52/2014-09-01/d4dab6bbcfb75d9-641cc2a57b756484_762992808_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB52/2014-06-27/214c279334946e65-7e32c56eed93cbc0_1098724507_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB52/2014-09-02/d940124da9265b62-db78d733b4e41a9b_1313631650_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB52/2014-07-03/214c279334946e65-7e32c56eed93cbbf_121420287_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB52/2014-07-15/214c279334946e65-7e32c56eed93cbc2_136444256_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-03-25/214c279334946e65-7e32c56eed93cbc0_1650113784_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-03-26/214c279334946e65-7e32c56eed93cbbf_1340747001_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-04-02/214c279334946e65-7e32c56eed93cbc2_1364839309_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-03-24/214c279334946e65-7e32c56eed93cbc1_750510284_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-04-01/214c279334946e65-7e32c56eed93cbc1_536235491_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-06-21/894b9942f8411e85-7d163997afdf2585_726763609_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-03-04/214c279334946e65-7e32c56eed93cbbf_942238716_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-03-05/214c279334946e65-7e32c56eed93cbc2_506292193_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-09-01/d4dab6bbcfb75d9-641cc2a57b756484_567483995_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-03-31/214c279334946e65-7e32c56eed93cbbf_615989837_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-04-03/214c279334946e65-7e32c56eed93cbbf_616726188_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-09-02/d940124da9265b62-db78d733b4e41a9b_220071911_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/PE10;PF10/2014-03-27/214c279334946e65-7e32c56eed93cbc2_278620626_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB23/2014-06-21/894b9942f8411e85-7d163997afdf2585_1824939453_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB23/2014-06-30/214c279334946e65-7e32c56eed93cbc2_1226007134_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB23/2014-09-01/d4dab6bbcfb75d9-641cc2a57b756484_366513003_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB23/2014-06-27/214c279334946e65-7e32c56eed93cbc2_820371902_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB23/2014-09-02/d940124da9265b62-db78d733b4e41a9b_1199732126_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB23/2014-07-03/214c279334946e65-7e32c56eed93cbc2_1965630551_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/CB23/2014-07-15/214c279334946e65-7e32c56eed93cbbf_115161432_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-03-25/214c279334946e65-7e32c56eed93cbc2_324676563_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-03-26/214c279334946e65-7e32c56eed93cbc1_1975946170_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-04-02/214c279334946e65-7e32c56eed93cbc2_2035552145_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-03-24/214c279334946e65-7e32c56eed93cbbf_941712586_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-04-01/214c279334946e65-7e32c56eed93cbc1_1237069829_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-06-21/894b9942f8411e85-7d163997afdf2587_1708712130_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-07-29/214c279334946e65-7e32c56eed93cbc2_354733156_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-06-30/214c279334946e65-7e32c56eed93cbbf_532030629_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-09-01/d4dab6bbcfb75d9-641cc2a57b756486_1274519202_data.0.parq], ReadEntryWithPath [path=maprfs:/data/tables/position/F122/2014-06-20/214c279334946e65-7e3 |
+------------+------------+
1 row selected (20.671 seconds)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment