All Forums Aster
AxelJacquin 2 posts Joined 04/15
20 May 2015
Map Reduce Functions

Hello,
I am trying to use these function

SELECT * FROM SAMPLE(ON table SAMPLEFRACTION('0.2'));
or 

SELECT * FROM glmpredict ([...]);
but I have often this error:
- "STATEMENT 1: Select Statement failed.  Failed [34 : 42000] [AsterData][ASTERJDBCDSII](34) ERROR: relation "glmpredict" does not exist ()"
- "STATEMENT 1: Select Statement failed.  Failed [34 : 42000] [AsterData][ASTERJDBCDSII](34) ERROR: relation "sample" does not exist ()"
But sometimes it is working, sometimes when I restart studio express not.

Any ideas ?
 

shukla2502 3 posts Joined 07/13
20 May 2015

Hi,
You need to install these functions first to use them..if they are not..
you can do that by a simple \install <function>.jar command.
if the function is installed and you are able to use it sometimes and not always the only case i can thinkoff is you are switching b/w the schemas. And a fucntion will not work if it is not part of the schema or have the desired privalage..
 
You can always type “\dF+” or “\dF *.*” to check which schema a function belongs to. When you call the function, Aster Data recommends that you include its schema name.
 
Type \dF+ <function name> to check which schema the function belongs to.
Hopefully this helps.
 

You must sign in to leave a comment.