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"; }
test_create_tables.sql
Description: Binary data
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