after upgrading from Hue 3.7 (CDH 5.4) to HUE 3.9 (CDH 5.5) -
I have a problem when searching in the box of queries history.
After some typing I get "Server Error (500)".
In the logs I found out that it is error of ora-06502 (PL/SQL: "numeric or value error: character string buffer too small"), according to the info it happens when trying to do execute an sql query in the backend.
The Hue 3.9 DB is ORACLE (history migrated from sqlite in previous version - 3.7).
@romain I love your movies...
Hi romain and everybody,
the solution suggested
"return "DBMS_LOB.SUBSTR(%s, 4000)" is already in the python code of my file, but still I have this bug.
Log file for Server Error (500) when executing sql of get count:
.5.1-1.cdh5.5.1.p0.11/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/backends/oracle/base.py", line number 846 in execute