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.
Thanks,

- Venkatesh
#!/usr/bin/perl
# This function generates random strings of a given length
sub generate_random_string
{
        my $length_of_randomstring=shift;# the length of 
                         # the random string to generate

        # my @chars=('A'..'Z','0'..'9','+','-',',');
        my @chars=('A'..'Z');
        my $random_string;
        foreach (1..$length_of_randomstring) 
        {
                # rand @chars will generate a random 
                # number between 0 and scalar @chars
                $random_string.=$chars[rand @chars];
        }
        return $random_string;
}

#Generate the random string
my $random_string=&generate_random_string(11);

my $i;
my $random_string;
my $random;
my $lower=10000; 
my $upper=99999; 

# 
========================================================================================
# Please change the numbers in the for loop below for controlling the ID and 
the row count
# 
========================================================================================

for ($i=1;$i<10000001;$i++) {

        $random_string=&generate_random_string(2);

        $random = int(rand( $upper-$lower+1 ) ) + $lower; 

        # printf "%28.0f\n",$random; 
        printf "$i\t$random\t$random_string\n"; 

}

Attachment: test_create_tables.sql
Description: Binary data

Attachment: test_load_tables.sql
Description: Binary data

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply via email to