- 7121 Views
- 5 replies
- 2 kudos
Date field getting changed when reading from excel file to dataframe in pyspark
The date field is getting changed while reading data from source .xls file to the dataframe. In the source xl file all columns are strings but i am not sure why date column alone behaves differentlyIn Source file date is 1/24/1947.In pyspark datafram...
- 7121 Views
- 5 replies
- 2 kudos
- 2 kudos
how about using inferschema one single time to create a correct DF, then create a schema from the df-schema.something like this f.e.from pyspark.sql.types import StructType # Save schema from the original DataFrame into json: schema_json = df.s...
- 2 kudos
- 8553 Views
- 7 replies
- 8 kudos
Resolved! Is anyone else experiencing intermittent "Failure starting REPL" errors with PySpark Jobs?
I have a Multi-Task Job that is running a bunch of PySpark notebooks and about 30-60% of the time, my jobs fail with the following error:I haven't seen any consistency with this error. I've had as many as all of the tasks in the job giving this error...
- 8553 Views
- 7 replies
- 8 kudos
- 8 kudos
Hi. Did you ever got a resolution to this problem outside of rolling back to 10.4? I have recently moved some workloads over to runtime 11.3 and am experiencing intermittent "repl did not start in 30 seconds." errors.I have increased the repl timeout...
- 8 kudos
- 896 Views
- 0 replies
- 1 kudos
- 896 Views
- 0 replies
- 1 kudos
- 846 Views
- 0 replies
- 3 kudos
- 846 Views
- 0 replies
- 3 kudos
- 1832 Views
- 0 replies
- 0 kudos
How To convert the below sql server query to spark_sql. especially the isnull Replace N/A. please Help
How To convert the below query to spark sql. especially the isnull REplaceSELECT ID,ISNULL(NAME,"N/A") AS NAME,COMPANYFROM TEST
- 1832 Views
- 0 replies
- 0 kudos
- 794 Views
- 0 replies
- 0 kudos
How To convert the below query to spark sql. especially the isnull REplaceSELECTÂ ID, ISNULL(NAME,"N/A") AS NAME, ...
How To convert the below query to spark sql. especially the isnull REplaceSELECT ID, ISNULL(NAME,"N/A") AS NAME, COMPANYFROM TEST
- 794 Views
- 0 replies
- 0 kudos
- 4142 Views
- 3 replies
- 5 kudos
Getting error with spark-sftp, no such file
In a databricks cluster with Scala 2.1.1 I am trying to read a file into a spark data frame using the following code.val df = spark.read .format("com.springml.spark.sftp") .option("host", "*") .option("username", "*") .option("password", "*")...
- 4142 Views
- 3 replies
- 5 kudos
- 5 kudos
Hi @Andreas P​ 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!
- 5 kudos
- 7841 Views
- 8 replies
- 28 kudos
Resolved! Can we use Databricks or code in data bricks without learning Pyspark in depth which is used for ETL purpose and data engineering perspective.
Can we use Databricks or code in data bricks without learning Pyspark in depth which is used for ETL purpose and data engineering perspective. can someone throw some light on this. Currently learning Pyspark (basics of Pythion in handling the data) a...
- 7841 Views
- 8 replies
- 28 kudos
- 1299 Views
- 0 replies
- 2 kudos
Terraform x Databricks error INVALID_STATE subscription disabled
Hello,I just bootstrap a new Databricks EC2 on an AWS account with Terraform. Priori dependencies seems OK on my side (network, root storage, credentials configuration). I'm referring mainly to this guide and of course pages related to each Databrick...
- 1299 Views
- 0 replies
- 2 kudos
- 12871 Views
- 5 replies
- 7 kudos
Resolved! ERROR: Some streams terminated before this command could finish!
I have a databricks notebook which is to read stream from Azure Event Hub.My code does the following:1.Configure path for Eventhubs2.Read Streamdf_read_stream = (spark.readStream .format("eventhubs") .options(**conf)...
- 12871 Views
- 5 replies
- 7 kudos
- 7 kudos
I am also facing same issue , using Cluster11.3 LTS (includes Apache Spark 3.3.0, Scala 2.12) liberary : com.microsoft.azure:azure-eventhubs-spark_2.12:2.3.21Please help me for sameconf = {}conf["eventhubs.connectionString"] = "Endpoint=sb://xxxx.ser...
- 7 kudos
- 3789 Views
- 2 replies
- 14 kudos
Resolved! MongoDB Connection
How can we connect databricks to MongoDB?Any code reference will help
- 3789 Views
- 2 replies
- 14 kudos
- 1960 Views
- 0 replies
- 4 kudos
Optimizing a batch load process, reading with the JDBC driver
I am doing a batch load, using the JDBC driver from a database table. I am noticing in Sparkui, that there is both memory and disk spill, but only on one executor. I am also, noticing that when trying to use the JDBC parallel read, it seems to run sl...
- 1960 Views
- 0 replies
- 4 kudos
- 3305 Views
- 2 replies
- 4 kudos
Resolved! Error writing parquet to specific container in Azure Data Lake
I'm retrieving two files from container1, transforming them and merging before writing to a container2 within the same Storage Account in Azure. I'm mounting container1, unmouting and mounting countainer2 before writing. My code for writing the parqu...
- 3305 Views
- 2 replies
- 4 kudos
- 4 kudos
Hi @Magnus Asperud​ ,1 mounting container12 you should persist the data somewhere, creating df doesnt mean that you are reading data from container and have it accessible after unmounting. Make sure to store this merged data somewhere. Not sure if th...
- 4 kudos
- 3402 Views
- 3 replies
- 4 kudos
Resolved! cannot list all tokens with account admin
I'm trying to list all tokens (both user and service principal) for a given workspace; using an Account level admin I've tried both the CLI as well as the API endpoint to list tokens, however each time, only the admin's tokens are returned.I've confi...
- 3402 Views
- 3 replies
- 4 kudos
- 1660 Views
- 0 replies
- 0 kudos
Kaka stream on databricks via SCRAM-SHA-512 mecchanism and SASL_SSL protocal
I ma trying to stream kafka events on databricks but it keeps initializing for hours and don't give any output can someone help what is actually happening and why data is not publishing? I couldn't find anything for this on community.
- 1660 Views
- 0 replies
- 0 kudos
| User | Count |
|---|---|
| 1632 | |
| 791 | |
| 513 | |
| 349 | |
| 287 |
