- 5121 Views
- 3 replies
- 3 kudos
Resolved! How do I create a job for a notebook not in the /Users/ directory?
I am setting up a job to to load data from S3 into Delta using Auto loader. I can do this fine in interactive mode. When trying to create a job in the UI. I can select the notebook in the root directory I created for the project within the create jo...
- 5121 Views
- 3 replies
- 3 kudos
- 3 kudos
Hi @Ken Pendergast​, you are supposed to be able to reference any Notebook you have the right permissions on so it looks like you are running into a bug, can you please reach out to support or email me directly with your workspace ID? My email is jan...
- 3 kudos
- 3479 Views
- 3 replies
- 0 kudos
Resolved! SQL Issues with 10.0 runtime
I was testing my sqls with new 10.0 runtime and found some interesting/weird thing. The same sql with explode function fails for some scenarios in 10.0! Could not figure out yet the reason
- 3479 Views
- 3 replies
- 0 kudos
- 0 kudos
@Yadhuram MC​ if the issue persists, please email me at bilal dot aslam at databricks dot com. I would like to get to the root of this issue. It
- 0 kudos
- 4156 Views
- 2 replies
- 2 kudos
Resolved! OPTIMIZE
I have been testing OPTIMIZE a huge set of data (about 775 million rows) and getting mixed results. When I tried on a 'string' column, the query return in 2.5mins and using the same column as 'integer', using the same query, it return 9.7 seconds. Pl...
- 4156 Views
- 2 replies
- 2 kudos
- 20424 Views
- 20 replies
- 10 kudos
Resolved! Haven't received Badge for Apache Spark 3.0 Associate Dev certification
I have given my exam on 8/10/2021 and have passed it, subsequently I received me certificate but haven't received the badge associated with it yet, its been almost 2 weeks since I received the certificate and have raised 2 requests through the main c...
- 20424 Views
- 20 replies
- 10 kudos
- 10 kudos
@Atharva Salunke​ - If you're referring to @Maithreyi Pagar​, they're all set.
- 10 kudos
- 2996 Views
- 0 replies
- 0 kudos
Is the "patch"/update method of the repos API synchronous?
The repos API has a patch method to update a repo in the workspace (to do a git pull).We would please like to verify: is this method fully synchronous? Is it guaranteed to only return a 200 after the update is complete? Or, would immediately referenc...
- 2996 Views
- 0 replies
- 0 kudos
- 11098 Views
- 8 replies
- 3 kudos
Resolved! How to export a Databricks repos in dbc format with databricks CLI
Hi,How can I export a Databricks repository in dbc format with databricks CLI ?It is possible to make databricks workspace export_dir path/to/dir .but notdatabricks repos export_dir path/to/dir .Thanks for you answers
- 11098 Views
- 8 replies
- 3 kudos
- 3 kudos
@Bertrand BURCKER​ Is your requirement to do it only from the CLI? Or to export the repos?If it is to export the repos, you can export it as DBC format from the UI.
- 3 kudos
- 12883 Views
- 10 replies
- 5 kudos
Resolved! An unidentified special character is added in outbound file when transformed in databricks. Please help with suggestion?
Data from external source is copied to ADLS, which further gets picked up by databricks, then this massaged data is put in the outbound file . A special character ? (question mark in black diamond) is seen in some fields in outbound file which may br...
- 12883 Views
- 10 replies
- 5 kudos
- 5 kudos
Are you sure it is Databricks which puts the special character in place?It could also have happened during the copy of the external system to ADLS.If you use Azure Data Factory f.e. you have to define the encoding (UTF-8 or UTF-16, ...)
- 5 kudos
- 18785 Views
- 8 replies
- 9 kudos
Resolved! Is there a way to create a non-temporary Spark View with PySpark?
Hi,When creating a Spark view using SparkSQL ("CREATE VIEW AS SELCT ...") per default, this view is non-temporary - the view definition will survive the Spark session as well as the Spark cluster.In PySpark I can use DataFrame.createOrReplaceTempView...
- 18785 Views
- 8 replies
- 9 kudos
- 9 kudos
why not to create manage table?dataframe.write.mode(SaveMode.Overwrite).saveAsTable("<example-table>") # later when we need data resultDf = spark.read.table("<example-table>")
- 9 kudos
- 8632 Views
- 9 replies
- 4 kudos
Resolved! Does Databricks persist the alert results history?
Hi, this seems like a really basic feature to have, an alert is generated and spits out the email, but the URL doesn't take you to the events list that happened at that time but just the query in the editor (via the alert config screen). We're really...
- 8632 Views
- 9 replies
- 4 kudos
- 4 kudos
@Nick Hughes​ I was looking at our ideas portal and could see an API feature was requested for the Alerts (DB-I-4289). To create an API for the alerts and pull data, we might need to keep the alert history persistent. So this feature should suffice y...
- 4 kudos
- 1351 Views
- 0 replies
- 4 kudos
spark.apache.org
Per API docs on StreamingQuery.stop(), https://spark.apache.org/docs/latest/api/scala/org/apache/spark/sql/streaming/StreamingQuery.html It says, this stops the execution of this query if it is running and waits until the termination of the query...
- 1351 Views
- 0 replies
- 4 kudos
- 10654 Views
- 5 replies
- 6 kudos
Resolved! Autoloader failed
I used autoloader with TriggerOnce = true and ran it for weeks with schedule. Today it broke:The metadata file in the streaming source checkpoint directory is missing. This metadatafile contains important default options for the stream, so the stream...
- 10654 Views
- 5 replies
- 6 kudos
- 6 kudos
Hi dimoobraznii (Customer)This error comes in streaming when someone makes changes to the streaming checkpoint directory manually or points some streaming type to the checkpoint of some other streaming type. Please check if any changes were made to t...
- 6 kudos
- 4722 Views
- 3 replies
- 7 kudos
Resolved! How does 73% of the data go unused for analytics or decision-making?
Is Lakehouse the answer? Here's a good resource that was just published: https://dbricks.co/3q3471X
- 4722 Views
- 3 replies
- 7 kudos
- 7 kudos
@Alexis Lopez​ - If @Dan Zafar​ 's or @Harikrishnan Kunhumveettil​'s answers solved the issue, would you be happy to mark one of their answers as best so other members can find the solution more easily?
- 7 kudos
- 2424 Views
- 1 replies
- 1 kudos
Auto Loader Schema-Inference and Evolution for parquet files
Dear all,will (and when) will Auto Loader also support Schema-Inference and Evolution for parquet files, at this point it is only for JSON and CSV supported if i am not mistaken?Thanks and regards,Gapy
- 2424 Views
- 1 replies
- 1 kudos
- 1 kudos
@Gasper Zerak​ , This will be available in near future (DBR 10.3 or later). Unfortunately, we don't have an SLA at this moment.
- 1 kudos
- 9189 Views
- 10 replies
- 9 kudos
Resolved! Lineage between model and source code breaks on movement of source notebook. How to rectify it?
If there is a registered model and it is linked with a notebook, then the lineage breaks if you move the notebook to a different path or even pull/upload a new version of the notebook.This is not good because when someone doing its development/testin...
- 9189 Views
- 10 replies
- 9 kudos
- 9 kudos
I also cannot reproduce this, with these exact steps (I think). After moving the notebook and moving it back, the link to it (and link to the revision) still works as expected. You are using MLflow built in to Databricks right?
- 9 kudos
- 8984 Views
- 1 replies
- 3 kudos
Resolved! %run file not found
Hi,I was using the following command to import variables and functions from an other notebook :%run ./utilsFor some reason it is not working any more and gives me this message :Exception: File `'./utils.py'` not found.utils.py is still at the same pl...
- 8984 Views
- 1 replies
- 3 kudos
- 3 kudos
Finally I just solved my issue.Actually, in the same cell I wrote a comment starting with # and it was not working because of that...
- 3 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 584 | |
| 349 | |
| 287 |
