Hi,
Some more info on this error, finally this is does not related to merge tables but to remote tables. Steps to reproduce:
In one server: create table lala(sx float, sxx float, sxy float , sy float, syy float, n int); insert into lala select 13,85,98,15,113,2;
In another remote server: CREATE REMOTE TABLE fofo(sx FLOAT, sxx FLOAT, sxy FLOAT, sy FLOAT, syy FLOAT, n INT) on 'mapi:monetdb://88.197.53.136:9999/voc10/sys/lala';
CREATE or replace FUNCTION mudf(sx FLOAT, sxx FLOAT, sxy FLOAT, sy FLOAT, syy FLOAT, n INT) RETURNS TABLE(res FLOAT) LANGUAGE PYTHON { return 0.5 };
After that I am getting the following: sql>select * from mudf((select * from fofo)); (mapi:monetdb://monetdb@88.197.53.136/voc10) Table: missing ‘)'
If I materialise the remote table into a local table, and then use the udf it runs:
sql>create table localtable as select * from fofo; operation successful sql>select * from mudf((select * from localtable)); +--------------------------+ | res | +==========================+ | 0.5 | +--------------------------+ 1 tuple sql>
Best, Yannis
On 16 Sep 2020, at 3:34 PM, Ioannis Foufoulas johnfouf@di.uoa.gr wrote:
Hi, we encounter an error when only one table is added to a merge table definition During a query like "select * from merge table” we get: “Table: missing ')'" Probably merge tables cannot contain just one table but the returned error looks like a syntax error. Some more info to reproduce: the table that has been added to the merge table is a remote table.
Best, Yannis