...

https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/type_conversion_functions#cast

https://community.denodo.com/answers/question/details?questionId=90670000000XcumAAC

select CAST(bv_ps_crse_catalog.descrlong AS text) AS text_column
from bv_ps_crse_catalog

...

Possible Solution 2: Server Config

https://community.denodo.com/answers/question/details?questionId=906Du00000001Q7IAI&title=About+Oracle+Clob+columns+shown+properly+in+Denodo+when+group+by

Open Data Source (only for VDP Administration Tool) > Configuration > Source Configuration > Delegate group by clause = No

This would slow down performance as well as create extra load on the denodo servers by not pushing the query to oracle.

Recover from a DROP CASCADE

DROP CASCADE is a very dangerous command that will not only drop the view listed, but all if it’s dependents as well. The dependents list can be very long, and recovery can be very cumbersome. Try to avoid the DROP command at all costs, especially DROP CASCADE.

In the event that you accidentally execute DROP CASCADE, follow these steps to recover.

1. Get a list of all dependents of the view dropped and their cache status

   Code Block
   select   distinct vd.view_database_name, vd.view_name, v.cache_status from view_dependencies() vd left join get_views() v on v.name = vd.view_name and v.database_name = vd.view_database_name where dependency_name = 'VIEW_NAME' and private_view = 'false';

2. Get the latest VQL backup for the environment where the drop occured. This could be a development backup in S3, or a deployment backup. See the sections above for their locations.

3. Assemble a VQL file containing the relevent CREATE, ALTER, CHOWN, and ALTER ROLE statements for each view. Be sure to include CONNECT DATABASE and CLOSE; statements for each database.

4. Create a revision in Solution Manager, validate and deploy.

User Guide

Anchor
denodo-user-guide denodo-user-guide

A user-facing guide has been created that contains all information relelvant relevant to non-Admins. The guide is available here: Denodo User Guide

...