Bryan Bickford | 11 Dec 20:01 2014

[MADlib-user] Concurrency Support

I was wondering what level of concurrency is supported in MADlib 1.6.

I have a multi user/multi database system. Since madpack installs on
seperate databases, I assume that there is concurrency support built in
across databases?

Can the same be said for multiple users simultaneously accessing the same
database with the same or different madlib function calls?

Thanks!
Gareth James | 9 Dec 21:46 2014

[MADlib-user] Redshift

Is the postgres version used at Amazon Redshift supported by madlib?
Ioannis Atsonios | 9 Sep 11:12 2014
Picon

Re: [MADlib-user] Welcome to the "User" mailing list

iatsonios@...

On Tue, Sep 9, 2014 at 12:20 PM, <user-request@...> wrote:

> Welcome to the User@... mailing list!
>
> To post to this list, send your email to:
>
>   user@...
>
> General information about the mailing list is at:
>
>   http://madlib.net/mailman/listinfo/user
>
> If you ever want to unsubscribe or change your options (eg, switch to
> or from digest mode, change your password, etc.), visit your
> subscription page at:
>
>   http://madlib.net/mailman/options/user/iatsonios%40gmail.com
>
> You can also make such adjustments via email by sending a message to:
>
>   User-request@...
>
> with the word `help' in the subject or body (don't include the
> quotes), and you will get back a message with instructions.
>
> You must know your password to change your options (including changing
> the password, itself) or to unsubscribe.  It is:
>
(Continue reading)

afancy | 7 Sep 19:29 2014
Picon

[MADlib-user] compile error on MADlib 1.6 + PostgreSQL9.3

Hi,

I compile Madlib1.6 againt postgresql 9.3 on Ubuntu 12.04. But there is an
error.
It would be apprecaiated if anybody could help . Thanks

Regards,
afancy

root <at> xiliu-ubuntu:/tmp/madlib-1.6.0# make
make -C build all
make[1]: Entering directory `/tmp/madlib-1.6.0/build'
make[2]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  1%] Built target EP_eigen
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target EP_pyxb
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target pythonFiles
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target sqlFiles
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
[  2%] Built target madlibPatches
make[3]: Entering directory `/tmp/madlib-1.6.0/build'
make[3]: Leaving directory `/tmp/madlib-1.6.0/build'
(Continue reading)

Nitin Borwankar | 7 Aug 20:47 2014
Picon

[MADlib-user] compiling madlib on other platforms

Hello all,

This may sound extremely "out there" but I am curious if it is possible to
build madlib on a Raspberry Pi and bind it into Postgres.

I have run Postgres 9.1 which is installable via apt-get and am looking for
how to install 9.2 or 9.3 which may involve building on the Pi which is
rumored to take all night.
All this is on Raspbian which is a Debian Wheezy port.

Once I have the requisite Postgres can madlib be installed on it using the
usual install from source or is the ARM platform a non-starter?

Nitin.

------------------------------------------------------------------
Nitin Borwankar
nborwankar@...
West, Michael | 6 Aug 20:37 2014

[MADlib-user] summary function integer mfv_frequencies


I seem to be getting incorrect frequency results for integer columns using the summary function.  For
example, if I have a column of unique sequential integers of sufficient cardinality then frequencies
become greater than one as returned by the summary function. 

Select version();
PostgreSQL 9.2.8 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit

MadLib 1.6

Here is a script that demonstrates

----
--DROP TABLE summary_test;

CREATE TABLE summary_test as (
SELECT generate_series FROM generate_series(1,10000)
);

-- select * from summary_test;

select madlib.summary( 
    source_table := 'summary_test'::text
  , output_table := 'summary_output'::text
  , target_cols := 'generate_series'::text
  , grouping_cols := NULL::text
  , get_distinct := FALSE
  , get_quartiles := FALSE
  , ntile_array := NULL::FLOAT8[]
  , how_many_mfv := 10
(Continue reading)

Benjamin Wilson | 28 Jul 19:28 2014
Picon

[MADlib-user] nearest neighbours search in madlib

Hi all,

Does MADLib offer any facilities for nearest neighbours lookup on
vectorial data, approximate or exact?

Googling around, I found this:
  http://madlib.sourcearchive.com/documentation/1.3.0-1/kd__fix__rad__search_8cpp-source.html
But I am not sure if this is current.

Any help would be greatly appreciated!

Cheers, Benjamin.
Picon

[MADlib-user] optimal ARIMA order parameters

Hi,
   I would like to know if a function has been developed to compute the optimal order for ARIMA (similar to
auto.arima - checking BIC or AIC or smallest MLE using stepwise selection process) in Madlib.

Please let me know..

Thanks,
Srini.
Nick | 10 Jun 18:10 2014
Picon

[MADlib-user] Using PivotalR with SQL Server

Sorry if I missed this but I've been looking and haven't seen mention of how to use PivotalR with SQL Server.
 I know it isn't a native thing but  i can't tell if it's possible and I haven't figured it out, or if it
simply isn't possible. 

My RODBC equivalent is below.  VF9 is the server name.

library(RODBC)
>
>
>user_id <- "my_user_name"
>password <- "my_password"
>myconn <- odbcConnect("VF9", uid = user_id, pwd = password)
>
>
>
>
># Execute query
>data_frame <- sqlQuery(myconn, "
>                            select * 
>                            from Finance.dbo.finance_001
>                           ")
>
>

Thank you so much in advance.  This looks like literally the perfect package if I can use it with SQL Server. 

Nick
Budi Wibowo | 3 Jun 21:22 2014
Picon

[MADlib-user] other flavor of SQL with MADlib

Hello,
I’m new to MADlib. Just started to dig around this couple of days. I saw the instruction to run MADlib on top
of Postgre. Is it possible to run MADlib on top of MS SQL Server, MySQL or Oracle? could someone share if they
have done it in the past?

thank you!!

-- 
Budi Wibowo
Sent with Airmail
_______________________________________________
MADlib user discussion mailing list
User <at> madlib.net
http://madlib.net/mailman/listinfo/user
Picon

[MADlib-user] store an R data frame in GPDB

Hi,
   I am playing around with PivotalR package. I am able to read an existing table in GPDB and do some basic
manupulations using R. After that, I need to store the modified data.frame into GPDB as a table. How do I do
that? What is the function/API to store a data.frame into GPDB as a table?

Thanks,
Srini.

Gmane