Hi all,
I am generating MAL queries in Java and I am using the JDBC interface to
execute them. This works fine for small tables. But if the resultSet has
more than 100 entries MonetDB is printing the first 100 rows and then
gives me the following error:
...
[ 19, "undergraduateDegreeFrom", 1509 ]
[ 19, "memberOf", 613 ]
[ 19, "takesCourse", 556 ]
[ 19, "advisor", 600 ]
[ 20, "undergraduateDegreeFrom", 1493 ]
[ 20, "memberOf", 613 ]
[ 20, "takesCourse", 529 ]
[ 20, "takesCourse", 578 ]
[ 20, "takesCourse", 557 ]
[ 20, "advisor", 1315 ]
MAPI = (monetdb) /tmp/.s.monetdb.50000
QUERY = sql.resultSet(table_names, table_attrs, table_type, table_lens,
table_scales, start_id, type, end_id);
ERROR = !SyntaxException:parseError:Xclose 0
!SyntaxException:parseError: ^';' expected
Could you help me to avoid this error?
This is the full query:
sql.init();
tbd := sql.mvc();
start_id:bat[:int] := sql.bind(tbd,"sys","relations","start_id",0:int);
type:bat[:str] := sql.bind(tbd,"sys","relations","type",0:int);
end_id:bat[:int] := sql.bind(tbd,"sys","relations","end_id",0:int);
table_names := bat.new(nil:str);
table_names := bat.append(table_names, "start_id");
table_names := bat.append(table_names, "type");
table_names := bat.append(table_names, "end_id");
table_attrs := bat.new(nil:str);
table_attrs := bat.append(table_attrs, "str");
table_attrs := bat.append(table_attrs, "str");
table_attrs := bat.append(table_attrs, "str");
table_type := bat.new(:str);
table_type := bat.append(table_type, "int");
table_type := bat.append(table_type, "varchar");
table_type := bat.append(table_type, "int");
table_lens := bat.new(nil:int);
table_lens := bat.append(table_lens, 1);
table_lens := bat.append(table_lens, 1);
table_lens := bat.append(table_lens, 1);
table_scales := bat.new(nil:int);
table_scales := bat.append(table_scales, 0);
table_scales := bat.append(table_scales, 0);
table_scales := bat.append(table_scales, 0);
sql.resultSet(table_names, table_attrs, table_type, table_lens,
table_scales, start_id, type, end_id);
I am using "MonetDB Database Server v1.7 (Dec2016-SP5)" on Ubuntu 14.04.
What am I trying to do:
The goal of the project is to use Cypher as an input language for
MonetDB. I have a Cypher optimizer written in Java. The output of this
optimizer should be used as input for MonetDB.
In the end we want to compare the the runtime of a query in MonetDB and
in Neo4J.
Thanks and regards,
Dennis
