Map Reduce Functions

Aster
Teradata Employee

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 ?

1 REPLY

Re: Map Reduce Functions

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.