Re: schema "madlib" does not exist error on Mac OS Sierra

[Frank McQuillan]

I don't think the mailing list supports attachments. At least I cannot see
them.  Maybe cut and paste in-line.

Frank

On Tue, Jan 31, 2017 at 7:33 PM, Sankara Subramanian,Karthik Maharajan <
skarthikmahar...@ufl.edu> wrote:

> I guess pasting the images did not work. Please find the screenshots
> attached,
>
> MADlib.png —> Shows successful installation of MADlib.
> postgresql.png —> Shows the error I had mentioned. I execute this query
> after creating the table and inserting 20 rows as in this tutorial page -->
> https://cwiki.apache.org/confluence/display/MADLIB/
> Quick+Start+Guide+for+Users
>
>
> Thanks and Regards,
>
> Karthik Maharajan Sankara Subramanian
> Computer and Information Science and Engineering Department
> Herbert Wertheim College of Engineering
> University of Florida
> Gainesville, FL-32611
>
>
> On Jan 31, 2017, at 10:25 PM, Sankara Subramanian,Karthik Maharajan <
> skarthikmahar...@ufl.edu> wrote:
>
> Hi Frank,
> Please find the screenshots below,
>
> This is the error I had mentioned. I execute this query after creating the
> table and inserting 20 rows as in this tutorial page
> -> https://cwiki.apache.org/confluence/display/MADLIB/
> Quick+Start+Guide+for+Users
>
>
>
>
> The next screenshot shows that MADlib has been successfully installed.
>
> Please let me know if you need more details.
>
>
>
> Thanks and Regards,
>
> Karthik Maharajan Sankara Subramanian
> Computer and Information Science and Engineering Department
> Herbert Wertheim College of Engineering
> University of Florida
> Gainesville, FL-32611
>
>
> On Jan 31, 2017, at 2:24 PM, Frank McQuillan 
> wrote:
>
> Karthik,
>
> Please attach the output from the installation so we can have a look.
>
> Thanks,
> Frank
>
> On Mon, Jan 30, 2017 at 5:48 PM, Sankara Subramanian,Karthik Maharajan <
> skarthikmahar...@ufl.edu> wrote:
>
> MADlib community,
> I am using Mac OS Sierra 10.12.2. I have installed both postgresql and
> Madlib as per the “Super Quick Start” instruction in this page ->
> https://cwiki.apache.org/confluence/display/MADLIB/Installation+Guide.
> The installations were successful. However, when I try to run the sample
> logistic regression query from the tutorial page,
>
> SELECT madlib.logregr_train(
>'patients', -- source table
>'patients_logregr', -- output table
>'second_attack',-- labels
>'ARRAY[1, treatment, trait_anxiety]',   -- features
>NULL,   -- grouping columns
>20, -- max number of iteration
>'irls'  -- optimizer
>);
>
> I am getting the error,
>
> ERROR:  schema "madlib" does not exist
> LINE 1: SELECT madlib.logregr_train(
>
>
> Should I manually create the schema for madlib? Please let me know what I
> am missing here.
>
>
>
> Thanks and Regards,
>
> Karthik Maharajan Sankara Subramanian
> Computer and Information Science and Engineering Department
> Herbert Wertheim College of Engineering
> University of Florida
> Gainesville, FL-32611
>
>
>
>
>
>

Re: schema "madlib" does not exist error on Mac OS Sierra

[Frank McQuillan]

Karthik,

Please attach the output from the installation so we can have a look.

Thanks,
Frank

On Mon, Jan 30, 2017 at 5:48 PM, Sankara Subramanian,Karthik Maharajan <
skarthikmahar...@ufl.edu> wrote:

> MADlib community,
> I am using Mac OS Sierra 10.12.2. I have installed both postgresql and
> Madlib as per the “Super Quick Start” instruction in this page ->
> https://cwiki.apache.org/confluence/display/MADLIB/Installation+Guide.
> The installations were successful. However, when I try to run the sample
> logistic regression query from the tutorial page,
>
> SELECT madlib.logregr_train(
> 'patients', -- source table
> 'patients_logregr', -- output table
> 'second_attack',-- labels
> 'ARRAY[1, treatment, trait_anxiety]',   -- features
> NULL,   -- grouping columns
> 20, -- max number of iteration
> 'irls'  -- optimizer
> );
>
> I am getting the error,
>
> ERROR:  schema "madlib" does not exist
> LINE 1: SELECT madlib.logregr_train(
>
>
> Should I manually create the schema for madlib? Please let me know what I
> am missing here.
>
>
>
> Thanks and Regards,
>
> Karthik Maharajan Sankara Subramanian
> Computer and Information Science and Engineering Department
> Herbert Wertheim College of Engineering
> University of Florida
> Gainesville, FL-32611
>
>
>

schema "madlib" does not exist error on Mac OS Sierra

[Sankara Subramanian,Karthik Maharajan]

MADlib community,
I am using Mac OS Sierra 10.12.2. I have installed both postgresql and Madlib 
as per the “Super Quick Start” instruction in this page ->  
https://cwiki.apache.org/confluence/display/MADLIB/Installation+Guide. The 
installations were successful. However, when I try to run the sample logistic 
regression query from the tutorial page,

SELECT madlib.logregr_train(
'patients', -- source table
'patients_logregr', -- output table
'second_attack',-- labels
'ARRAY[1, treatment, trait_anxiety]',   -- features
NULL,   -- grouping columns
20, -- max number of iteration
'irls'  -- optimizer
);

I am getting the error,

ERROR:  schema "madlib" does not exist
LINE 1: SELECT madlib.logregr_train(


Should I manually create the schema for madlib? Please let me know what I am 
missing here.



Thanks and Regards,

Karthik Maharajan Sankara Subramanian
Computer and Information Science and Engineering Department
Herbert Wertheim College of Engineering
University of Florida
Gainesville, FL-32611