Denodo with Cassandra as a source Not working

Hi, We are using Generic adapter for Cassandra source and it seems it does not support many data type conversion functions and also it does not read the cassandra date values to denodo. We are using the 2.1.2 cassndra driver and thats the one supporting/working with Denodo 6.0. Other later versions dont work and we are stuck that we are not able to use Cassandra data source. Can you help anyway to get this expedited or any solution around to get the cassandra data?
user
14-05-2018 13:37:30 -0400

1 Answer

Hi, Currently, Cassandra DB is not officially supported by Denodo Platform. Our product team is evaluating the possibility to provide support for Cassandra DB. To read the Cassandra DATE value into Denodo, I would suggest you follow the below workaround: * Create the JDBC Data Source. * While creating the base view using “Create from query” option, use CAST function to convert the DATE value to TIMESTAMP like below: `SELECT CAST(<date_column> as TIMESTAMP) FROM <tablename>` * To get the actual date as shown in the source, you can modify this field’s ‘[Source Type Properties](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/viewing_the_schema_of_a_base_view#viewing-the-schema-of-a-base-view)' from TIMESTAMP to DATE in the Output tab by clicking on the pencil icon available under Field Type column. Hope this helps!
Denodo Team
18-05-2018 02:41:17 -0400
You must sign in to add an answer. If you do not have an account, you can register here