- 2917 Views
- 1 replies
- 2 kudos
spark.apache.org
Hey fellow co-workers!!I have been doing the Apache Spark programming in Databricks academy and I realized the hyperlinks here it doesn't work.Spark session https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql.html#spark-session-apis
- 2917 Views
- 1 replies
- 2 kudos
- 2 kudos
@Deiry Navas​ Could you share the repo link usued to exectue that notebook? I'll on my side
- 2 kudos
- 1478 Views
- 1 replies
- 0 kudos
Why are the get..Id() functions returning 'some(123456)' instead of just the id?
Hey fellow users, I've successfully retrieved the notebook context during job runs and there are several getId calls. For some reason when the ids are returned, they are wrapped in a some() instead of just the number. Does anyone know why this is the...
- 1478 Views
- 1 replies
- 0 kudos
- 0 kudos
Well, my post for me is irrelevant now!! I just stumbled across this beauty which avoids me having to do any of this and deal with odd return values.How to get the Job ID and Run ID and save into a database (databricks.com)Are the braces {{job_id}} n...
- 0 kudos
- 8998 Views
- 6 replies
- 6 kudos
External Table issue format in databricks
I am new to databricksI am trying to create a external table in databricks with below format :CREATE EXTERNAL TABLE Salesforce.Account( Id string , IsDeleted bigint, Name string , Type string , RecordTypeId string , ParentId string , ShippingSt...
- 8998 Views
- 6 replies
- 6 kudos
- 6 kudos
Databricks is awesome if you have SQL knowledge....I just came across one of my problem in my project and databricks helped me a lot....like a use of low watermark to hold the load success date .....​
- 6 kudos
- 3930 Views
- 2 replies
- 3 kudos
collapse partial code in large cell?
In databricks notebook, we have SQL cells that are over 700 lines long. Is there a way to collapse a portion of the code vs scrolling? Looking for something similar to what exists in Netezza, "--region" and "--end region" where anything between those...
- 3930 Views
- 2 replies
- 3 kudos
- 3 kudos
Hi @james t​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Thanks!
- 3 kudos
- 1243 Views
- 1 replies
- 0 kudos
- 1243 Views
- 1 replies
- 0 kudos
- 0 kudos
it is just for better security and data governance
- 0 kudos
- 36885 Views
- 7 replies
- 0 kudos
How to get the path of files using python os library
unable to find the path to directory with os library
- 36885 Views
- 7 replies
- 0 kudos
- 6991 Views
- 4 replies
- 1 kudos
How to print the path of a .py file or a notebook?
I have stored a test.py in the dbfs at the below location "/dbfs/FileStore/shared_uploads/krishna@company.com/Project_Folder/test.py"I have a print statement in test.py which says the belowprint( os.getcwd() )and it prints the below'/databricks/drive...
- 6991 Views
- 4 replies
- 1 kudos
- 1 kudos
Hey @Krishna Zanwar​ Please use the below code this will work and as you want the specific location you can create a custom code and format the path using a python formatter , it will give you desired result .
- 1 kudos
- 3698 Views
- 1 replies
- 2 kudos
Resolved! org.apache.http.conn.ConnectTimeoutException: What does this mean and how can we resolve it.
My team has run into getting this error pretty frequently on one of our larger jobs. I've set out retry policy to 5 and that seems to fix it and keep the job going. It seems like it's unable to pick up the task immediately but can after it's complete...
- 3698 Views
- 1 replies
- 2 kudos
- 2 kudos
Hey @Coleman Milligan​ ,I also faced this type of issue many times you can add the below configuration in your cluster and it should work.spark.executor.heartbeatInterval 60sspark.network.timeout 120sFor more details, you can explore this doc - https...
- 2 kudos
- 5225 Views
- 2 replies
- 2 kudos
cannot convert Parquet type INT64 to Photon type double
I am trying to read in files via the COPY INTO command but I am getting this error lately for a certain subset of the data;`Error while reading file: Schema conversion error: cannot convert Parquet type INT64 to Photon type double`These are my option...
- 5225 Views
- 2 replies
- 2 kudos
- 2 kudos
hey @Andrew Fogarty​ I also faced the same issue when I moved from the 7.3 LTS version to a higher runtime version so to mitigate this issue you can use the below cluster configuration spark.sql.storeAssignmentPolicy LEGACYspark.sql.parquet.binaryAsS...
- 2 kudos
- 2879 Views
- 4 replies
- 0 kudos
Resolved! Safari problems after the maintenance on 12/9/2022
I'm experience some problems on Safari 15.3 ( MacOS )I would like to know if I am alone in this and how to fix ( if I can ) this.This is the Databricks SQLData science and Engineering. ( is this case Workflows).
- 2879 Views
- 4 replies
- 0 kudos
- 1349 Views
- 0 replies
- 0 kudos
i want to plot multiple data frames from a pandas datafreame
Hi all, i want to plot multiple charts from a pandas datafreame. However, when i run the code below it says "Command result size exceeds limit: Exceeded 20971520 bytes (current = 20973124)". If I move line 11 and place at 21 (outside of the functi...
- 1349 Views
- 0 replies
- 0 kudos
- 2276 Views
- 1 replies
- 1 kudos
Jobs failing with repl error
Recently my Databricks jobs have failed with the error message:Failure starting repl. Try detaching and re-attaching the notebook. java.lang.Exception: Python repl did not start in 30 seconds seconds. at com.databricks.backend.daemon.driver.Ipyker...
- 2276 Views
- 1 replies
- 1 kudos
- 1 kudos
Yes, you can use re-try if still it's not resolve raise a support ticket to databricks
- 1 kudos
- 20731 Views
- 2 replies
- 2 kudos
Can I query my Delta tables with PowerBI?
I would like to connect to the Delta tables I have created with PowerBI to use for reporting. Is it possible to do this with Databricks or do I have to write my data to some other serving layer?
- 20731 Views
- 2 replies
- 2 kudos
- 2 kudos
if you want to read your Delta Lake table directly from the storage without the need of having a Databricks cluster up and running you can also use the official connector Power BI connector for Delta Lake https://github.com/delta-io/connectors/tree/m...
- 2 kudos
- 2767 Views
- 4 replies
- 11 kudos
Resolved! Delta table output to Databricks SQL
How to write a delta table output to Databricks SQL for analysis purpose.
- 2767 Views
- 4 replies
- 11 kudos
- 1522 Views
- 1 replies
- 5 kudos
Resolved! Trigger another .py file by uisng 2 .py files.
Hi,I have 3 .py files - a.py, b.py & c.py files. By joining a.py & b.py, based on the output that I get need to trigger the c.py file.
- 1522 Views
- 1 replies
- 5 kudos
- 5 kudos
Hi @KVNARK .​ refer below link this will help in thisLink
- 5 kudos
| User | Count |
|---|---|
| 1616 | |
| 787 | |
| 383 | |
| 349 | |
| 287 |
