Databricks Community

dtabass · 05-29-2022

The following doesn't work for me:%sql SELECT user_id, array_size(education) AS edu_cnt FROM users ORDER BY edu_cnt DESC LIMIT 10; I get an error saying: Error in SQL statement: AnalysisException: Undefined function: array_size. This function is nei...

dtabass · 05-29-2022

When using the Community Edition, I'm trying to find a place in the UI where I can browse the files that I've uploaded to dbfs. How/where can I do that? When I try to view them from the Data sidebar I see nothing, yet I know they're there, as if I us...

dtabass · 05-30-2022

Thanks! I was incorrectly thinking the Community Edition clusters would be whatever the latest was; not the case, what I was getting was older (dated back to a year or so ago when I was last working with Spark). I can use the functions now. 

dtabass · 05-30-2022

FURTHER UPDATE: I am intermittently getting that persistent error - it's definitely a bug of some sort and I need to know how to make it disappear.

dtabass · 05-30-2022

UPDATE: Tried clearing browser history and cached stuff; no change. Tried restarting Chrome, bingo. It's working now and I can browse my data files. Thx!SUGGESTION: Enable this by default for community edition users since we are always going to ...

dtabass · 05-30-2022

Thanks! I'm in the community edition so I didn't realize that some things like that would be disabled but enable-able. Found it and enabled it.BUT NOW - I am getting (for the last 24 hours or so, independent of having enabled this) the following pers...

Databricks Community

User Stats

User Activity

How does one access/use SparkSQL functions like array_size?

How/where can I see a list of my dbfs files?

Re: How does one access/use SparkSQL functions like array_size?

Re: How/where can I see a list of my dbfs files?

Re: How/where can I see a list of my dbfs files?

Re: How/where can I see a list of my dbfs files?