- 14738 Views
- 10 replies
- 8 kudos
Resolved! How to perform a cross-check for data in multiple columns in same table?
I am trying to check whether a certain datapoint exists in multiple locations.This is what my table looks like:I am checking whether the same datapoint is in two locations. The idea is that this datapoint should exist in BOTH locations, and be counte...
- 14738 Views
- 10 replies
- 8 kudos
- 8 kudos
Hi,Thank you very much for following up. I no longer need assistance with this issue.
- 8 kudos
- 5880 Views
- 4 replies
- 2 kudos
Resolved! What is the best strategy for backing up a large Databricks Delta table that is stored in Azure blob storage?
I have a large delta table that I would like to back up and I am wondering what is the best practice for backing it up. The goal is so that if there is any accidental corruption or data loss either at the Azure blob storage level or within Databricks...
- 5880 Views
- 4 replies
- 2 kudos
- 2 kudos
Hi @deisou​ Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark the answer as best? If not, please tell us so we can help you.Cheers!
- 2 kudos
- 1872 Views
- 0 replies
- 1 kudos
How to use Databricks Feature Store for time series forecasts?
I've seen the Databricks documentation on time series here. I'm using forecasts as a feature and those forecasts have both an as-of timestamp (when the forecast was generated) and a time step label (timestamp indicating the time of the forecasted obs...
- 1872 Views
- 0 replies
- 1 kudos
- 27536 Views
- 5 replies
- 4 kudos
Resolved! What's the best way to manage multiple versions of the same datasets?
We have use cases that require multiple versions of the same datasets to be available. For example, we have a knowledge graph made of entities of relations, and we have multiple versions of the knowledge graph that's distinguished by schema names ri...
- 27536 Views
- 5 replies
- 4 kudos
- 4 kudos
Hey there @Kyle Gao​ Hope you are doing well. Thank you for posting your query.Just wanted to check in if you were able to resolve your issue or do you need more help? We'd love to hear from you.Cheers!
- 4 kudos
- 4630 Views
- 4 replies
- 2 kudos
Resolved! Post upgrading the Azure databricks cluster from 8.3 (includes Apache Spark 3.1.1, Scala 2.12) to 9.1 LTS (includes Apache Spark 3.1.2, Scala 2.12), I am getting intermittent error.
The error is as below. The error is intermittent. eg. - The same code throws the below issue for run 3 but doesn't throws issue for run 4. Then again throws issue for run 5.An error occurred while calling o1509.getCause. Trace:py4j.security.Py4JSecur...
- 4630 Views
- 4 replies
- 2 kudos
- 2 kudos
Hey @Darshana Ganesh​ Just wanted to check in if you were able to resolve your issue or do you need more help? We'd love to hear from you.Thanks!
- 2 kudos
- 8146 Views
- 5 replies
- 5 kudos
Delta Table with 130 columns taking time
Hi All,We are facing one un-usual issue while loading data into Delta table using Spark SQL. We have one delta table which have around 135 columns and also having PARTITIONED BY. For this trying to load 15 millions of data volume but its not loading ...
- 8146 Views
- 5 replies
- 5 kudos
- 5 kudos
@Kaniz Fatma​ @Parker Temple​ I found an root cause its because of serialization. we are using UDF to drive an column on dataframe, when we are trying to load data into delta table or write data into parquet file we are facing serialization issue ....
- 5 kudos
- 7138 Views
- 7 replies
- 2 kudos
Resolved! Recursive view error while using spark 3.2.0 version
This happens while creating temp view using below code blocklatest_data.createOrReplaceGlobalTempView("e_test")ideally this command should replace the view if e_test already exists instead it is throwing"Recursive view `global_temp`.`e_test` detecte...
- 7138 Views
- 7 replies
- 2 kudos
- 2 kudos
Hi, @Manasa​, could you please check SPARK-38318 and use Spark 3.1.2, Spark 3.2.2, or Spark 3.3.0 to allow cyclic reference?
- 2 kudos
- 1413 Views
- 0 replies
- 0 kudos
back pain 26
Hundreds of thousands of people in the United States suffer from back pain at some point in their lives. Because of this, you don't have to suffer greatly. The advice in this article can assist you in lessening the daily agony that you experience. Pa...
- 1413 Views
- 0 replies
- 0 kudos
- 9752 Views
- 1 replies
- 11 kudos
Resolved! How to merge all the columns into one column as JSON?
I have a task to transform a dataframe. The task is to collect all the columns in a row and embed it into a JSON string as a column.Source DF:Target DF:
- 9752 Views
- 1 replies
- 11 kudos
- 11 kudos
I was able to do this by converting df to rdd and then by applying map function to it.rdd_1 = df.rdd.map(lambda row: (row['ID'], row.asDict() ) ) ...
- 11 kudos
- 2691 Views
- 0 replies
- 0 kudos
How Can we pass parameters from the data factory to databricks Job that is using a notebook
How Can I pass parameters from the data factory to databricks Jobs that is using a notebook but I know how to pass parameters from data factory to databricks notebooks when ADF calling directly the Notebook.
- 2691 Views
- 0 replies
- 0 kudos
- 19917 Views
- 5 replies
- 8 kudos
Resolved! Databricks Runtime 10.4 LTS - AnalysisException: No such struct field id in 0, 1 after upgrading
Hello,We are working to migrate to databricks runtime 10.4 LTS from 9.1 LTS but we're running into weird behavioral issues. Our existing code works up until runtime 10.3 and in 10.4 it stopped working.Problem:We have a nested json file that we are fl...
- 19917 Views
- 5 replies
- 8 kudos
- 8 kudos
It seems like the issue was miraculously resolved. I did not make any code changes but everything is now running as expected. Maybe the latest runtime 10.4 fix released on April 19th also resolved this issue unintentionally.
- 8 kudos
- 8078 Views
- 6 replies
- 3 kudos
Resolved! I am looking to use the pivot function with Spark SQL (not Python)
Hello. I am trying to using the Pivot function for email addresses. This is what I have so far:Select fname, lname, awUniqueID, Email1, Email2From xxxxxxxxPivot ( count(Email) as Test For Email In (1 as Email1, 2 as Email2) )I get everyth...
- 8078 Views
- 6 replies
- 3 kudos
- 3 kudos
source data:fname lname awUniqueID EmailJohn Smith 22 jsmith@gmail.comJODI JONES 22 jsmith@live.comDesired output:fname lname awUniqueID Em...
- 3 kudos
- 21678 Views
- 4 replies
- 6 kudos
Resolved! Partition By () on Delta Files
Hi All,I am trying to Partition By () on Delta file in pyspark language and using command:df.write.format("delta").mode("overwrite").option("overwriteSchema","true").partitionBy("Partition Column").save("Partition file path") -- It doesnt seems to w...
- 21678 Views
- 4 replies
- 6 kudos
- 6 kudos
Hey @Harsha kriplani​ Hope you are well. Thank you for posting in here. It is awesome that you found a solution. Would you like to mark Hubert's answer as best? It would be really helpful for the other members too.Cheers!
- 6 kudos
- 2916 Views
- 2 replies
- 5 kudos
Resolved! Does job cluster helps the jobs that are fighting for Resources on all purpose cluster ?
Hi Team, Does job cluster helps the jobs that are fighting for Resources on all purpose cluster ?With job cluster the drawback that i see is creation of cluster every time when the job starts, Its taking 2 mins for spinning up the cluster. Instead of...
- 2916 Views
- 2 replies
- 5 kudos
- 5 kudos
@Manoj Kumar Rayalla​ , You can in the job set to use an all-purpose cluster (that feature was added recently)You can use the pool to limit job cluster starting time (but it still can take a moment),
- 5 kudos
- 16019 Views
- 9 replies
- 13 kudos
Resolved! Is it possible to connect Databricks SQL with AWS Redshift DB?
I would like to know if it's possible to connect Databricks SQL module with not just internal Metastore DB and tables from Data Science and Engineering module but also connect with an AWS Redshift DB to do queries and create alerts.
- 16019 Views
- 9 replies
- 13 kudos
- 13 kudos
Hi @Kaniz Fatma​ I contacted Customer support explaining this issue, they told me that this feature is not implemented yet but it's in the roadmap with no ETA. It would be great if you ping me back when it's possible to access Redshift tables from SQ...
- 13 kudos
| User | Count |
|---|---|
| 1644 | |
| 793 | |
| 576 | |
| 349 | |
| 287 |
