MySQL field varchar also in the analytical Storage as string not as CLOBAnswered
It's seems some times datav has problem to see varchar(100) as a string... it makes CLOB type out of it..
I want every varchar and char to be string and not CLOB
I have good news for you, I wasn't aware of it, but you can easily change the behaviour on the data source connection. By default, our MySQL connection will create strings as clobs, but when you add the following translator parameter by right clicking/edit on the datasource:
Since you are using native queries, the final translator parameters should look like this:
Please sign in to leave a comment.