...

1. Enable caching for a view

2. Add the index under Cache table indexes
   

   

3. Click Save (you’ll get a warning saying there was issue create the index)

   

ORA-00932: inconsistent datatypes: expected - got CLOB

Problem:

When running:

SELECT * FROM student_lifecycle.p_ps_crse_catalog

Get error:

P_PS_CRSE_CATALOG_ [VIRTUAL] [ERROR] 
P_PS_CRSE_CATALOG_ [JDBC WRAPPER] [ERROR]
P_PS_CRSE_CATALOG_#0 [JDBC ROUTE] [ERROR]  
Received exception with message 'ORA-00932: inconsistent datatypes: expected - got CLOB'

Cause:

Solution:

Possible Solution 1: Casting

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

Leads to error:

P_BV_PS_CRSE_CATALOG [VIRTUAL] [ERROR] 
P_BV_PS_CRSE_CATALOG [JDBC WRAPPER] [ERROR] 
P_BV_PS_CRSE_CATALOG#0 [JDBC ROUTE] [ERROR]  
Received exception with message 'ORA-22835: 
Buffer too small for CLOB to CHAR or BLOB to RAW conversion 
(actual: 4329, maximum: 4000)'

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.

User Guide

Anchor
denodo-user-guide denodo-user-guide

...