Load script failed due to joining / keeping

[#1]

Hello everybody,

I am trying to join some tables and i am getting error while doing that. Please find the log below. Please help in solving. This is quite urgent.

0438  TABLE_Eina_EineFL:

0439   LOAD FK_product AS Material,

0440       sap_purchasing_info_rec,

0441       sap_vendor AS EINA_Vendor,

0442       sap_complete_info_record

0443  FROM [EINA.qvd](qvd)

4 fields found: Material, sap_purchasing_info_rec, EINA_Vendor, sap_complete_info_record, 1 590 896 lines fetched

0445  LEFT JOIN(TABLE_Eina_EineFL)

0446   LOAD sap_purchasing_info_rec,

0447       sap_plant AS EINE_Plant,

0448       sap_planned_deliv_time AS EINE_Planned_Delivery_Tim,

0449       sap_net_price AS EINE_NetPrice

0450  FROM [EINE.qvd](qvd)

0451  WHERE EXISTS(sap_purchasing_info_rec)

4 fields found: sap_purchasing_info_rec, EINE_Plant, EINE_Planned_Delivery_Tim, EINE_NetPrice, 496 216 lines fetched

Joining/Keeping

0453  LEFT JOIN(TABLE_Eina_EineFL)

0454   LOAD sap_plant,

0455    FK_product,

0456        sap_vendor

0457  FROM [EORD.qvd](qvd)

0458  WHERE EXISTS(sap_plant)

3 fields found: sap_plant, FK_product, sap_vendor, 333 263 lines fetched

Joining/Keeping

General Script Error

Execution Failed

Execution finished.

[antoniotiman]

May be

in the last table

WHERE EXISTS(EINE_plant,sap_plant)

[jonathandienst · Accepted solution]

There is no association (common fields) between the last table and the tables above, so QV is doing a cross join of 1.5m rows with 0.5m rows (producing 750 billion rows), so your computer is just running out of memory.

You probably should not be aliasing sap_plant and sap_vendor earlier or rename them the same way for the third table.

[jonathandienst]

The statement is for a left join, but QV has to produce the cross join in order to perform the left join.

[Anil_Babu_Samineni]

What you want to achieve here, Can i know which values you want?

[#6]

I want to join EINA with EINE and then the resultant with EORD.