[
https://issues.apache.org/jira/browse/MADLIB-1162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16194889#comment-16194889
]
Yihui commented on MADLIB-1162:
-------------------------------
hi Rahul,
Thanks for your reply. The query I am trying to execute is:
*DROP TABLE IF EXISTS train_output, train_output_group, train_output_summary;
SELECT madlib.forest_train('dt_golf', -- source table
'train_output', -- output model table
'id', -- id column
'class', -- response
'"OUTLOOK", temperature, humidity, windy', --
features
NULL, -- exclude columns
NULL, -- grouping columns
20::integer, -- number of trees
2::integer, -- number of random features
TRUE::boolean, -- variable importance
1::integer, -- num_permutations
8::integer, -- max depth
3::integer, -- min split
1::integer, -- min bucket
10::integer -- number of splits per
continuous variable
);
*
with the *dt_golf* table exists and the table I want to write into the schema
that I have WRITE access to (sandbox).
For more information: I can use the function *tree_train* with the same
structure and same table name, but not for random forest.
Please advise.
Thanks!!
> Denied Access to Schema Public when using Random Forest
> -------------------------------------------------------
>
> Key: MADLIB-1162
> URL: https://issues.apache.org/jira/browse/MADLIB-1162
> Project: Apache MADlib
> Issue Type: Question
> Components: All Modules
> Reporter: Yihui
>
> Hi,
> Currently on the server that I use I have the following version of MADlib
> installed:
> *MADlib version: 1.10.0, git revision: rel/v1.9.1-58-ga3863b6, cmake
> configuration time: Tue Feb 28 18:35:58 UTC 2017, build type: Release, build
> system: Linux-2.6.18-238.27.1.el5.hotfix.bz516490, C compiler: gcc 4.4.0, C++
> compiler: g++ 4.4.0*
> when I am trying to used the function "forest_train" (The Random Forest
> Library) I got error message saying that my access is denied from Schema
> Public.
> Currently I only have SELECT Usage to Public Schema and I will not be able to
> get other type of privilege to public schema because I am using corporate DB;
> I am wondering in this case how am I able to use the random forest function?
>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
