Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 00F4D200C40 for ; Thu, 23 Mar 2017 18:31:12 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id F35EC160B68; Thu, 23 Mar 2017 17:31:11 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 741AC160B83 for ; Thu, 23 Mar 2017 18:31:10 +0100 (CET) Received: (qmail 5256 invoked by uid 500); 23 Mar 2017 17:31:09 -0000 Mailing-List: contact user-help@predictionio.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@predictionio.incubator.apache.org Delivered-To: mailing list user@predictionio.incubator.apache.org Received: (qmail 5246 invoked by uid 99); 23 Mar 2017 17:31:09 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Mar 2017 17:31:09 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id F2DD91AFB31 for ; Thu, 23 Mar 2017 17:31:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.08 X-Spam-Level: *** X-Spam-Status: No, score=3.08 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, HTML_OBFUSCATE_05_10=0.001, JMQ_TRACKER=0.5, KAM_HUGEIMGSRC=0.2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id DeP3eABLO_05 for ; Thu, 23 Mar 2017 17:31:04 +0000 (UTC) Received: from mail-it0-f42.google.com (mail-it0-f42.google.com [209.85.214.42]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 9E2225F2F1 for ; Thu, 23 Mar 2017 17:31:03 +0000 (UTC) Received: by mail-it0-f42.google.com with SMTP id w124so2263781itb.0 for ; Thu, 23 Mar 2017 10:31:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=QjHmhaNIFygTPrHM67WzUnGhDHpdnEbn9S3OAdehnyw=; b=KC8rea/eKLLY+5GpXy0ySQ/vO0ZTGs03KkWvT41QIn6/EO5/cqVD023Q232cIQcnlB 75P1sib/aPO3UsxCTfkuZK4D4vQKYIEERSEYXjbn3MmZUQlYDjSCxXsutI8sbNiRkAoZ izrE2CiZ978oL4RA0WEVzPlOJymVLgoXVR7O7ZDz1efjKM3aHisjWu4blG4TQmZCzQ1E Dkx8sPYUjsJx45jk9FkAOOYYs/DkIqCEib6fkmfP0MNsnhlY1mjXAZ1gJtWkYEQSUjJG hwu+Ioi0QYvXmja2xQMx7fLBaxnTjRYX6AueW3vWO6nBmaqycWFhG3iL72ijt249T+h/ +4/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=QjHmhaNIFygTPrHM67WzUnGhDHpdnEbn9S3OAdehnyw=; b=kNdrNh1L0LPAoE9r81N1PVuriw/957DnK3QTU61hfEwp9dRRpCy1OFH6VYIS+m/E4T jAGLJ4EJgDE6O82WbFjN+UHV1cNOWdI+BquPb7pyaEiN3cDOcVResTqLXeL4xf760NKG kVQK9PFyBWRtRdp2PXQDAVsxAjMSuzDUGzaTe2E6EgJXTX7Tolblp7GrTIwTsWCrN3vq cwLlwe0JgFArnmSYYu6ATU/XaMLtTNzHnACbkrQ4INrXgmwKwXssrpCxAVft4uPrRxMy ZIqBclSGBm1giCx5HlQNydaB7G1Wf8ALJCbrPKlJOYmMlTPBdMF787HY7Ji/qEBaVSlw snJw== X-Gm-Message-State: AFeK/H2mw6fRqCrb4EP7Klp/2vXpzpS4S7bv/gXTZ/ltVXV+dXxfhh4YfHS54x0gNRZR1gROOiLDovjcKS0jQg== X-Received: by 10.36.185.16 with SMTP id w16mr14083861ite.79.1490289857245; Thu, 23 Mar 2017 10:24:17 -0700 (PDT) MIME-Version: 1.0 Received: by 10.79.143.28 with HTTP; Thu, 23 Mar 2017 10:24:16 -0700 (PDT) In-Reply-To: References: <1467BA7D-F34A-4F7B-9BC7-54B55ECF256A@occamsmachete.com> From: Marius Rabenarivo Date: Thu, 23 Mar 2017 21:24:16 +0400 Message-ID: Subject: Re: Need a Suggessations To: user@predictionio.incubator.apache.org Content-Type: multipart/alternative; boundary=f403045d9a6e8db748054b692509 archived-at: Thu, 23 Mar 2017 17:31:12 -0000 --f403045d9a6e8db748054b692509 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You have to change the config in pio-env.sh to use MYSQL instead of PGSQL In the pasted response above I can read Verifying Meta Data Backend (Source: PGSQL)... 2017-03-23 21:19 GMT+04:00 Vaghawan Ojha : > Yes following is the response of pio status > > sudo PredictionIO-0.10.0-incubating/bin/pio status > [INFO] [Console$] Inspecting PredictionIO... > [INFO] [Console$] PredictionIO 0.10.0-incubating is installed at > /home/ekbana-php/Downloads/apache-predictionio-0.10.0- > incubating/PredictionIO-0.10.0-incubating > [INFO] [Console$] Inspecting Apache Spark... > [INFO] [Console$] Apache Spark is installed at /home/ekbana-php/Downloads= / > apache-predictionio-0.10.0-incubating/PredictionIO-0.10. > 0-incubating/vendors/spark-1.5.1-bin-hadoop2.6 > [INFO] [Console$] Apache Spark 1.5.1 detected (meets minimum requirement > of 1.3.0) > [INFO] [Console$] Inspecting storage backend connections... > [INFO] [Storage$] Verifying Meta Data Backend (Source: PGSQL)... > [ERROR] [Console$] Unable to connect to all storage backends successfully= . > The following shows the error message from the storage backend. > [ERROR] [Console$] FATAL: password authentication failed for user "pio" > (org.postgresql.util.PSQLException) > [ERROR] [Console$] Dumping configuration of initialized storage backend > sources. Please make sure they are correct. > [ERROR] [Console$] Source Name: PGSQL; Type: jdbc; Configuration: URL -> > jdbc:postgresql://localhost/pio, PASSWORD -> pio, TYPE -> jdbc, USERNAME > -> pio > > Which says that postgresql authentication failed. Ok I'm trying to go for > postgresql this time instead of mysql, I don't wanna lose much time > fighting with this two sql. I can use any of them, it just need to work. > > Thanks > > On Thu, Mar 23, 2017 at 11:00 PM, Marius Rabenarivo < > mariusrabenarivo@gmail.com> wrote: > >> How do you start the services? >> >> The is a script named pio-start-all in $PIO_HOME/bin to do it you can >> check it to see what you have to start before using pio commands. >> >> Try doing pio status to check if all required services are running >> properly. >> >> 2017-03-23 21:04 GMT+04:00 Vaghawan Ojha : >> >>> Yes that's what I wanted to do, but couldn't come out to configure it. >>> No matter how much I change in the pio-env.sh.template, when I start th= e >>> event server it always pops up with the posgresql error of authenticati= on. >>> >>> I even tried with posgresql and it shows the same things. Party >>> something to do with my dumbness I guess. >>> >>> Thank you very much Marius. >>> >>> On Thu, Mar 23, 2017 at 10:39 PM, Marius Rabenarivo < >>> mariusrabenarivo@gmail.com> wrote: >>> >>>> You can use MySQL as event store but you need ElasticSearch to store >>>> the model metadata and index used by UR Engine. >>>> >>>> 2017-03-23 20:25 GMT+04:00 Vaghawan Ojha : >>>> >>>>> But I wanted to use mysql as default. Should I switch it? I can do >>>>> that, but I was just wondering since the documentation says that I co= uld >>>>> use mysql. >>>>> >>>>> On Thu, Mar 23, 2017 at 10:03 PM, Marius Rabenarivo < >>>>> mariusrabenarivo@gmail.com> wrote: >>>>> >>>>>> I think pio-start-all start PostgreSQL by default >>>>>> >>>>>> 2017-03-23 20:16 GMT+04:00 Vaghawan Ojha : >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Yes I did that but still I get the same output, it's weird. >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> On Thu, Mar 23, 2017 at 10:00 PM, Marius Rabenarivo < >>>>>>> mariusrabenarivo@gmail.com> wrote: >>>>>>> >>>>>>>> You have to change this section >>>>>>>> >>>>>>>> # Default is to use PostgreSQL >>>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_NAME=3Dpio_meta >>>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_SOURCE=3DPGSQL >>>>>>>> >>>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_NAME=3Dpio_event >>>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_SOURCE=3DPGSQL >>>>>>>> >>>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_NAME=3Dpio_model >>>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_SOURCE=3DPGSQL >>>>>>>> >>>>>>>> Put MYSQL in place of PGSQL >>>>>>>> >>>>>>>> 2017-03-23 20:07 GMT+04:00 Vaghawan Ojha : >>>>>>>> >>>>>>>>> Hi, Thank you! >>>>>>>>> >>>>>>>>> I came into further more confusion here, actually I installed >>>>>>>>> prediction IO version 0.10.0 from here http://predictionio.incub >>>>>>>>> ator.apache.org/install/install-sourcecode/ and have been >>>>>>>>> fighting to configure mysql as a storage in my local linux machin= e. >>>>>>>>> >>>>>>>>> But I see there is a different documentation of installing in >>>>>>>>> actionml website, I'm not sure for which I would have to go. Curr= ently >>>>>>>>> there is no "pio-env.sh". file inside conf folder however there >>>>>>>>> is pio-env.sh.template file. I commented the pgsql section and un= commented >>>>>>>>> the mysql section with the username and password, but whenever I = do . sudo >>>>>>>>> PredictionIO-0.10.0-incubating/bin/pio eventserver there seems to >>>>>>>>> be an error that says that authentication failed with pgsql, howe= ver I >>>>>>>>> don't want to use pgsql. >>>>>>>>> >>>>>>>>> # Storage Repositories >>>>>>>>> >>>>>>>>> # Default is to use PostgreSQL >>>>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_NAME=3Dpio_meta >>>>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_SOURCE=3DPGSQL >>>>>>>>> >>>>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_NAME=3Dpio_event >>>>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_SOURCE=3DPGSQL >>>>>>>>> >>>>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_NAME=3Dpio_model >>>>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_SOURCE=3DPGSQL >>>>>>>>> >>>>>>>>> # Storage Data Sources >>>>>>>>> >>>>>>>>> # PostgreSQL Default Settings >>>>>>>>> # Please change "pio" to your database name in >>>>>>>>> PIO_STORAGE_SOURCES_PGSQL_URL >>>>>>>>> # Please change PIO_STORAGE_SOURCES_PGSQL_USERNAME and >>>>>>>>> # PIO_STORAGE_SOURCES_PGSQL_PASSWORD accordingly >>>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_TYPE=3Djdbc >>>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_URL=3Djdbc:postgresql://localhost/pio >>>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_USERNAME=3Dpio >>>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_PASSWORD=3Dpio >>>>>>>>> >>>>>>>>> # MySQL Example >>>>>>>>> PIO_STORAGE_SOURCES_MYSQL_TYPE=3Djdbc >>>>>>>>> PIO_STORAGE_SOURCES_MYSQL_URL=3Djdbc:mysql://localhost/pio >>>>>>>>> PIO_STORAGE_SOURCES_MYSQL_USERNAME=3Droot >>>>>>>>> PIO_STORAGE_SOURCES_MYSQL_PASSWORD=3Droot >>>>>>>>> >>>>>>>>> >>>>>>>>> This is how the pio-env.sh.template looks like. And again when I >>>>>>>>> visited the actionml site, it suggests that I do have to have >>>>>>>>> ELASTICSEARCH. but prediction.io site doesn't tells us the same. >>>>>>>>> Which one should I follow and where would I find the current work= ing >>>>>>>>> version of installation guide. I actually wanaa use prediction.io >>>>>>>>> in my production shortly after I implemented in local. >>>>>>>>> >>>>>>>>> Please help me, thank you very much for your help, I appreciate i= t >>>>>>>>> so much. >>>>>>>>> Vaghawan >>>>>>>>> >>>>>>>>> >>>>>>>>> On Thu, Mar 23, 2017 at 9:27 PM, Pat Ferrel >>>>>>>> > wrote: >>>>>>>>> >>>>>>>>>> Since PIO has moved to Apache, the namespace of PIO code changed >>>>>>>>>> and so all templates need to be updated. None of the ones in >>>>>>>>>> https://github.com/PredictionIO/ >>>>>>>>>> will >>>>>>>>>> work with Apache PIO. For the upgraded UR see: >>>>>>>>>> https://github.com/actionml/universal-recommender Docs for the >>>>>>>>>> UR are here: http://actionml.com/docs/ur >>>>>>>>>> >>>>>>>>>> Also look on the Template gallery page here for a description of >>>>>>>>>> template status. Some have not been moved to the new namespace a= nd >>>>>>>>>> converted to run with PIO but this is pretty easy to do yourself= . >>>>>>>>>> http://predictionio.incubator.apache.org/gallery/t >>>>>>>>>> emplate-gallery/ >>>>>>>>>> >>>>>>>>>> user_id, product_id and purchase_date is all you need to use any >>>>>>>>>> recommender. If you plan to gather other events in the future, u= se the UR. >>>>>>>>>> As far as item or user based recommendations, the UR will give e= ither based >>>>>>>>>> on the query with the same data and model, as some others will d= o. The UR >>>>>>>>>> allows you to mix both types in a single query, which may be use= ful with >>>>>>>>>> small amounts of individual user data. >>>>>>>>>> >>>>>>>>>> Also the accepted wisdom about this it to put item-based recs on >>>>>>>>>> item detail pages, and user-based recs elsewhere, when you don= =E2=80=99t have an >>>>>>>>>> item to base recs on, or in another placement on any page. >>>>>>>>>> >>>>>>>>>> You can have many different placements of recs in any page by >>>>>>>>>> changing the queries. This is how Netflix gets rows and rows of = specialized >>>>>>>>>> recs for different things all based on the same data. The UR que= ries are >>>>>>>>>> quite flexible. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Mar 23, 2017, at 7:08 AM, Vaghawan Ojha >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> I've been trying to deploy a recommendation system using >>>>>>>>>> https://github.com/PredictionIO/template-scala-paralle >>>>>>>>>> l-universal-recommendation. >>>>>>>>>> >>>>>>>>>> I've purchase history of user something like this: >>>>>>>>>> user_id, product_id and purchase_date, so I will be using user_i= d >>>>>>>>>> and product_id to determine the recommendation. I'm not sure if = I would be >>>>>>>>>> able to customize the default even parameter. >>>>>>>>>> >>>>>>>>>> Do you have any suggestions like which template would be more >>>>>>>>>> suitable for my problem. I don't have data like rating or view s= tate, I >>>>>>>>>> only have data about user and product they purchased. I need som= ething like >>>>>>>>>> item based similarity as well as user based item similarity. >>>>>>>>>> >>>>>>>>>> Any help would be great >>>>>>>>>> >>>>>>>>>> Thank you >>>>>>>>>> Vaghawan >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > --f403045d9a6e8db748054b692509 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You have to change the config in pio-env.sh to use MY= SQL instead of PGSQL

In the pasted response above I can read V= erifying Meta Data Backend (Source: PGSQL)...

2017-03-23 21:19 GMT+04:00 Vaghawan Ojha = <vaghawan781@gmail.com>:
Yes following is the response of pio status

sudo PredictionIO-0.10.0-incubating/bin/pio status
<= div>[INFO] [Console$] Inspecting PredictionIO...
[INFO] [Console$= ] PredictionIO 0.10.0-incubating is installed at /home/ekbana-php/Downloads= /apache-predictionio-0.10.0-incubating/PredictionIO-0.10.0-i= ncubating
[INFO] [Console$] Inspecting Apache Spark...
= [INFO] [Console$] Apache Spark is installed at /home/ekbana-php/Downloads/<= wbr>apache-predictionio-0.10.0-incubating/PredictionIO-0.10.0-inc= ubating/vendors/spark-1.5.1-bin-hadoop2.6
[INFO] [Console$] = Apache Spark 1.5.1 detected (meets minimum requirement of 1.3.0)
= [INFO] [Console$] Inspecting storage backend connections...
[INFO= ] [Storage$] Verifying Meta Data Backend (Source: PGSQL)...
[ERRO= R] [Console$] Unable to connect to all storage backends successfully. The f= ollowing shows the error message from the storage backend.
[ERROR= ] [Console$] FATAL: password authentication failed for user "pio"= (org.postgresql.util.PSQLException)
[ERROR] [Console$] Dump= ing configuration of initialized storage backend sources. Please make sure = they are correct.
[ERROR] [Console$] Source Name: PGSQL; Type: jd= bc; Configuration: URL -> jdbc:postgresql://localhost/pio, PASSWORD= -> pio, TYPE -> jdbc, USERNAME -> pio

<= div>Which says that postgresql authentication failed. Ok I'm trying to = go for postgresql this time instead of mysql, I don't wanna lose much t= ime fighting with this two sql. I can use any of them, it just need to work= .

Thanks

<= div class=3D"gmail_quote">On Thu, Mar 23, 2017 at 11:00 PM, Marius Rabenari= vo <mariusrabenarivo@gmail.com> wrote:
How do you start the servi= ces?

The is a script named pio-start-all in $PIO_HOME/bin to d= o it you can check it to see what you have to start before using pio comman= ds.

Try doing pio status to check if all required services are= running properly.

2017-03-23 21:04 GMT+04:00 Vaghawan Ojha <vaghawan78= 1@gmail.com>:
Yes that's what I wanted to do, but couldn't come out to config= ure it. No matter how much I change in the pio-env.sh.template, when I star= t the event server it always pops up with the posgresql error of authentica= tion.=C2=A0

I even tried with posgresql and it shows the= same things. Party something to do with my dumbness I guess.=C2=A0

Thank you very much Marius.=C2=A0

On Thu, Mar 23, 2017= at 10:39 PM, Marius Rabenarivo <mariusrabenarivo@gmail.com&g= t; wrote:
You can= use MySQL as event store but you need ElasticSearch to store the model met= adata and index used by UR Engine.

2017-03-23 20:25 GMT+04:00 = Vaghawan Ojha <vaghawan781@gmail.com>:
But I wanted to use mysql as default. Sho= uld I switch it? I can do that, but I was just wondering since the document= ation says that I could use mysql.=C2=A0

On Thu, Mar 23, 2017 at 10= :03 PM, Marius Rabenarivo <mariusrabenarivo@gmail.com> wrote:
I think pio-s= tart-all start PostgreSQL by default
=

2017-03-23 20:16 = GMT+04:00 Vaghawan Ojha <vaghawan781@gmail.com>:
Hi,

Yes I di= d that but still I get the same output, it's weird.=C2=A0
Thanks

On Thu, Mar 23, 2017 at 10:00 P= M, Marius Rabenarivo <mariusrabenarivo@gmail.com> w= rote:
You have to change= this section

# Default is to use PostgreSQL
PI= O_STORAGE_REPOSITORIES_METADATA_NAME=3Dpio_meta
PIO_STORAGE_= REPOSITORIES_METADATA_SOURCE=3DPGSQL

PIO_STOR= AGE_REPOSITORIES_EVENTDATA_NAME=3Dpio_event
PIO_STORAGE_REPO= SITORIES_EVENTDATA_SOURCE=3DPGSQL

PIO_STORAGE= _REPOSITORIES_MODELDATA_NAME=3Dpio_model
PIO_STORAGE_= REPOSITORIES_MODELDATA_SOURCE=3DPGSQL

Put MYSQL in place of PGS= QL

2017-03-23 20:07 GMT+04:00 Vaghawan = Ojha <vaghawan781@gmail.com>:
Hi, Thank you!=C2=A0

I came in= to further more confusion here, actually I installed prediction IO version = 0.10.0 from here=C2=A0http://predictionio.incubator.apache.org/install/install-sourcecode/ =C2=A0and have been f= ighting to configure mysql as a storage in my local linux machine.=C2=A0

But I see there is a different documentation of inst= alling in actionml website, I'm not sure for which I would have to go. = Currently there is no "pio-env.sh". =C2=A0file inside conf folder however= there is pio-env.sh.template file. I commented the pgsql section and uncom= mented the mysql section with the username and password, but whenever I do = .=C2=A0sudo PredictionIO-0.10.0-incubating/bin/pio eventserver there s= eems to be an error that says that authentication failed with pgsql, howeve= r I don't want to use pgsql.=C2=A0

# Stor= age Repositories

# Default is to use PostgreSQL
PIO_STORAGE_REPOSITORIES_METADATA_NAME=3Dpio_meta
PI= O_STORAGE_REPOSITORIES_METADATA_SOURCE=3DPGSQL

PIO_STORAGE_REPOSITORIES_EVENTDATA_NAME=3Dpio_event
PIO_ST= ORAGE_REPOSITORIES_EVENTDATA_SOURCE=3DPGSQL

P= IO_STORAGE_REPOSITORIES_MODELDATA_NAME=3Dpio_model
PIO_STORA= GE_REPOSITORIES_MODELDATA_SOURCE=3DPGSQL

# St= orage Data Sources

# PostgreSQL Default Settings
# Please change "pio" to your database name in PIO_STORA= GE_SOURCES_PGSQL_URL
# Please change PIO_STORAGE_SOURCES_PGSQL_US= ERNAME and
# PIO_STORAGE_SOURCES_PGSQL_PASSWORD accordi= ngly
#PIO_STORAGE_SOURCES_PGSQL_TYPE=3Djdbc
#PIO_S= TORAGE_SOURCES_PGSQL_URL=3Djdbc:postgresql://localhost/pio
<= div>#PIO_STORAGE_SOURCES_PGSQL_USERNAME=3Dpio
#PIO_STORAGE_S= OURCES_PGSQL_PASSWORD=3Dpio

# MySQL Example
=C2=A0PIO_STORAGE_SOURCES_MYSQL_TYPE=3Djdbc
=C2=A0P= IO_STORAGE_SOURCES_MYSQL_URL=3Djdbc:mysql://localhost/pio
= =C2=A0PIO_STORAGE_SOURCES_MYSQL_USERNAME=3Droot
=C2=A0PIO_ST= ORAGE_SOURCES_MYSQL_PASSWORD=3Droot



On Thu, Mar 23, 2017 at 9:27 PM, Pat Ferrel <<= a href=3D"mailto:pat@occamsmachete.com" target=3D"_blank">pat@occamsmachete= .com> wrote:
Since PIO has moved to Apache, the namespace of PIO c= ode changed and so all templates need to be updated. None of the ones in=C2= =A0=C2=A0https://github.com/PredictionIO/=C2=A0will work with Apache PIO. For the upgraded UR see:=C2=A0<= a href=3D"https://github.com/actionml/universal-recommender" target=3D"_bla= nk">https://github.com/actionml/universal-recommender Docs for the= UR are here:=C2=A0http://actionml.com/docs/ur=C2=A0

Also look o= n the Template gallery page here for a description of template status. Some= have not been moved to the new namespace and converted to run with PIO but= this is pretty easy to do yourself.=C2=A0http://pred= ictionio.incubator.apache.org/gallery/template-gallery/

user_id, product_id and purchase_date is all you need to = use any recommender. If you plan to gather other events in the future, use = the UR. As far as item or user based recommendations, the UR will give eith= er based on the query with the same data and model, as some others will do.= The UR allows you to mix both types in a single query, which may be useful= with small amounts of individual user data.

Also = the accepted wisdom about this it to put item-based recs on item detail pag= es, and user-based recs elsewhere, when you don=E2=80=99t have an item to b= ase recs on, or in another placement on any page.

= You can have many different placements of recs in any page by changing the = queries. This is how Netflix gets rows and rows of specialized recs for dif= ferent things all based on the same data. The UR queries are quite flexible= .


On Mar 23, 2017, at 7:08 AM, Vaghawan Ojha &= lt;vaghawan781@g= mail.com> wrote:












--f403045d9a6e8db748054b692509--