cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 
Data + AI Summit 2024 - Data Engineering & Streaming

Forum Posts

amitkmaurya
by Contributor
  • 1729 Views
  • 2 replies
  • 4 kudos

Resolved! How to increase executor memory in Databricks jobs

May be I am new to Databricks that's why I have confusion.Suppose I have worker memory of 64gb in Databricks job max 12 nodes...and my job is failing due to Executor Lost due to 137 (OOM if found on internet).So, to fix this I need to increase execut...

  • 1729 Views
  • 2 replies
  • 4 kudos
Latest Reply
amitkmaurya
Contributor
  • 4 kudos

Hi @raphaelblg ,I have solved this issue. Yes, in my case data skewness was the issue that was causing this executor OOM, so adding repartition just before writing resolved this skewness. I didn't change any workers or driver memory.Thanks for your h...

  • 4 kudos
1 More Replies
amitkmaurya
by Contributor
  • 2514 Views
  • 2 replies
  • 2 kudos

Resolved! Databricks job keep getting failed due to executor lost.

Getting following error while saving a dataframe partitioned by two columns.Job aborted due to stage failure: Task 5774 in stage 33.0 failed 4 times, most recent failure: Lost task 5774.3 in stage 33.0 (TID 7736) (13.2.96.110 executor 7): ExecutorLos...

Data Engineering
databricks jobs
spark
  • 2514 Views
  • 2 replies
  • 2 kudos
Latest Reply
amitkmaurya
Contributor
  • 2 kudos

Hi, I have solved the problem with the same workers and driver.In my case data skewness was the problem.Adding repartition to the dataframe just before writing, evenly distributed the data across the nodes and this stage failure resolved.Thanks @Kani...

  • 2 kudos
1 More Replies
Mirza1
by New Contributor
  • 578 Views
  • 1 replies
  • 0 kudos

Error while Running a Table

Hi All,I am trying to run table schema and facing below error.Error - AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to alter table.com.databricks.backend.common.rpc.SparkDriverExceptions$SQLExecutionException: org.apache...

  • 578 Views
  • 1 replies
  • 0 kudos
Latest Reply
Ayushi_Suthar
Honored Contributor
  • 0 kudos

Hi @Mirza1 , Greetings!  Can you please confirm if it is an ADLS gen2 table? If yes then can you please give it a try to run the table schema by setting spark configs for gen2 at the cluster level?   You can refer to this document to set the spark co...

  • 0 kudos
Silabs
by New Contributor II
  • 2939 Views
  • 3 replies
  • 4 kudos

Resolved! Set up connection to on prem sql server

Ive just set up our databricks environment. Hosted in AWS. We have an on prem SQL server and would like to connect . How can i do that?

  • 2939 Views
  • 3 replies
  • 4 kudos
Latest Reply
Yeshwanth
Honored Contributor
  • 4 kudos

@Silabs good day! To connect your Databricks environment (hosted on AWS) to your on-premise SQL server, follow these steps: 1. Network Setup: Establish a connection between your SQL server and the Databricks virtual private cloud (VPC) using VPN or A...

  • 4 kudos
2 More Replies
dbengineer516
by New Contributor III
  • 2002 Views
  • 4 replies
  • 2 kudos

Resolved! Git Integration with Databricks Query Files and Azure DevOps

I’ve been trying to develop a solution for our team to be able to have Git integration between Databricks and Azure DevOps. However, the “query” file type/workspace item on Databricks can’t be committed and pushed to a Git repo, only regular file typ...

  • 2002 Views
  • 4 replies
  • 2 kudos
Latest Reply
Yeshwanth
Honored Contributor
  • 2 kudos

@dbengineer516 Good day! As per the Databricks documentation, only certain Databricks asset types are supported by Git folders. These include Files, Notebooks, and Folders. Databricks asset types that are currently not supported in Git folders includ...

  • 2 kudos
3 More Replies
SreeG
by New Contributor II
  • 865 Views
  • 2 replies
  • 0 kudos

Error Reading Kafka message into Azure Databricks

TeamI am trying to test the connection to Kafka broker from Azure Databricks. Telnet and IP is successful.When I am trying to read the data, I am getting "Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid cer...

Data Engineering
Azure DB
kafka
  • 865 Views
  • 2 replies
  • 0 kudos
Latest Reply
SreeG
New Contributor II
  • 0 kudos

Had to hold on this testing. But, when I get a chance to work on this, I will update my findings. Thank you!

  • 0 kudos
1 More Replies
PerformanceTest
by New Contributor
  • 639 Views
  • 1 replies
  • 0 kudos

Databricks to Jmteter connectivity issue

