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 <[email protected]> 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 > > > > >
