Hi Marten,

I didn’t modify the query plan. I retrieved the query plan using ‘explain <sql query>’ for tpch query #02. However, I checked the latest MonetDB version 11.17.21, it also gives the errors.

Further, upon running the MAL function for TPCH query #02  located in: MonetDB-11.17.21/sql/benchmarks/tpch/Tests/02-explain.stable.out

I also get:

!TypeException:user.s2_1[23]:'algebra.join' undefined in: (X_41:any, r1_46:any) := algebra.join(X_31:bat[:oid,:oid], X_40:bat[:oid,:any])

!TypeException:user.main[1]:'user.s2_1' undefined in: _1:any := user.s2_1()

Regards,

From: users-list [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Martin Kersten
Sent: 03 October 2014 17:20
To: Communication channel for MonetDB users
Subject: Re: MAL script error

this is insufficient to identify. Most likely you attempted to use a modified plan, where the type of z-150 and r1-280 can not be statically determined. 

regards, martin

On 3 okt. 2014, at 16:52, "Hassan, Ahmad" <ahmad.hassan@sap.com> wrote:

Hi,

One executing the MAL script http://pastebin.com/VUPbhD8V , I get the following errors:

!TypeException:user.s0_11[87]:'algebra.join' undefined in: (X_150:any, r1_280:any) := algebra.join(X_137:bat[:oid,:oid], X_149:bat[:oid,:any])

!TypeException:user.s0_11[88]:'algebra.leftfetchjoin' undefined in: X_152:any := algebra.leftfetchjoin(r1_280:any, X_138:bat[:oid,:oid])

!TypeException:user.s0_11[94]:'algebra.join' undefined in: (X_161:any, r1_304:any) := algebra.join(X_152:any, X_160:bat[:oid,:any])

!TypeException:user.s0_11[95]:'algebra.leftfetchjoin' undefined in: X_404:any := algebra.leftfetchjoin(X_150:any, X_135:bat[:oid,:oid])

!TypeException:user.s0_11[100]:'algebra.leftfetchjoinPath' undefined in: X_174:bat[:oid,:int] := algebra.leftfetchjoinPath(X_161:any, X_404:any, X_173:bat[:oid,:any])

!TypeException:user.s0_11[106]:'algebra.leftfetchjoin' undefined in: X_183:any := algebra.leftfetchjoin(r1_304:any, X_182:bat[:oid,:any])

!TypeException:user.s0_11[107]:'algebra.join' undefined in: (X_184:any, r1_343:any) := algebra.join(X_183:any, X_107:bat[:oid,:int])

!TypeException:user.s0_11[109]:'algebra.leftfetchjoin' undefined in: X_187:any := algebra.leftfetchjoin(X_186:bat[:oid,:oid], X_183:any)

!TypeException:user.s0_11[110]:'group.subgroupdone' undefined in: (X_188:any, r1_349:any, r2_349:any) := group.subgroupdone(X_187:any)

!TypeException:user.s0_11[111]:'algebra.leftfetchjoin' undefined in: X_191:any := algebra.leftfetchjoin(r1_349:any, X_187:any)

!TypeException:user.s0_11[113]:'algebra.leftfetchjoinPath' undefined in: X_195:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_186:bat[:oid,:oid], r1_304:any, X_194:bat[:oid,:any])

!TypeException:user.s0_11[114]:'aggr.submin' undefined in: X_196:bat[:oid,:lng] := aggr.submin(X_195:bat[:oid,:lng], X_188:any, r1_349:any, _201:bit)

!TypeException:user.s0_11[119]:'algebra.leftfetchjoin' undefined in: X_202:any := algebra.leftfetchjoin(r1_389:bat[:oid,:oid], X_191:any)

!TypeException:user.main[2]:'user.s0_11' undefined in: _4:any := user.s0_11()

The equivalent SQL query works fine but I am interested in running MAL script via mserver5. How can I resolve the above exceptions please?

Thanks.

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list