predictionio-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Szeto <don...@apache.org>
Subject Re: PredictionIO with redshift event source | Unable to configure
Date Thu, 06 Oct 2016 18:22:56 GMT
Hi Amal,

Since you are using Redshift and their JDBC driver probably collides with
those provided from Postgres, you might have to use a different data
storage for your meta data and model data.

Regards,
Donald

On Wednesday, October 5, 2016, amal kumar <amal.kmr.singh@gmail.com> wrote:

> Hello,
>
> I am trying to configure Redshift for the Event Source for storing the
> Event Data. Using the reference below.
>
> http://predictionio.incubator.apache.org/system/anotherdatastore/
>
>
> https://groups.google.com/forum/#!topic/predictionio-user/rAWMUalzQf4
>
>
> METADATA_SOURCE ->Postgresql
> EVENTDATA_SOURCE -> Redshift
> MODELDATA_SOURCE -> Postgresql
>
> *pio app new MyApp1 *is throwing exception
>
> *[ERROR] [ActiveSession] Failed preparing the statement (Reason:
> [Amazon](500310) Invalid operation: relation "pio_meta_apps" does not
> exist;):*
> *  SELECT id, name, description FROM pio_meta_apps WHERE name = ?*
> *Exception in thread "main" java.sql.SQLException: [Amazon](500310)
> Invalid operation: relation "pio_meta_apps" does not exist;*
>
>
> Seems, *pio status* didn't create the pio_meta_apps in redshift.
>
>
>
>
> Hence, I created the table manually in redshift, usin the ddl below
> create table if not exists pio_meta_apps (id bigint identity(1, 1),name
> varchar(1000),description varchar(1000));
>
>
> *pio app new MyApp1 *is still throwing exception:
> *[ERROR] [ActiveSession] Failed preparing the statement (Reason:
> [Amazon][JDBC](10220) Driver not capable.):*
> *      insert into pio_meta_apps (name, description) values(?, ?)*
>
>
> Can you please help and suggest if redshift can be configured as Event
> Source? Any documentation would help.
>
>
>
> Thanks,
> Amal Kumar
>
>
>
>
>

Mime
View raw message