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
