- 51194 Views
- 5 replies
- 3 kudos
Driver is up but is not responsive, likely due to GC.
Hi all, "Driver is up but is not responsive, likely due to GC." This is the message in cluster event logs. Can anyone help me with this. What does GC means? Garbage collection? Can we control it externally?
- 51194 Views
- 5 replies
- 3 kudos
- 3 kudos
9/10 times GC is due to out of memory exceptions.@Jaron spark.catalog.clearCache() is not a configurable option, but rather a command to submit.
- 3 kudos
- 1114 Views
- 0 replies
- 0 kudos
dlt pipeline will not create live tables
I have created a dlt pipeline based four sql notebooks, each containing between 1 and 3 queries. Each query begins with "create or refresh live table ..." yet each one outputs a materialized view. I have tried deleting the materialized views and ru...
- 1114 Views
- 0 replies
- 0 kudos
- 775 Views
- 0 replies
- 0 kudos
Error truncating #REF with spark.read
Hello guysI am trying to read an excel file and even using PERMISSIVE mode, its truncating the records that contains #REF in any column Can anyone please help me on that? schema = StructType([\ StructField('Col1', DateType(), True), \ <-------...
- 775 Views
- 0 replies
- 0 kudos
- 2255 Views
- 2 replies
- 3 kudos
Resolved! Data prefixed by ' > '
HiI have a databricks table that has a column with a string datatypeWhen loading data, certain rows are prefixed by ' > 'Does anybody know what would cause this?It seems to be when the string is above a certain number of characters (around 200)Thanks
- 2255 Views
- 2 replies
- 3 kudos
- 3 kudos
It looks like default string data length exceeded and due to that its showing this kind of symbol and extra new line in the column.
- 3 kudos
- 2446 Views
- 2 replies
- 0 kudos
Service principal’s Microsoft Entra ID access token returns 400 when calling Databricks REST API
I'm using the following to call a Databricks REST API. When I use a PAT for access_token, everything works fine. When I use a Microsoft Entra ID access token, the response returns 400. The service principal has access to the workspace and is part of ...
- 2446 Views
- 2 replies
- 0 kudos
- 0 kudos
hello, Try to print the repose and see are you table to see the access_token in the payload else looks like access issue.Try to go to the workspace setting and grant token access permission to the service principle.Workspace > Setting
- 0 kudos
- 8334 Views
- 5 replies
- 5 kudos
SQL IDE Support
How to use a SQL IDE with Databricks SQLDatabricks provides SQL IDE support using DataGrip and DBeaver with Databricks SQL.Let us know in the comments if you've used DataDrip or DBeaver with Databricks! Let us know if there are any other SQL IDEs you...
- 8334 Views
- 5 replies
- 5 kudos
- 5 kudos
dbeaver is perfectly working fine but I fount one issue it wont show the correct error for query.
- 5 kudos
- 17238 Views
- 7 replies
- 0 kudos
Resolved! How to import a function to another notebook?
Could you please provide guidance on the correct way to dynamically import a Python module from a user-specific path in Databricks Repos? Any advice on resolving the ModuleNotFoundError would be greatly appreciated.udf_check_table_exists notebook:fro...
- 17238 Views
- 7 replies
- 0 kudos
- 3062 Views
- 1 replies
- 0 kudos
Terraform Error: Cannot create sql table context deadline
I am currently trying to deploy external parquet tables to the Databricks UC using terraform. However, for some tables I get the following error:Error: cannot create sql table: Post "https://[MASKED]/api/2.0/sql/statements/": context deadline exceede...
- 3062 Views
- 1 replies
- 0 kudos
- 0 kudos
Hey @Retired_mod,thanks for your reply and sorry for the late reply from my side. I couldn't fix the problem with the databricks terraform provider unfortunately. I now switched to using liquibase to deploy tables to databricks.
- 0 kudos
- 5821 Views
- 4 replies
- 0 kudos
CREATE WIDGETS in SQL Notebook attached to SQL Warehouse Doesn't Work.
I'm able to create and use widgets using the UI in my SQL notebooks, but they get lost quite frequently when the notebook is reset.There is documentation suggesting we can create widgets in code in SQL: https://learn.microsoft.com/en-us/azure/databri...
- 5821 Views
- 4 replies
- 0 kudos
- 0 kudos
Hi @JeremyH - can you please try adding like the below in your query and see if widgets are getting populated? {{parameter_name }}
- 0 kudos
- 1376 Views
- 0 replies
- 0 kudos
DatabricksUniForm
Hi Community members, I tried creating a Delta UniForm table using databricks notebook. I created a database without providing location. It took the dbfs default storage location. On top of that I was able to create a Delta UniForm table. Then I trie...
- 1376 Views
- 0 replies
- 0 kudos
- 2852 Views
- 2 replies
- 0 kudos
Resolved! Unzipping with Serverless Compute
HiI have started using serverless compute but have come across the limitation that I cannot use the local filesystem for temporarily storing the files and directories before moving them to where they need to be in adls.Does anyone have a way of unzip...
- 2852 Views
- 2 replies
- 0 kudos
- 0 kudos
Do you have the ability to make a Unity Catalog volume? You could use it as temporary storage before migrating the files to adls.
- 0 kudos
- 2270 Views
- 0 replies
- 0 kudos
notebook returns succeeded even if there is a failure in any of the command
I'm trying to run a notebook that has 14 commands from adf notebook activity, I'm writing the transformed data to a delta table in the last command. I'm handling the last command in try except block to handle errors, and raising error on exception.wh...
- 2270 Views
- 0 replies
- 0 kudos
- 5307 Views
- 2 replies
- 0 kudos
Resolved! Databricks to Oracle to Delete Rows
Hi Community! I’m working in a Fatabricks notebook and using the Oracle JDBC Thin Client connector to query and Oracle table, merge together and select specific rows from my dataframe and write those rows to a table back in Oracle. All of this works...
- 5307 Views
- 2 replies
- 0 kudos
- 0 kudos
This stack overflow post ran into the same issue, would be worth trying How to delete a record from Oracle Table in Python SQLAlchemy - Stack Overflow
- 0 kudos
- 16214 Views
- 3 replies
- 2 kudos
Incremental load from source; how to handle deletes
Small introduction; I'm a BI/Data developer, mostly working in MSSQL & DataFactory, coming from SSIS. Now I'm trying Databricks, to see if it works for me and my customers. I got enthusiastic by the video; https://www.youtube.com/watch?v=PIFL7W3DmaY&...
- 16214 Views
- 3 replies
- 2 kudos
- 3504 Views
- 1 replies
- 0 kudos
Spark Scala Vs Pyspark
With the release of spark connect and used defined table functions for pyspark, I wonder, what are the remaining advantages (if any) of using scala Spark?
- 3504 Views
- 1 replies
- 0 kudos
- 0 kudos
The main remaining advantages of Scala are performance as there will always be some interoperation overhead when using PySpark. While I don't have any stats on me, I would assume the differences in performance are negligible at this point until very ...
- 0 kudos
| User | Count |
|---|---|
| 1644 | |
| 793 | |
| 582 | |
| 349 | |
| 287 |
