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

[Sankara Subramanian,Karthik Maharajan]

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

[cid:8C8230D7-18AC-4E6A-8036-05B174287DF1][cid:539D4CA1-644F-4D0B-9991-BB40E405EEDB]
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 
mailto: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 
mailto:fmcquil...@pivotal.io>> 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

[Sankara Subramanian,Karthik Maharajan]

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

[cid:B6D4E7BF-CBF4-4E8A-B8AE-83676C544DD0]



The next screenshot shows that MADlib has been successfully installed.

[cid:BB51D11C-4442-4B94-8595-825B8EB8F635]
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 
mailto:fmcquil...@pivotal.io>> 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

[GitHub] incubator-madlib issue #81: JIRA: MADLIB-927 Changes made in KNN-help messag...

[njayaram2]

Github user njayaram2 commented on the issue:

https://github.com/apache/incubator-madlib/pull/81
  
Go ahead and make the commit. I had a couple of changes to make, will open 
a PR on your branch for those changes.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-madlib issue #81: JIRA: MADLIB-927 Changes made in KNN-help messag...

[auonhaidar]

Github user auonhaidar commented on the issue:

https://github.com/apache/incubator-madlib/pull/81
  
Hi NJ, Orhan
I am done with adding following validation cases:

- Check if train and test table is valid
- if columns specified are present in these tables
- if k>0 or not
- if k<= number of rows in train table or not
- Are feature column of array type or not
- Are NULL values present in these feature columns or not
- Is Id column of test table integer or not
- Is label valid (float, integer, boolean) or not


I will be committing these changes tomorrow.
Please suggest if I am leaving anything.



Auon





---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

Re: Status of on-going PRs

[Rahul Iyer]

Hi Satoshi,

Thanks for compiling this list. Please find my comments inline.

On Tue, Jan 31, 2017 at 3:04 AM, Satoshi Nagayasu  wrote:

> Hi all,
>
> As release manager for 1.10, I just did a quick review and created a status
> list of the on-going PRs.
>
> https://github.com/apache/incubator-madlib/pulls
>
> If you have comments, please let me know. I will update the status.
>
> Status of the PRs
> -
> Use relative path for installation in GPDB/HAWQ #94
>   -> Need to be tested with GPDB/HAWQ.
>
> Build: Use only major version for GPDB 5, HAWQ 2 #91
>   -> Need review?
>
​Testing is complete for both PRs. Requires a review.
​

> Allow encode_categorical_variables() to use the svec type. #93
>   -> Need more work by the developer (me).
>
​This would be better merged within the 1.10 release.
Adding it to the next version would require special handling by upgrade
since there is a change in argument type (hence requiring drop/replace
during upgrade).


>  K-means: support for array input #89
>   -> Need more review, or ready for committer?
>
​This looks ready to merge. ​

>
> JIRA: MADLIB-927 Changes made in KNN-help message-test cases-etc #81
>   -> Need more work by the developer.
>
> HAWQ2.1: Changes the cmake to assume any HAWQ 2.X system is 2.0 and #79
>   -> Need review, or ready for committer?
>
​This is superseded by #91 and will be closed with it. ​


> Include boost::format in MathToolkit_impl.hpp. #76
>   -> Already merged. The PR can be closed.
>
​I forgot to close this with the commit message and can only be manually
closed by the contributor. If not closed soon, I'll close it with a future
commit.
​

> SVM: Implement c++ functions for training multi-class svm in mini-batch #75
>   -> The doc needs to be updated?
>
​This requires substantial more work and discussion as the scope of the
work is not defined. We will have to ​release without it.



>
> Regards,
> --
> Satoshi Nagayasu 
>

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
>
>
>

Status of on-going PRs

[Satoshi Nagayasu]

Hi all,

As release manager for 1.10, I just did a quick review and created a status
list of the on-going PRs.

https://github.com/apache/incubator-madlib/pulls

If you have comments, please let me know. I will update the status.

Status of the PRs
-
Use relative path for installation in GPDB/HAWQ #94
  -> Need to be tested with GPDB/HAWQ.

Allow encode_categorical_variables() to use the svec type. #93
  -> Need more work by the developer (me).

Build: Use only major version for GPDB 5, HAWQ 2 #91
  -> Need review?

K-means: support for array input #89
  -> Need more review, or ready for committer?

JIRA: MADLIB-927 Changes made in KNN-help message-test cases-etc #81
  -> Need more work by the developer.

HAWQ2.1: Changes the cmake to assume any HAWQ 2.X system is 2.0 and #79
  -> Need review, or ready for committer?

Include boost::format in MathToolkit_impl.hpp. #76
  -> Already merged. The PR can be closed.

SVM: Implement c++ functions for training multi-class svm in mini-batch #75
  -> The doc needs to be updated?

Regards,
-- 
Satoshi Nagayasu