cancel
Showing results for 
Search instead for 
Did you mean: 
Dhruv-22
Contributor
since ‎02-08-2024
Tuesday

User Stats

  • 20 Posts
  • 1 Solutions
  • 1 Kudos given
  • 2 Kudos received

User Activity

I have a table which has a column of data type 'bigint'. While overwriting it with new data, given that I do full loads, I used 'mergeSchema' to handle schema changes. The new data's datatype was int. I thought mergeSchema can easily handle that, but...
The following statement gives different outputs in different computes.In Databricks, 15.4 LTS%sqlSELECT typeof(coalesce(5, '6'));-- OutputstringIn Serverless, environment version 4%sqlSELECT typeof(coalesce(5, '6'));-- OutputbigintThere are other cas...
I was reading the architecture of Databricks from the following video. And I came through this If notebooks are stored in control plane on the databricks cloud account, then does that mean databricks allocates storage for the client free of cost? I j...
I've posted the same question on stackoverflow (link) as well. I will post any solution I get there.I was trying to understand using many columns in the IN query and came across this statement. SELECT (1, 2) IN (SELECT c1, c2 FROM VALUES(1, 2), (3, 4...
I was reading the data type rules and found about least common type.I have a doubt. What is the least common type of STRING and INT? The referred link gives the following example saying the least common type is BIGINT.-- The least common type between...
Kudos from
Kudos given to