Hi,

 

I get the following error:

 

MALException:algebra.join:GDKerror
ERROR: GDKload failed: name=02/45/24557, ext=buns.priv

 

while executing the following query:

 

select count(*)
from (
select 1

from data_1to10 a,

       data_10to20 b

where a.col2 = b.col2 ) sq

 

I have attached a PERL script which is used to generate the required data for testing. I have also attached a  table definition script and the load script.

 

Please use the attached PERL script to generate the data as follows:

./massrecs.pl > <filename>

After generating the first file, you will need to update the PERL script to change the numbers in the for loop, so that the next 20 million rows from 10,000,001 to 20,000,000 are generated. You will also need to edit the "test_load_tables.sql" script to update the filename according to the name given.

Please let me know if you are unable to execute the test for any reason.

 

- Venkatesh