Hi All, we are conducting Databricks performance test with Apache Jmeter, after configuring JDBC config element getting below error Cannot create PoolableConnectionFactory ([Databricks][JDBCDriver](700120) Host xxxxx-xxxxx-xxxx.cloud.databricks.com c...

  • 639 Views
  • 1 replies
  • 0 kudos
Latest Reply
shan_chandra
Esteemed Contributor
  • 0 kudos

@PerformanceTest - can you please check your DB workspace terraform script to see if there is a different CNAME defined for your host workspace.  

  • 0 kudos
ByteForge
by New Contributor
  • 869 Views
  • 1 replies
  • 0 kudos

How to import .dbc files above size limit?

 Above is the screenshot of error, is there any other way of processing dbc files? Do no have access/backup to previous workspace where this code is imported from

ByteForge_2-1715687151524.png
  • 869 Views
  • 1 replies
  • 0 kudos
Latest Reply
shan_chandra
Esteemed Contributor
  • 0 kudos

@ByteForge - Kindly raise a support case with Databricks to work with Engg to increase the limits for your workspace.

  • 0 kudos
databricksdev
by New Contributor II
  • 940 Views
  • 1 replies
  • 0 kudos

Capture Automatically Added tags

Can we capture automatically added tags (ex: RunName) from azure data bricks job cluster to parameters or custom tags in azure data factory

  • 940 Views
  • 1 replies
  • 0 kudos
Latest Reply
Kaniz_Fatma
Community Manager
  • 0 kudos

Hi @databricksdev,  Azure Databricks applies default tags to each cluster, including Vendor, Creator, ClusterName, and ClusterId. In addition, it applies two default tags on job clusters: RunName and JobId1. However, these tags are only applied to...

  • 0 kudos
ac0
by New Contributor III
  • 866 Views
  • 2 replies
  • 0 kudos

Resolved! Is it more performant to run optimize table commands on a serverless SQL warehouse or elsewhere?

Is it more performant to run optimize table commands on a serverless SQL warehouse or in a job or all-purpose compute cluster? I would presume a serverless warehouse would be faster, but I don't know how to test this.

  • 866 Views
  • 2 replies
  • 0 kudos
Latest Reply
Yeshwanth
Honored Contributor
  • 0 kudos

@ac0 Good day! Serverless SQL warehouses are likely to execute "optimize table" commands faster than job or all-purpose compute clusters due to their rapid startup time, quick upscaling for low latency, and efficient handling of varying query demand....

  • 0 kudos
1 More Replies
NTRT
by New Contributor III
  • 769 Views
  • 1 replies
  • 0 kudos

how to transform json-stat 2 filte to SparkDataFrame ? how to keep order on MapType structure ?

Hi,I am using different json files of type json-stat2.  These kind of json file is quite common used in national statistisc bureau. Its multi dimensional with multy arrays. Using python environment kan we use pyjstat package to easily  transform json...

  • 769 Views
  • 1 replies
  • 0 kudos
Latest Reply
-werners-
Esteemed Contributor III
  • 0 kudos

MapType does not maintain order (json itself too).Can you apply the ordering yourself afterwards?

  • 0 kudos
NTRT
by New Contributor III
  • 797 Views
  • 2 replies
  • 0 kudos

cant read json file with just 1,75 MiB ?

Hi,I am realtively new on databricks, although I am conscious about lazy evaluation, transformations and actions and peristence.I have a json file (complex-nested) with about 1,73 MiB. when df = spark.read.option("multiLine", "false").json('dbfs:/mnt...

  • 797 Views
  • 2 replies
  • 0 kudos
Latest Reply
koushiknpvs
New Contributor III
  • 0 kudos

This can be resolved by redefining the schema structure explicitly and using that schema to read the file. from pyspark.sql.types import StructType, StructField, StringType, IntegerType, ArrayType# Define the schema according to the JSON structuresch...

  • 0 kudos
1 More Replies
NTRT
by New Contributor III
  • 1714 Views
  • 4 replies
  • 0 kudos

Resolved! performance issues when readingjson-stat2

Hi,I am realtively new on databricks, although I am conscious about lazy evaluation, transformations and actions and peristence.I have a json file (complex-nested) with about 1,73 MiB. when df = spark.read.option("multiLine", "false").json('dbfs:/mnt...

  • 1714 Views
  • 4 replies
  • 0 kudos
Latest Reply
koushiknpvs
New Contributor III
  • 0 kudos

Please give me a kudos if this works.Efficiency in Data Collection: Using .collect() on large datasets can lead to out-of-memory errors as it collects all rows to the driver node. If the dataset is large, consider alternatives such as extracting only...

  • 0 kudos
3 More Replies
Mathias_Peters
by Contributor
  • 829 Views
  • 2 replies
  • 0 kudos

Asset Bundles: Adding project_directory in DBT task breaks previous python task

Hi, I have a job consisting of three tasks:  tasks: - task_key: Kinesis_to_S3_new spark_python_task: python_file: ../src/kinesis.py parameters: ["${var.stream_region}", "${var.s3_base_path}"] j...

  • 829 Views
  • 2 replies
  • 0 kudos
Latest Reply
Mathias_Peters
Contributor
  • 0 kudos

Hi @Ajay-Pandey ,thank you for the hints. I will try to recreate the job via UI. I ran the tasks in a Github workflow. The file locations are mixed: the first two tasks (python and dlt) are located in the databricks/src folder. The dbt files come fro...

  • 0 kudos
1 More Replies
chandan_a_v
by Valued Contributor
  • 1960 Views
  • 2 replies
  • 1 kudos

Can't import local files under repo

I have a yaml file inside one of the sub dir in Databricks, I have appended the repo path to sys. Still I can't access this file. https://docs.databricks.com/_static/notebooks/files-in-repos.html

image
  • 1960 Views
  • 2 replies
  • 1 kudos
Latest Reply
Abhishek10745
New Contributor III
  • 1 kudos

Hello @chandan_a_v ,were you able to solve this issue?I am also experiencing the same thing where i cannot move file with extension .yml from repo folder to shared workspace folder.As per documentation, this is the limitation or functionality of data...

  • 1 kudos
1 More Replies

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Labels
Top Kudoed Authors