Outer Join as Cartesian Product

[#1]

I am applying Outer join to get Cartesian product on 2 tables (without any common key ). table 1 has 500000 rows and tale 2 has 5000 rows . it is showing "execution of script failed " error.

Is it any QV limitation /

Also what can be a better alternative ?

[sunny_talwar]

Might be memory (RAM) constraints?

UPDATE: Check memory performance while reloading the application

[Peter_Cammaert]

An alternative to do what?

[Colin-Albert]

Do you really need a Cartesian join between these tables  500,000 x 5,000 = 2,500,000,000 rows!

Hope you've got plenty of RAM!

Perhaps it would be better to explain what you are trying to achieve. A Cartesian join is rarely the correct answer.

[swuehl]

You can also try running your script with a limited amount of records (e.g. using FIRST) just to check if there is any other problem with your script.

You can then also consider not JOINing the full tables, but creating a link table made by a cartesian JOIN of the two primary keys of your two tables.

Not sure if this will resolve your issue, since I have no clue what you want to achieve at the end.

[Gysbert_Wassenaar]

Also what can be a better alternative ?

Not trying it in the first place.

Why do you think you need to create a 2.5 billion row table?

[#7]

Thanks all !!...Yes it was a business requirement to process that much data. Later on we limited the data by applying conditions on that  and it worked.

[Colin-Albert]

Surely there must be a better way to get your results without using a Cartesian join.

Perhaps you should review your data model.

Perfect Your QlikView Data Model

Best Practices for Data Modelling