topic Re: Equivalent of Oracle's CLOB in Databricks in Warehousing & Analytics

Equivalent of Oracle's CLOB in Databricks

VCA50380 — Tue, 21 Jan 2025 18:34:17 GMT

Dear all,

(migrating for an on-premise Oracle ...)

The question is in the subject: "What is the equivalent of Oracle's CLOB in Databricks" ?
I saw that the "string" type can go up to 50 thousands characters, which is quite good in most of our cases, but this would not cover all.
Also, I don't need this only as data-type for a column in a table, but currently in Oracle we are also concatenating or "aggregating" texts into some CLOB for a usage in a procedure / function, etc... What would be the paths to do the same in Databricks ?

Thanks!
Vinc

Re: Equivalent of Oracle's CLOB in Databricks

Alberto_Umana — Tue, 21 Jan 2025 19:17:51 GMT

Hi @VCA50380,

For concatenating or aggregating texts similar to how you use CLOBs in Oracle procedures or functions, you can use the concat function in Databricks. Here is an example of how you can concatenate strings:

SELECT concat(string1, string2, string3) AS concatenated_string
FROM your_table;

Re: Equivalent of Oracle's CLOB in Databricks

VCA50380 — Tue, 21 Jan 2025 23:36:19 GMT

Hello;
Thanks for the answer.
For the concatenation itself, it is not an issue.
My question is "is Databricks supporting something bigger than the 'string' data-type" ?
Thanks

Re: Equivalent of Oracle's CLOB in Databricks

VCA50380 — Tue, 04 Mar 2025 22:51:56 GMT

Hello,
Gemini gave me some answers. I'll investigate from there.

Thanks