I have a huge amount of data in a few oracle tables (the total size of data in these tables is around 50GB). I have to perform joins and perform some calculations, and these tables don't have any partitions created. I need to read this data in pyspark data frame, and finally write the CSV file into s3. It's taking a long time to run this query on the database, fetch the data and directly write to s3 (the fetched data, based on the query, is around 100MB only).
Can using repartition on this data frame help me in any way to improve the query performance?
Or is there any other way to make this operation faster?
using repartion in pyspark for huge set of data
142 Views Asked by Sidhant Gupta At
0
There are 0 best solutions below
Related Questions in APACHE-SPARK
- Getting error while running spark-shell on my system; pyspark is running fine
- ingesting high volume small size files in azure databricks
- Spark load all partions at once
- Databricks Delta table / Compute job
- Autocomplete not working for apache spark in java vscode
- How to overwrite a single partition in Snowflake when using Spark connector
- Parse multiple record type fixedlength file with beanio gives oom and timeout error for 10GB data file
- includeExistingFiles: false does not work in Databricks Autoloader
- Spark connectors from Azure Databricks to Snowflake using AzureAD login
- SparkException: Task failed while writing rows, caused by Futures timed out
- Configuring Apache Spark's MemoryStream to simulate Kafka stream
- Databricks can't find a csv file inside a wheel I installed when running from a Databricks Notebook
- Add unique id to rows in batches in Pyspark dataframe
- Does Spark Dynamic Allocation depend on external shuffle service to work well?
- Does Spark structured streaming support chained flatMapGroupsWithState by different key?
Related Questions in PYSPARK
- Troubleshoot .readStream function not working in kafka-spark streaming (pyspark in colab notebook)
- ingesting high volume small size files in azure databricks
- Spark load all partions at once
- Tensorflow Graph Execution Permission Denied Error
- How to overwrite a single partition in Snowflake when using Spark connector
- includeExistingFiles: false does not work in Databricks Autoloader
- I want to monitor a job triggered through emrserverlessstartjoboperator. If the job is either is success or failed, want to rerun the job in airflow
- Iteratively output (print to screen) pyspark dataframes via .toPandas()
- Databricks can't find a csv file inside a wheel I installed when running from a Databricks Notebook
- Graphframes Pyspark route compaction
- Add unique id to rows in batches in Pyspark dataframe
- PyDeequ Integration with PySpark: Error 'JavaPackage' object is not callable
- Is there a way to import Redshift Connection in PySpark AWS Glue Job?
- Filter 30 unique product ids based on score and rank using databricks pyspark
- Apache Airflow sparksubmit
Related Questions in APACHE-SPARK-SQL-REPARTITION
- Last SPARK Task taking forever to complete
- Spark SQL repartition before insert operation
- Spark SQL correlated subquery not identifying parent columns
- Shuffle map stage failure with indeterminate output: eliminate the indeterminacy by checkpointing the RDD before repartition
- Use Spark coalesce without decreasing earlier operations parallelism
- repartition in memory vs file
- Hanging Task in Databricks
- If I repartition by column name does spark understand that it is repartitioned by that column when it is read back
- How to export SQL files in Synapse to sandbox environment or directly access these SQL files via notebooks?
- PySpark Performance slow in Reading large fixed width file with long lines to convert to structural
- Spark number of input partitions vs number of reading tasks
- understanding spark.default.parallelism
- What is the difference between spark.shuffle.partition and spark.repartition in spark?
- spark repartition issue for filesize
- Join 2 large size tables (50 Gb and 1 billion records)
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?