- 2681 Views
- 1 replies
- 2 kudos
I cannot access databricks community edition account
Last week, I cannot loginto https://community.cloud.databricks.com/login.html all of a sudden. I tried to set the password, also didn't receive the reset email. It says "Invalid email address or password Note: Emails/usernames are case-sensitive".I e...
- 2681 Views
- 1 replies
- 2 kudos
- 2 kudos
@Kaniz Fatma can help, additionally you can open ticket here https://help.databricks.com/s/contact-us
- 2 kudos
- 6214 Views
- 4 replies
- 8 kudos
Resolved! init_script error during cluster creation - 101: Network is unreachable
When I run the init_script during cluster creationapt-get update && apt-get install -y ffmpeg libsndfile1-devI get an error in cluster logs E: Failed to fetch http://archive.ubuntu.com/ubuntu/pool/universe/o/openal-soft/libopenal1_1.19.1-1_amd64.deb ...
- 6214 Views
- 4 replies
- 8 kudos
- 8 kudos
Hi @Sergii Ivakhno Could you please check if outbound TCP access for port 80 is allowed in the security group.
- 8 kudos
- 1008 Views
- 0 replies
- 0 kudos
PROCESS OF APPLYING FOR OMAN E-VISA The Oman e-Visa was initiated in 2018, for making the process easy. Presently, 220 countries in the world are elig...
PROCESS OF APPLYING FOR OMAN E-VISAThe Oman e-Visa was initiated in 2018, for making the process easy. Presently, 220 countries in the world are eligible to apply for Oman e-Visa. Tourists can apply for visas online by submitting the Oman visa applic...
- 1008 Views
- 0 replies
- 0 kudos
- 6674 Views
- 4 replies
- 4 kudos
Resolved! Cant find reason but suddenly new Jobs are getting huge job id numbers. example 945270539673815
Created Job ID is suddenly started to make huge numbers, and that is now making problems in Terraform plan, cause int is too big Error: strconv.ParseInt: parsing "945270539673815": value out of rangeIm new on the board and pretty new with Databricks ...
- 6674 Views
- 4 replies
- 4 kudos
- 4 kudos
Hi @Jere Karhu , In case you are using the Job/Run id in API, please be advised that you will need to change the client-side logic to process int64/long and expect a random number. In some cases, you just need to change the declared type in their so...
- 4 kudos
- 6060 Views
- 3 replies
- 3 kudos
Resolved! Importing MongoDB with field names containing spaces
I am currently using a Python notebook with a defined schema to import fairly unstructured documents in MongoDB. Some of these documents have spaces in their field names. I define the schema for the MongoDB PySpark connector like the following:Struct...
- 6060 Views
- 3 replies
- 3 kudos
- 3 kudos
Solution: It turns out the issue is not the schema reading in, but the fact that I am writing to Delta tables, which do not currently support spaces. So, I need to transform them prior to dumping. I've been following a pattern of reading in raw data,...
- 3 kudos
- 4062 Views
- 1 replies
- 2 kudos
Resolved! Issue when reading .wav file
Hi, I am developing notebook to read .wav files and build Speech Matching Scenario. I have saved files in "/FileStore/tables/doors_and_corners_kid_thats_where_they_get_you.wav".When I wrote code like thisfrom scipy.io import wavfileimport numpy as np...
- 4062 Views
- 1 replies
- 2 kudos
- 2 kudos
Try to prefix it with dbfs dbfs:/FileStore or /dbfs/FileStore
- 2 kudos
- 9566 Views
- 1 replies
- 5 kudos
Resolved! How to Overwrite Using pyspark's JDBC without loosing constraints on table columns
Hello,My table has primary key constraint on a perticular column, Im loosing primary key constaint on that column each time I overwrite the table , What Can I do to preserve it? Any Heads up would be appreciatedTried Belowdf.write.option("truncate", ...
- 9566 Views
- 1 replies
- 5 kudos
- 5 kudos
@Abeeya . , Mode "truncate", is correct to preserve the table. However, when you want to add a new column (mismatched schema), it wants to drop it anyway.
- 5 kudos
- 2398 Views
- 1 replies
- 0 kudos
How to resolve Quickbooks error 12007
QuickBooks error 12007 occurs when an update time out occurs. QuickBooks may encounter this error when it cannot connect to the internet if it's unable to access the server. If you want to know its solutions then check out our latest blog on this.
- 2398 Views
- 1 replies
- 0 kudos
- 0 kudos
How to Resolve QuickBooks Payroll Update Error 12007?For various possible causes of the QB payroll update error 12007, you need to perform different troubleshooting procedures. Follow the solutions in their given sequence to fix this QuickBooks error...
- 0 kudos
- 10283 Views
- 11 replies
- 9 kudos
Resolved! Hi Experts i am new to data bricks and i want to know how data bricks supports real time reporting needs in Business intelligence?
Delta lake have 3 levels to maintain data quality ( bronze , silver and gold tables ) but this supports the reporting and BI solutions how does this supports the streaming analytics ?example : I have an app that loads all the operational data in adls...
- 10283 Views
- 11 replies
- 9 kudos
- 9 kudos
@Basavaraj Angadi , Why? For simplicity, cost savings etc.You can make it work with 2 'containers' but it is not necessary.
- 9 kudos
- 6093 Views
- 2 replies
- 3 kudos
Resolved! Play the BIG DATA GAME | By Firebolt
https://www.firebolt.io/big-data-gameThe most fun our Bricksters have had in a while at work is thanks to a little BIG DATA thing called The BIG DATA GAME ️This game is the cure for the mid-week blues. The Big Data Game is a simple yet awesome online...
- 6093 Views
- 2 replies
- 3 kudos
- 929 Views
- 0 replies
- 0 kudos
laraschmoisman.com
Online Business Training
- 929 Views
- 0 replies
- 0 kudos
- 11898 Views
- 3 replies
- 2 kudos
Resolved! Python Spark Job - error: job failed with error message The output of the notebook is too large.
Hi databricks experts. I am currently facing a problem with a submitted job run on Azure Databricks. Any help on this is very welcome. See below for details:Problem Description:I submitted a python spark task via the databricks cli (v0.16.4) to Azure...
- 11898 Views
- 3 replies
- 2 kudos
- 2 kudos
Without any further changes from my side, the error has disappeard since 29.03.2022
- 2 kudos
- 4296 Views
- 2 replies
- 3 kudos
How can i pass one of the values from one function to another as an argument in Databricks SQL?
For eg - CREATE OR REPLACE TABLE table2(a INT, b INT);INSERT INTO table2 VALUES (100, 200);CREATE OR REPLACE FUNCTION func1() RETURNS TABLE(a INT, b INT) RETURN (SELECT a+b, a*b from table2);create or replace function calc(p DOUBLE) RETURNS TABLE(val...
- 4296 Views
- 2 replies
- 3 kudos
- 3 kudos
Yes, it is possible, but with different logic. For scalar, so calc(a) in select calc(a) from func1(); it can only be a query as a table for a scalar is not allowed. So please try something like:CREATE OR REPLACE FUNCTION func_table() RETURNS TABLE(a ...
- 3 kudos
- 22573 Views
- 2 replies
- 1 kudos
- 22573 Views
- 2 replies
- 1 kudos
- 1 kudos
%scala def clearAllCaching(tableName: Option[String] = None): Unit = { tableName.map { path => com.databricks.sql.transaction.tahoe.DeltaValidation.invalidateCache(spark, path) } spark.conf.set("com.databricks.sql.io.caching.bucketedRead.enabled", "f...
- 1 kudos
- 5089 Views
- 3 replies
- 1 kudos
Resolved! Cluster doesn't support Photon with Docker Image enabled
I enabled Photon 9.1 LTS DBR in cluster that was already using Docker Image of the latest version, when I ran a SQL QUery using my cluster, I could not see any Photon engine working in my executor that should be actually running in Photon Engine.When...
- 5089 Views
- 3 replies
- 1 kudos
- 1 kudos
Hello @Praganessh S , Photon is currently in Public Preview. The only way to use it is to explicitly run Databricks-provide Runtime images which contain it. Please see: https://docs.databricks.com/runtime/photon.html#databricks-clustersandhttps://do...
- 1 kudos
| User | Count |
|---|---|
| 1644 | |
| 793 | |
| 581 | |
| 349 | |
| 287 |
