I am trying to use these function
SELECT * FROM SAMPLE(ON table SAMPLEFRACTION('0.2'));
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 ?
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.