Yellowfin on AWS Redshift
18 June, 2013
Has anyone tried using Yellowfin on top of AWS Redshift? Any tips/pointers?
Hi,
We do have some clients using Redshift, and it seems that users can connect to Amazon Redshift using the standard PostgreSQL JDBC or ODBC drivers .
So it should just work.
Please let us know if you run into any issues.
Regards,
David
We do have some clients using Redshift, and it seems that users can connect to Amazon Redshift using the standard PostgreSQL JDBC or ODBC drivers .
So it should just work.
Please let us know if you run into any issues.
Regards,
David
It does not work:
ERROR: SQL command "CREATE SEQUENCE NextDocumentSequence START 5000" not supported.
ERROR: SQL command "CREATE INDEX xpkActiveSession ON activesession ( SessionId )" not supported on Redshift tables.
etc etc
Redshift supports only a limited set of PostreSQL features. Reading data from Redshift is fine, but installing Yellowfin on it is not possible.
ERROR: SQL command "CREATE SEQUENCE NextDocumentSequence START 5000" not supported.
ERROR: SQL command "CREATE INDEX xpkActiveSession ON activesession ( SessionId )" not supported on Redshift tables.
etc etc
Redshift supports only a limited set of PostreSQL features. Reading data from Redshift is fine, but installing Yellowfin on it is not possible.
Hi,
Sorry, it's my fault for not clarifying.
Your findings are correct. Yellowfin cannot be installed onto Redshift, it can only be used to report from.
Sorry for any confusion caused.
Regards,
David
Sorry, it's my fault for not clarifying.
Your findings are correct. Yellowfin cannot be installed onto Redshift, it can only be used to report from.
Sorry for any confusion caused.
Regards,
David