[GitHub] incubator-madlib issue #57: Add PostgreSQL 9.5 and 9.6 support.

2016-07-20 Thread snaga
Github user snaga commented on the issue: https://github.com/apache/incubator-madlib/pull/57 Hi, I updated the PR and confirmed that "install-check" can pass on 9.4, 9.5 and 9.6beta2. Please take a look. --- If your project is set up for it, you can reply to this email and have y

Re: Sessionize function - create table or view by default?

2016-07-20 Thread Jim Nasby
On 7/20/16 4:17 PM, Joe Hellerstein wrote: I heartily concur with this assessment FWIW. I generally use views or WITH clauses myself when building up these kinds of pipelines. Note that WITH forces materialization. It's almost as bad as temp tables. In my experience, the PostgreSQL optimize

[GitHub] incubator-madlib issue #57: Add PostgreSQL 9.5 and 9.6 support.

2016-07-20 Thread fmcquillan99
Github user fmcquillan99 commented on the issue: https://github.com/apache/incubator-madlib/pull/57 Here are the supported platforms for MADlib 1.9: https://cwiki.apache.org/confluence/display/MADLIB/FAQ#FAQ-Q1-2WhatplatformsdoesMADlibsupport? Will update this for 1.9.1 to

Re: Sessionize function - create table or view by default?

2016-07-20 Thread Frank McQuillan
Thanks for the additional comment, Joe. Frank On Wed, Jul 20, 2016 at 2:17 PM, Joe Hellerstein wrote: > I heartily concur with this assessment FWIW. I generally use views or > WITH clauses myself when building up these kinds of pipelines. > > In my experience, the PostgreSQL optimizer is not g

Re: Sessionize function - create table or view by default?

2016-07-20 Thread Joe Hellerstein
I heartily concur with this assessment FWIW.  I generally use views or WITH clauses myself when building up these kinds of pipelines.  In my experience, the PostgreSQL optimizer is not great at collapsing views though.  So caveat emptor.  Users should be made very aware of EXPLAIN! J On July

[GitHub] incubator-madlib issue #57: Add PostgreSQL 9.5 and 9.6 support.

2016-07-20 Thread danielgustafsson
Github user danielgustafsson commented on the issue: https://github.com/apache/incubator-madlib/pull/57 The current version of GPDB (4.3.8.x) does not have `array_agg(anyarray)` and it's not included in the upcoming 5.0 codebase either. --- If your project is set up for it, you can r

Re: [VIRTUAL] MADlib Call Wednesday 7/27 9AM PT: Ask Us Anything (About MADlib)

2016-07-20 Thread Frank McQuillan
Thanks for suggesting this topic, Greg. Looking forward to it. Frank On Wed, Jul 20, 2016 at 11:18 AM, Gregory Chase wrote: > Dear MADlib community, > We're holding another Apache MADlib (incubating) community call next week, > Wednesday, July 27, at 9AM. > > Topic: Ask Us Anything (about MAD

[VIRTUAL] MADlib Call Wednesday 7/27 9AM PT: Ask Us Anything (About MADlib)

2016-07-20 Thread Gregory Chase
Dear MADlib community, We're holding another Apache MADlib (incubating) community call next week, Wednesday, July 27, at 9AM. Topic: Ask Us Anything (about MADlib) Agenda: Whatever we get asked Join us for an open Q&A about using MADlib. We'll have the best expert contributors and data science

Re: Sessionize function - create table or view by default?

2016-07-20 Thread Frank McQuillan
Hey Jim, Thank you for the thoughtful response. Given your comments, I think we ought to stick with a view as the default for sessionize. Looking ahead to MADlib 2.0, one thing we want to better support is workflows since chaining operations together is such a common data science thing to do. T

Re: Sessionize function - create table or view by default?

2016-07-20 Thread Jim Nasby
On 7/19/16 7:36 PM, Frank McQuillan wrote: "create_view (optional) BOOLEAN default: TRUE. Determines whether to create a view or materialize a table as output. If you only needed session info once, creating a view could be significantly faster than materializing as a table." Question is: should

[GitHub] incubator-madlib pull request #57: Add PostgreSQL 9.5 and 9.6 support.

2016-07-20 Thread snaga
Github user snaga commented on a diff in the pull request: https://github.com/apache/incubator-madlib/pull/57#discussion_r71476210 --- Diff: methods/array_ops/src/pg_gp/array_ops.sql_in --- @@ -602,11 +602,22 @@ m4_ifdef(`__HAS_FUNCTION_PROPERTIES__', `NO SQL', `'); *i