[
https://issues.apache.org/jira/browse/DRILL-1308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14104715#comment-14104715
]
Abhishek Girish commented on DRILL-1308:
----------------------------------------
Similar issue with TPCDS - Query 46 (From Impala-TPCDS-Kit)
Error: exception while executing query: Failure while trying to get next result
batch. (state=,code=0)
Query failed: Failure while parsing sql. Node
[rel#54397:Subset#23.LOGICAL.ANY([]).[0, 1, 2, 3, 4]] could not be implemented;
planner state:
Root: rel#54397:Subset#23.LOGICAL.ANY([]).[0, 1, 2, 3, 4]
Original rel:
AbstractConverter(subset=[rel#54397:Subset#23.LOGICAL.ANY([]).[0, 1, 2, 3, 4]],
convention=[LOGICAL], DrillDistributionTraitDef=[ANY([])], sort=[[0, 1, 2, 3,
4]]): rowcount = 1.7976931348623157E308, cumulative cost = {inf}, id = 54398
SortRel(subset=[rel#54396:Subset#23.NONE.ANY([]).[0, 1, 2, 3, 4]],
sort0=[$0], sort1=[$1], sort2=[$2], sort3=[$3], sort4=[$4], dir0=[ASC],
dir1=[ASC], dir2=[ASC], dir3=[ASC], dir4=[ASC], fetch=[100]): rowcount =
1.7976931348623157E308, cumulative cost = {Infinity rows,
1.7976931348623157E308 cpu, 0.0 io, 0.0 network}, id = 54395
ProjectRel(subset=[rel#54394:Subset#22.NONE.ANY([]).[]], c_last_name=[$8],
c_first_name=[$9], ca_city=[$11], bought_city=[$2], sstn=[$0], amt=[$3],
profit=[$4]): rowcount = 1.7976931348623157E308, cumulative cost =
{1.7976931348623157E308 rows, Infinity cpu, 0.0 io, 0.0 network}, id = 54393
FilterRel(subset=[rel#54392:Subset#21.NONE.ANY([]).[]],
condition=[AND(=($1, $7), =($6, $12), <>($11, $2))]): rowcount =
2.022404776720105E306, cumulative cost = {2.022404776720105E306 rows,
1.7976931348623157E308 cpu, 0.0 io, 0.0 network}, id = 54391
JoinRel(subset=[rel#54390:Subset#20.NONE.ANY([]).[]], condition=[true],
joinType=[inner]): rowcount = 1.7976931348623157E308, cumulative cost =
{1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 54389
JoinRel(subset=[rel#54388:Subset#19.NONE.ANY([]).[]],
condition=[true], joinType=[inner]): rowcount = 1.7976931348623157E308,
cumulative cost = {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network},
id = 54387
ProjectRel(subset=[rel#54385:Subset#17.NONE.ANY([]).[]], sstn=[$0],
sscsk=[$1], bought_city=[$3], amt=[$4], profit=[$5]): rowcount =
1.7976931348623157E308, cumulative cost = {1.7976931348623157E308 rows,
Infinity cpu, 0.0 io, 0.0 network}, id = 54384
AggregateRel(subset=[rel#54383:Subset#16.NONE.ANY([]).[]],
group=[{0, 1, 2, 3}], amt=[SUM($4)], profit=[SUM($5)]): rowcount =
1.7976931348623158E307, cumulative cost = {1.7976931348623158E307 rows, 0.0
cpu, 0.0 io, 0.0 network}, id = 54382
ProjectRel(subset=[rel#54381:Subset#15.NONE.ANY([]).[]],
sstn=[$1], sscsk=[$2], $f3=[$3], bought_city=[$21], $f7=[$7], $f8=[$8]):
rowcount = 1.7976931348623157E308, cumulative cost = {1.7976931348623157E308
rows, Infinity cpu, 0.0 io, 0.0 network}, id = 54380
FilterRel(subset=[rel#54379:Subset#14.NONE.ANY([]).[]],
condition=[AND(=($4, $12), =($5, $15), =($6, $19), =($3, $22),
OR(=(CAST($17):INTEGER, 5), =(CAST($18):INTEGER, 3)), OR(=($10, 6), =($10, 0)),
OR(=($11, 1999), =($11, +(1999, 1)), =($11, +(1999, 2))), OR(=($14, 'Midway'),
=($14, 'Concord'), =($14, 'Spring Hill'), =($14, 'Brownsville'), =($14,
'Greenville')), IS TRUE($25))]): rowcount = 8.887520991445773E301, cumulative
cost = {8.887520991445773E301 rows, 1.7976931348623157E308 cpu, 0.0 io, 0.0
network}, id = 54378
JoinRel(subset=[rel#54377:Subset#13.NONE.ANY([]).[]],
condition=[=($23, $24)], joinType=[left]): rowcount = 1.7976931348623157E308,
cumulative cost = {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network},
id = 54376
ProjectRel(subset=[rel#54370:Subset#9.NONE.ANY([]).[]],
$f0=[$0], $f1=[$1], $f2=[$2], $f3=[$3], $f4=[$4], $f5=[$5], $f6=[$6], $f7=[$7],
$f8=[$8], $f9=[$9], $f10=[$10], $f11=[$11], $f12=[$12], $f13=[$13], $f14=[$14],
$f15=[$15], $f16=[$16], $f17=[$17], $f18=[$18], $f19=[$19], $f20=[$20],
$f21=[$21], $f22=[$22], $f23=[$4]): rowcount = 1.7976931348623157E308,
cumulative cost = {1.7976931348623157E308 rows, Infinity cpu, 0.0 io, 0.0
network}, id = 54369
JoinRel(subset=[rel#54368:Subset#8.NONE.ANY([]).[]],
condition=[true], joinType=[inner]): rowcount = 1.7976931348623157E308,
cumulative cost = {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network},
id = 54367
JoinRel(subset=[rel#54365:Subset#6.NONE.ANY([]).[]],
condition=[true], joinType=[inner]): rowcount = 1.7976931348623157E308,
cumulative cost = {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network},
id = 54364
JoinRel(subset=[rel#54362:Subset#4.NONE.ANY([]).[]], condition=[true],
joinType=[inner]): rowcount = 1.7976931348623157E308, cumulative cost =
{1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 54361
JoinRel(subset=[rel#54359:Subset#2.NONE.ANY([]).[]], condition=[true],
joinType=[inner]): rowcount = 10000.0, cumulative cost = {10000.0 rows, 0.0
cpu, 0.0 io, 0.0 network}, id = 54358
EnumerableTableAccessRel(subset=[rel#54356:Subset#0.ENUMERABLE.ANY([]).[]],
table=[[dfs, tmp, store_sales]]): rowcount = 100.0, cumulative cost = {100.0
rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 54331
EnumerableTableAccessRel(subset=[rel#54357:Subset#1.ENUMERABLE.ANY([]).[]],
table=[[dfs, tmp, date_dim]]): rowcount = 100.0, cumulative cost = {100.0 rows,
101.0 cpu, 0.0 io, 0.0 network}, id = 54332
EnumerableTableAccessRel(subset=[rel#54360:Subset#3.ENUMERABLE.ANY([]).[]],
table=[[dfs, tmp, store]]): rowcount = 100.0, cumulative cost = {100.0 rows,
101.0 cpu, 0.0 io, 0.0 network}, id = 54334
EnumerableTableAccessRel(subset=[rel#54363:Subset#5.ENUMERABLE.ANY([]).[]],
table=[[dfs, tmp, household_demographics]]): rowcount = 100.0, cumulative cost
= {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 54336
EnumerableTableAccessRel(subset=[rel#54366:Subset#7.ENUMERABLE.ANY([]).[]],
table=[[dfs, tmp, customer_address]]): rowcount = 100.0, cumulative cost =
{100.0 rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 54338
AggregateRel(subset=[rel#54375:Subset#12.NONE.ANY([]).[]], group=[{0}],
agg#0=[MIN($1)]): rowcount = 1.7976931348623158E307, cumulative cost =
{1.7976931348623158E307 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 54374
ProjectRel(subset=[rel#54373:Subset#11.NONE.ANY([]).[]], $f0=[$0], $f1=[true]):
rowcount = 1.7976931348623157E308, cumulative cost = {1.7976931348623157E308
rows, Infinity cpu, 0.0 io, 0.0 network}, id = 54372
ValuesRel(subset=[rel#54371:Subset#10.NONE.ANY([]).[]], tuples=[[{ 2451181 }, {
2451182 }, { 2451188 }, { 2451189 }, { 2451195 }, { 2451196 }, { 2451202 }, {
2451203 }, { 2451209 }, { 2451210 }, { 2451216 }, { 2451217 }, { 2451223 }, {
2451224 }, { 2451230 }, { 2451231 }, { 2451237 }, { 2451238 }, { 2451244 }, {
2451245 }, { 2451251 }, { 2451252 }, { 2451258 }, { 2451259 }, { 2451265 }, {
2451266 }, { 2451272 }, { 2451273 }, { 2451279 }, { 2451280 }, { 2451286 }, {
2451287 }, { 2451293 }, { 2451294 }, { 2451300 }, { 2451301 }, { 2451307 }, {
2451308 }, { 2451314 }, { 2451315 }, { 2451321 }, { 2451322 }, { 2451328 }, {
2451329 }, { 2451335 }, { 2451336 }, { 2451342 }, { 2451343 }, { 2451349 }, {
2451350 }, { 2451356 }, { 2451357 }, { 2451363 }, { 2451364 }, { 2451370 }, {
2451371 }, { 2451377 }, { 2451378 }, { 2451384 }, { 2451385 }, { 2451391 }, {
2451392 }, { 2451398 }, { 2451399 }, { 2451405 }, { 2451406 }, { 2451412 }, {
2451413 }, { 2451419 }, { 2451420 }, { 2451426 }, { 2451427 }, { 2451433 }, {
2451434 }, { 2451440 }, { 2451441 }, { 2451447 }, { 2451448 }, { 2451454 }, {
2451455 }, { 2451461 }, { 2451462 }, { 2451468 }, { 2451469 }, { 2451475 }, {
2451476 }, { 2451482 }, { 2451483 }, { 2451489 }, { 2451490 }, { 2451496 }, {
2451497 }, { 2451503 }, { 2451504 }, { 2451510 }, { 2451511 }, { 2451517 }, {
2451518 }, { 2451524 }, { 2451525 }, { 2451531 }, { 2451532 }, { 2451538 }, {
2451539 }, { 2451545 }, { 2451546 }, { 2451552 }, { 2451553 }, { 2451559 }, {
2451560 }, { 2451566 }, { 2451567 }, { 2451573 }, { 2451574 }, { 2451580 }, {
2451581 }, { 2451587 }, { 2451588 }, { 2451594 }, { 2451595 }, { 2451601 }, {
2451602 }, { 2451608 }, { 2451609 }, { 2451615 }, { 2451616 }, { 2451622 }, {
2451623 }, { 2451629 }, { 2451630 }, { 2451636 }, { 2451637 }, { 2451643 }, {
2451644 }, { 2451650 }, { 2451651 }, { 2451657 }, { 2451658 }, { 2451664 }, {
2451665 }, { 2451671 }, { 2451672 }, { 2451678 }, { 2451679 }, { 2451685 }, {
2451686 }, { 2451692 }, { 2451693 }, { 2451699 }, { 2451700 }, { 2451706 }, {
2451707 }, { 2451713 }, { 2451714 }, { 2451720 }, { 2451721 }, { 2451727 }, {
2451728 }, { 2451734 }, { 2451735 }, { 2451741 }, { 2451742 }, { 2451748 }, {
2451749 }, { 2451755 }, { 2451756 }, { 2451762 }, { 2451763 }, { 2451769 }, {
2451770 }, { 2451776 }, { 2451777 }, { 2451783 }, { 2451784 }, { 2451790 }, {
2451791 }, { 2451797 }, { 2451798 }, { 2451804 }, { 2451805 }, { 2451811 }, {
2451812 }, { 2451818 }, { 2451819 }, { 2451825 }, { 2451826 }, { 2451832 }, {
2451833 }, { 2451839 }, { 2451840 }, { 2451846 }, { 2451847 }, { 2451853 }, {
2451854 }, { 2451860 }, { 2451861 }, { 2451867 }, { 2451868 }, { 2451874 }, {
2451875 }, { 2451881 }, { 2451882 }, { 2451888 }, { 2451889 }, { 2451895 }, {
2451896 }, { 2451902 }, { 2451903 }, { 2451909 }, { 2451910 }, { 2451916 }, {
2451917 }, { 2451923 }, { 2451924 }, { 2451930 }, { 2451931 }, { 2451937 }, {
2451938 }, { 2451944 }, { 2451945 }, { 2451951 }, { 2451952 }, { 2451958 }, {
2451959 }, { 2451965 }, { 2451966 }, { 2451972 }, { 2451973 }, { 2451979 }, {
2451980 }, { 2451986 }, { 2451987 }, { 2451993 }, { 2451994 }, { 2452000 }, {
2452001 }, { 2452007 }, { 2452008 }, { 2452014 }, { 2452015 }, { 2452021 }, {
2452022 }, { 2452028 }, { 2452029 }, { 2452035 }, { 2452036 }, { 2452042 }, {
2452043 }, { 2452049 }, { 2452050 }, { 2452056 }, { 2452057 }, { 2452063 }, {
2452064 }, { 2452070 }, { 2452071 }, { 2452077 }, { 2452078 }, { 2452084 }, {
2452085 }, { 2452091 }, { 2452092 }, { 2452098 }, { 2452099 }, { 2452105 }, {
2452106 }, { 2452112 }, { 2452113 }, { 2452119 }, { 2452120 }, { 2452126 }, {
2452127 }, { 2452133 }, { 2452134 }, { 2452140 }, { 2452141 }, { 2452147 }, {
2452148 }, { 2452154 }, { 2452155 }, { 2452161 }, { 2452162 }, { 2452168 }, {
2452169 }, { 2452175 }, { 2452176 }, { 2452182 }, { 2452183 }, { 2452189 }, {
2452190 }, { 2452196 }, { 2452197 }, { 2452203 }, { 2452204 }, { 2452210 }, {
2452211 }, { 2452217 }, { 2452218 }, { 2452224 }, { 2452225 }, { 2452231 }, {
2452232 }, { 2452238 }, { 2452239 }, { 2452245 }, { 2452246 }, { 2452252 }, {
2452253 }, { 2452259 }, { 2452260 }, { 2452266 }, { 2452267 }, { 2452273 }, {
2452274 }]]): rowcount = 314.0, cumulative cost = {314.0 rows, 1.0 cpu, 0.0 io,
0.0 network}, id = 54341
EnumerableTableAccessRel(subset=[rel#54386:Subset#18.ENUMERABLE.ANY([]).[]],
table=[[dfs, tmp, customer]]): rowcount = 100.0, cumulative cost = {100.0 rows,
101.0 cpu, 0.0 io, 0.0 network}, id = 54349
EnumerableTableAccessRel(subset=[rel#54366:Subset#7.ENUMERABLE.ANY([]).[]],
table=[[dfs, tmp, customer_address]]): rowcount = 100.0, cumulative cost =
{100.0 rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 54338
> CannotPlanException for TPC-DS query 8 due to large IN-list and Intersect
> operation
> -----------------------------------------------------------------------------------
>
> Key: DRILL-1308
> URL: https://issues.apache.org/jira/browse/DRILL-1308
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Aman Sinha
> Fix For: 0.7.0
>
>
> On TPC-DS query 8 gives a CannotPlanException. This is due to 2 reasons:
> 1. Large (>= 20 items) IN-list for which we need a ValuesOperator
> implementation
> 2. INTERSECT operation which is not yet supported.
> select * from (select store.s_store_name
> ,sum(ss.ss_net_profit)
> from store_sales ss
> ,date_dim dd
> ,store,
> (select ca_zip
> from (
> (SELECT substr(ca.ca_zip,1,5) ca_zip
> FROM customer_address ca
> WHERE substr(ca.ca_zip,1,5) IN (
> '16733','50732','51878','16933','33177','55974',
> '21338','90455','63106','78712','45114',
> '51090','44881','35526','91360','34986',
> '31893','28853','84061','25483','84541',
> '39275','56211','51199','85189','24292',
> '27477','46388','77218','21137','43660',
> '36509','77925','11691','26790','35256',
> '59221','42491','39214','35273','27293',
> '74258','68798','50936','19136','25240',
> '89163','21667','30941','61680','10425',
> '96787','84569','37596','84291','44843',
> '31487','24949','31269','62115','79494',
> '32194','62531','61655','40724','29091',
> '81608','77126','32704','79045','19008',
> '81581','59693','24689','79355','19635',
> '52025','83585','56103','80150','26203',
> '81571','85657','39672','62868','33498',
> '69453','25748','44145','35695','57860',
> '59532','76967','81235','22004','34487',
> '48499','47318','63039','77728','89774',
> '91640','76501','70137','37512','48507',
> '51980','34851','54884','30905','12745',
> '60630','42798','39923','47591','82518',
> '32982','14233','56444','79278','57791',
> '37395','93812','14062','21556','58923',
> '13595','87261','79484','24492','10389',
> '89526','21733','85078','35187','68025',
> '45624','25243','42027','50749','13870',
> '47072','17847','46413','11259','20221',
> '32961','14173','96788','77001','65695',
> '52542','39550','21651','68063','48779',
> '55702','16612','15953','22707','83997',
> '61460','18919','27616','55164','54421',
> '47268','66355','86846','74968','95883',
> '92832','37009','66903','38063','95421',
> '45640','55118','22721','54787','29772',
> '79121','85462','28380','34680','85831',
> '60615','60763','87605','10096','69252',
> '28329','68812','47734','36851','24290',
> '39067','32242','97396','45999','37157',
> '88891','71571','17941','12910','28800',
> '47548','11514','49224','50161','27249',
> '29522','50098','20810','23683','51862',
> '57007','43224','98002','65238','30719',
> '15735','70127','33927','96245','56649',
> '44640','34914','18833','72797','18380',
> '17256','75124','36114','44696','35472',
> '76579','52537','82424','44424','32748',
> '77516','17985','57725','34893','42886',
> '98097','62869','24984','80539','19716',
> '87183','63517','60342','42577','88040',
> '46167','75108','41469','73674','13253',
> '66716','36315','16812','85084','70345',
> '16291','84204','38177','41416','75043',
> '85969','52544','13572','21899','22356',
> '16473','25488','46385','18400','17159',
> '74763','34719','18588','39471','47156',
> '28837','84535','69380','54019','57251',
> '51378','43170','51671','40569','81767',
> '59720','68739','28324','24144','96283',
> '53359','11880','52839','13744','21434',
> '24927','99581','87926','93557','34275',
> '12144','82294','39717','28926','89184',
> '29862','38378','91135','17811','57160',
> '74994','34074','51040','69828','65826',
> '84570','24660','15444','62133','83549',
> '15555','80929','27543','86821','98908',
> '89602','68316','69972','40191','97204',
> '42699','56262','69604','44040','48466',
> '55692','14302','38041','33734','47513',
> '46513','16039','81050','34048','30741',
> '18213','99574','27215','60005','47953',
> '29145','14682','50833','74174','86506',
> '57452','92971','70344','66483','99501',
> '78134','79445','82179','44114','19591',
> '20096','85999','52672','47030','74464',
> '30215','59015','42068','25463','26536',
> '53394','43508','41140','29335','37130',
> '43967','22686','78500','70281','20148',
> '54335','31575','79592','16787'))
> intersect
> (select ca_zip
> from (SELECT substr(ca.ca_zip,1,5) ca_zip,count(*) cnt
> FROM customer_address ca, customer
> WHERE ca.ca_address_sk = customer.c_current_addr_sk and
> customer.c_preferred_cust_flag='Y'
> group by ca.ca_zip
> having count(*) > 10)A1))A2) V1
> where ss.ss_store_sk = store.s_store_sk
> and ss.ss_sold_date_sk = dd.d_date_sk
> and dd.d_qoy = 1 and dd.d_year = 2001
> and (substr(store.s_zip,1,2) = substr(V1.ca_zip,1,2))
> group by store.s_store_name
> order by store.s_store_name
> ) limit 100;
> message: "Failure while parsing sql. < CannotPlanException:[ Node
> [rel#35871:Subset#27.LOGICAL.ANY([]).[]] could not be implemented; planner
> state:
> Root: rel#35871:Subset#27.LOGICAL.ANY([]).[]
> Original rel:
> AbstractConverter(subset=[rel#35871:Subset#27.LOGICAL.ANY([]).[]],
> convention=[LOGICAL], DrillDistributionTraitDef=[ANY([])], sort=[[]]):
> rowcount = 1.7976931348623157E308, cumulative cost = {inf}, id = 35872
> SortRel(subset=[rel#35870:Subset#27.NONE.ANY([]).[]], fetch=[100]): rowcount
> = 1.7976931348623157E308, cumulative cost = {Infinity rows,
> 1.7976931348623157E308 cpu, 0.0 io, 0.0 network}, id = 35869
> ProjectRel(subset=[rel#35868:Subset#26.NONE.ANY([]).[0]], s_store_name=[$0],
> EXPR$1=[$1]): rowcount = 1.7976931348623157E308, cumulative cost =
> {1.7976931348623157E308 rows, Infinity cpu, 0.0 io, 0.0 network}, id = 35867
> SortRel(subset=[rel#35866:Subset#25.NONE.ANY([]).[0]], sort0=[$0],
> dir0=[ASC]): rowcount = 1.7976931348623157E308, cumulative cost = {Infinity
> rows, 1.7976931348623157E308 cpu, 0.0 io, 0.0 network}, id = 35865
> AggregateRel(subset=[rel#35864:Subset#24.NONE.ANY([]).[]], group=[{0}],
> EXPR$1=[SUM($1)]): rowcount = 1.7976931348623158E307, cumulative cost =
> {1.7976931348623158E307 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 35863
> ProjectRel(subset=[rel#35862:Subset#23.NONE.ANY([]).[]], s_store_name=[$9],
> ss_net_profit=[$3]): rowcount = 1.7976931348623157E308, cumulative cost =
> {1.7976931348623157E308 rows, Infinity cpu, 0.0 io, 0.0 network}, id = 35861
> FilterRel(subset=[rel#35860:Subset#22.NONE.ANY([]).[]], condition=[AND(=($1,
> $11), =($2, $7), =(CAST($5):INTEGER, 1), =(CAST($6):INTEGER, 2001),
> =(SUBSTR($10, 1, 2), SUBSTR($12, 1, 2)))]): rowcount =
> 1.3651232242860708E304, cumulative cost = {1.3651232242860708E304 rows,
> 1.7976931348623157E308 cpu, 0.0 io, 0.0 network}, id = 35859
> JoinRel(subset=[rel#35858:Subset#21.NONE.ANY([]).[]], condition=[true],
> joinType=[inner]): rowcount = 1.7976931348623157E308, cumulative cost =
> {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 35857
> JoinRel(subset=[rel#35827:Subset#4.NONE.ANY([]).[]], condition=[true],
> joinType=[inner]): rowcount = 1.7976931348623157E308, cumulative cost =
> {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 35826
> JoinRel(subset=[rel#35824:Subset#2.NONE.ANY([]).[]], condition=[true],
> joinType=[inner]): rowcount = 10000.0, cumulative cost = {10000.0 rows, 0.0
> cpu, 0.0 io, 0.0 network}, id = 35823
> EnumerableTableAccessRel(subset=[rel#35821:Subset#0.ENUMERABLE.ANY([]).[]],
> table=[[dfs, tpcds, store_sales]]): rowcount = 100.0, cumulative cost =
> {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 35792
> EnumerableTableAccessRel(subset=[rel#35822:Subset#1.ENUMERABLE.ANY([]).[]],
> table=[[dfs, tpcds, date_dim]]): rowcount = 100.0, cumulative cost = {100.0
> rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 35793
> EnumerableTableAccessRel(subset=[rel#35825:Subset#3.ENUMERABLE.ANY([]).[]],
> table=[[dfs, tpcds, store]]): rowcount = 100.0, cumulative cost = {100.0
> rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 35795
> ProjectRel(subset=[rel#35856:Subset#20.NONE.ANY([]).[]], ca_zip=[$0]):
> rowcount = 1.7976931348623157E308, cumulative cost = {1.7976931348623157E308
> rows, 1.7976931348623157E308 cpu, 0.0 io, 0.0 network}, id = 35855
> IntersectRel(subset=[rel#35854:Subset#19.NONE.ANY([]).[]], all=[false]):
> rowcount = 4.4942328371557893E307, cumulative cost = {4.4942328371557893E307
> rows, 4.4942328371557893E307 cpu, 0.0 io, 0.0 network}, id = 35853
> ProjectRel(subset=[rel#35837:Subset#10.NONE.ANY([]).[]], ca_zip=[SUBSTR($1,
> 1, 5)]): rowcount = 1.7976931348623157E308, cumulative cost =
> {1.7976931348623157E308 rows, 1.7976931348623157E308 cpu, 0.0 io, 0.0
> network}, id = 35836
> JoinRel(subset=[rel#35835:Subset#9.NONE.ANY([]).[]], condition=[=($3, $4)],
> joinType=[inner]): rowcount = 1.7976931348623157E308, cumulative cost =
> {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 35834
> ProjectRel(subset=[rel#35830:Subset#6.NONE.ANY([]).[]], $f0=[$0], $f1=[$1],
> $f2=[$2], $f3=[SUBSTR($1, 1, 5)]): rowcount = 100.0, cumulative cost = {100.0
> rows, 400.0 cpu, 0.0 io, 0.0 network}, id = 35829
> EnumerableTableAccessRel(subset=[rel#35828:Subset#5.ENUMERABLE.ANY([]).[]],
> table=[[dfs, tpcds, customer_address]]): rowcount = 100.0, cumulative cost =
> {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network}, id = 35797
--
This message was sent by Atlassian JIRA
(v6.2#6252)
