- 6134 Views
- 4 replies
- 2 kudos
Resolved! Slow first time run, jar based jobs
When running a jar-based job, I've noticed that the 1st run always takes the extra time to complete the job and consecutive runs take less time to finish the job. This behavior is reproducible on an interactive cluster. What's causing this? Is this e...
- 6134 Views
- 4 replies
- 2 kudos
- 2 kudos
@Sandeep Katta​ , this is a fat jar that does read-transform-write. @DD Sharma​ response matches @Werner Stinckens​ & I intuition that there was efficiency on the second job due to jar already being loaded. I would not have noticed this had job run...
- 2 kudos
- 3820 Views
- 4 replies
- 7 kudos
Resolved! Visualization of Structured Streaming in job.
Does Databricks have feature or good pattern to visualize the data from Structured Streaming? Something like display in the notebook.
- 3820 Views
- 4 replies
- 7 kudos
- 3505 Views
- 2 replies
- 6 kudos
Resolved! New Bill Inmon Book, What are your thoughts?
Have you checked out the new Bill Inmon Book, Building the Data Lakehouse? https://dbricks.co/3uxCXjO What were your thoughts if you read it?
- 3505 Views
- 2 replies
- 6 kudos
- 6 kudos
The quality of the book depends on the audience IMO. For people who have no background in data warehousing it will be interesting to read. For the others the book is too general and descriptive. The 'HOW do you do x' is missing.
- 6 kudos
- 16197 Views
- 3 replies
- 1 kudos
ImportError: No module named 'bs4'
Hi, I would like to do some web scrapping, however I am unable to import the libraries I traditionally use for that task import requests from bs4 import BeautifulSoup
- 16197 Views
- 3 replies
- 1 kudos
- 1 kudos
Did you try `%pip install bs4 `requests is standard in the databricks runtime, so you don't have to install it.
- 1 kudos
- 2828 Views
- 2 replies
- 2 kudos
- 2828 Views
- 2 replies
- 2 kudos
- 2 kudos
@Werner Stinckens​ you can think about the Databricks Runtime as a contract. It does and will change over time. However, we offer Long Term Support versions of the runtime which offer multi-year support. If you have production jobs, I would definitel...
- 2 kudos
- 6400 Views
- 4 replies
- 2 kudos
Resolved! How do I run a scala script from the Terminal
Hello, how do I run a scala script from a Terminal on Databricks - Web Terminal, or from a cell with %sh just doing `scala -nc script.scala` is not working.Thanks,
- 6400 Views
- 4 replies
- 2 kudos
- 2 kudos
Hi @Zen​ the web terminal is basically used for shell commands only and specific to driver node only.You can install the scala on top of the driver node from web terminal with below command and use it:% sudo apt install scalaPlease let me know if thi...
- 2 kudos
- 18733 Views
- 3 replies
- 6 kudos
Resolved! How can you mount an Azure Data Lake (gen2) using abfss and Shared Key?
I wanted to mount a ADLG2 on databricks and take advantage on the abfss driver which should be better for large analytical workloads (is that even true in the context of DB?).Setting an OAuth is a bit of a pain so I wanted to take the simpler approac...
- 18733 Views
- 3 replies
- 6 kudos
- 6 kudos
Hi @Fernando Mendez​ ,The below document will help you to mount the ADLS gen2 using abfss:https://docs.databricks.com/data/data-sources/azure/adls-gen2/azure-datalake-gen2-get-started.htmlCould you please check if this helps?
- 6 kudos
- 7968 Views
- 1 replies
- 4 kudos
- 7968 Views
- 1 replies
- 4 kudos
- 4 kudos
Please refer to the below widget example using SQL %sql DROP VIEW IF EXISTS tempTable; CREATE temporary view tempTable AS SELECT 'APPLE' as a UNION ALL SELECT 'ORANGE' as a UNION ALL SELECT 'BANANA' as a; CREATE WIDGET DROPDOWN fruits DEFAULT 'ORAN...
- 4 kudos
- 2100 Views
- 2 replies
- 0 kudos
What are some guidelines for migrating to DBR 7/Spark 3?
What are some guidelines for migrating to DBR 7/Spark 3?
- 2100 Views
- 2 replies
- 0 kudos
- 0 kudos
Please refer to the below reference for switching to DBR 7.xWe have extended our DBR 6.4 support until December 2021, DBR 6.4 extended support - Release notes: https://docs.databricks.com/release-notes/runtime/6.4x.htmlMigration guide to DBR 7.x: htt...
- 0 kudos
- 7987 Views
- 5 replies
- 3 kudos
Resolved! how to log the KerasClassifier model in a sklearn pipeline in mlflow?
I have a set of pre-processing stages in a sklearn `Pipeline` and an estimator which is a `KerasClassifier` (`from tensorflow.keras.wrappers.scikit_learn import KerasClassifier`).My overall goal is to tune and log the whole sklearn pipeline in `mlflo...
- 7987 Views
- 5 replies
- 3 kudos
- 10612 Views
- 7 replies
- 3 kudos
Resolved! Databricks snowflake dataframe.toPandas() taking more space and time
I have 2 exactly same table(rows and schema). One table recides in AZSQL server data base and other one is in snowflake database. Now we have some existing code which we want to migrate from azsql to snowflake but when we are trying to create a panda...
- 10612 Views
- 7 replies
- 3 kudos
- 3 kudos
@Brijan Elwadhi​ - That's wonderful. Thank you for sharing your solution.
- 3 kudos
- 1815 Views
- 1 replies
- 2 kudos
Spot Instances in Azure Databricks
The above screen shot is from AWS Databricks cluster .Similarly, in Azure Databricks - Is there a specific way to determine how many of worker nodes are using spot instances and on-demand instances when it is running/completed a job.Likewise, ...
- 1815 Views
- 1 replies
- 2 kudos
- 2 kudos
Hello!My name is Piper and I'm one of the community moderators. Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question first. Or else I will follow up with the team. Thanks for your p...
- 2 kudos
- 6165 Views
- 3 replies
- 3 kudos
Resolved! Cosine similarity between all rows pairwise on a dataset of 100million rows
Hello everyone,I am facing performance issue while calculating cosine similarity in pyspark on a dataframe with around 100 million records.I am trying to do a cross self join on the dataframe to calculate it.​The executors are all having same number ...
- 6165 Views
- 3 replies
- 3 kudos
- 3 kudos
Is there a way to hash the record attributes so that the cartesian join can be avoided? I work on record similarity and fuzzy matching and we do a learning based blocking alorithm which hashes the records into smaller buckets and then the hashes are ...
- 3 kudos
- 28746 Views
- 8 replies
- 5 kudos
Resolved! How to properly load Unicode (UTF-8) characters from table over JDBC connection using Simba Spark Driver
Hello all, I'm trying to pull table data from databricks tables that contain foreign language characters in UTF-8 into an ETL tool using a JDBC connection. I'm using the latest Simba Spark JDBC driver available from the Databricks website.The issue i...
- 28746 Views
- 8 replies
- 5 kudos
- 5 kudos
Can you try setting UseUnicodeSqlCharacterTypes=1 in the driver, and also make sure 'file.encoding' is set to UTF-8 in jvm and see if the issue still persists?
- 5 kudos
- 2523 Views
- 2 replies
- 0 kudos
Resolved! CICD Databricks
Hi TeamI was wondering if there is a document or step by step process to promote code in CICD across various environments of code repository (GIT/GITHUB/BitBucket/Gitlab) with DBx support? [Without involving code repository merging capability of the ...
- 2523 Views
- 2 replies
- 0 kudos
- 0 kudos
Please refer this related thread on CICD in Databricks https://community.databricks.com/s/question/0D53f00001GHVhMCAX/what-are-some-best-practices-for-cicd
- 0 kudos
| User | Count |
|---|---|
| 1637 | |
| 791 | |
| 535 | |
| 349 | |
| 287 |
