Apache Spark 3.0 support in Azure Synapse Analytics

Published May 25 2021 08:00 AM 6,223 Views
Microsoft
 

Starting today, the Apache Spark 3.0 runtime is now available in Azure Synapse. This version builds on top of existing open source and Microsoft specific enhancements to include additional unique improvements listed below. The combination of these enhancements results in a significantly faster processing capability than the open-source Spark 3.0.2 and 2.4.

 

The public preview announced today starts with the foundation based on the open-source Apache Spark 3.0 branch with subsequent updates leading up to a Generally Available version derived from the latest 3.1 branch.

 

euanga_3-1621922168385.png

 

 

Performance Improvements

In large-scale distributed systems, performance is never far from the top of mind, "to do more with the same" or "to do the same with less" are always key measures. In addition to the Azure Synapse performance improvements announced recently, Spark 3 brings new enhancements and the opportunity for the performance engineering team to do even more great work.

 

Predicate Pushdown and more efficient Shuffle Management build on the common performance patterns/optimizations that are often included in releases. The Azure Synapse specific optimizations in these areas have been ported over to augment the enhancements that come with Spark 3.

 

Adaptive Query Execution (AQE)

There is an attribute of data processing jobs run by data-intensive platforms like Apache Spark that differentiates them from more traditional data processing systems like relational databases. It is the volume of data and subsequently the length of the job to process it. It's not uncommon for queries/data processing steps to take hours or even days to run in Spark. This presents unique challenges and opportunities to take a different approach to optimize and access the data. Over several days the query plan shape can change as estimates of data volume, skew, cardinality, etc., are replaced with actual measurements.

 

Adaptive Query Execution (AQE) in Azure Synapse provides a framework for dynamic optimization that brings significant performance improvement to Spark workloads and gives valuable time back to data and performance engineering teams by automating manual tasks.

 

AQE assists with:

  • Shuffle partition tuning: This is a major source of manual work data teams deal with today.
  • Join strategy optimization: This requires human review today and deep knowledge of query optimization to tune the types of joins used based on actual rather than estimated data.

 

Dynamic Partition Pruning

One of the common optimizations in high-scale query processors is eliminating the reading of certain partitions, with the adage that the less you read, the faster you go. However, not all partition elimination can be done as part of query optimization; some require execution time optimization. This feature is so critical to the performance that we added a version of this to the Apache Spark 2.4 codebase used in Azure Synapse. This is also built into the Spark 3.0 runtime now available in Azure Synapse.

 

 

ANSI SQL

Over the last 25+ years, SQL has become and continues to be one of the de-facto languages for data processing; even when using languages such as Python, C#, R, Scala, these frequently just expose a SQL call interface or generate SQL code.

 

One of SQL's challenges as a language, going back to its earliest days, has been the different implementations by different vendors being incompatible with each other (including Spark SQL). ANSI SQL is generally seen as the common definition across all implementations. Using ANSI SQL leads to supporting the least amount of rework and relearning; as part of Apache Spark 3, there has been a big push to improve the ANSI compatibility within Spark SQL.

 

With these changes in place in Azure Synapse, the majority of folks who are familiar with some variant of SQL will feel very comfortable and productive in the Spark 3 environment.

 

Pandas

While we tend to focus on high-scale algorithms and APIs when working on a platform like Apache Spark, it does not diminish the value of highly popular and heavily used local-only APIs like pandas. In fact, for some time, Spark has included support for User Defined Functions (UDF's) which make it easier and more scalable to run these local only libraries rather than just running them in the driver process.

 

Given that ~70% of all API calls on Spark are Python, supporting the language APIs is critical to maximize existing skills. In Spark 3, the UDF capability has been upgraded to include a capability only available in newer versions of Python, type hints. When combined with a new UDF implementation, with support for new Pandas UDF APIs and types, this release supports existing skills in a more performant environment.

 

Accelerator aware scheduling

The sheer volume of data and the richness of required analysis have made ML a core workload for systems such as Apache Spark. While it has been possible to use GPUs together with Spark for some time, Spark 3 includes optimization in the scheduler, a core part of the system, brought in from the Hydrogen project to support more efficient use of (hardware) accelerators. For hardware-accelerated Spark workloads running in Azure Synapse, there has been deep collaboration with Nvidia to deliver specific optimizations on top of their hardware and some of their dedicated APIs for running GPUs in Spark.

 

Delta Lake

Delta Lake is one of the most popular projects that can be used to augment Apache Spark. Azure Synapse uses the Linux Foundation open-source implementation of Delta Lake. Unfortunately, when running on Spark 2.4, the highest version of Delta Lake that is supported is Delta Lake 0.6.1. By adding support for Spark 3, it means that newer versions of Delta Lake can be used with Azure Synapse. Currently, Azure Synapse is shipping with support for Linux Foundation Delta Lake 0.8.

 

The biggest enhancements in 0.8 versus 0.6.1 are primarily around the SQL language and some of the APIs. It is now possible to perform most DDL and DML operations without leaving the Spark SQL language/environment. In addition, there have been significant enhancements to the MERGE statement/API (one of the most powerful capabilities of Delta Lake) expanding scope and capability.

 

Get Started Today

Customers with *qualifying subscription types can now try the Apache Spark pool resources in Azure Synapse using free quantities until July 31st, 2021 (up to 120 free vCore-hours per month).

 

 

euanga_2-1621922107427.png

 

2 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-2382605%22%20slang%3D%22en-US%22%3EApache%20Spark%203.0%20support%20in%20Azure%20Synapse%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382605%22%20slang%3D%22en-US%22%3E%3CDIV%20id%3D%22tinyMceEditoreuanga_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%20background%3A%20white%3B%22%3EStarting%20today%2C%20the%26nbsp%3BApache%20Spark%203.0%20runtime%20is%20now%20available%20in%20Azure%20Synapse%3C%2FSPAN%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E.%20This%20version%20builds%20on%20top%20of%20existing%20open%20source%20and%20Microsoft%20specific%20enhancements%20to%20include%20additional%20unique%20improvements%20listed%20below.%20The%20combination%20of%20these%20enhancements%20results%20in%20a%20significantly%20faster%20processing%20capability%20than%20the%20open-source%20Spark%203.0.2%20and%202.4.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EThe%20public%20preview%20announced%20today%20starts%20with%20the%20foundation%20based%20on%20the%20open-source%20Apache%20Spark%203.0%20branch%20with%20subsequent%20updates%20leading%20up%20to%20a%20Generally%20Available%20version%20derived%20from%20the%20latest%203.1%20branch.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22euanga_3-1621922168385.png%22%20style%3D%22width%3A%20809px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283401i471BA502A2711186%2Fimage-dimensions%2F809x453%3Fv%3Dv2%22%20width%3D%22809%22%20height%3D%22453%22%20role%3D%22button%22%20title%3D%22euanga_3-1621922168385.png%22%20alt%3D%22euanga_3-1621922168385.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2022.5pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EPerformance%20Improvements%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20%23333333%3B%20background%3A%20white%3B%22%3EIn%20large-scale%20distributed%20systems%2C%20performance%20is%20never%20far%20from%20the%20top%20of%20mind%2C%20%22%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3Eto%20do%20more%20with%20the%20same%22%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23333333%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bor%20%22%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3Eto%20do%20the%20same%20with%20less%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23333333%3B%20background%3A%20white%3B%22%3E%22%20are%20always%20key%20measures.%20In%20addition%20to%20the%20Azure%20Synapse%20performance%20improvements%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-synapse-analytics%2Fapache-spark-in-azure-synapse-performance-update%2Fba-p%2F2243534%22%20target%3D%22_blank%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3Eannounced%20recently%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20style%3D%22color%3A%20%23333333%3B%20background%3A%20white%3B%22%3E%2C%20Spark%203%20brings%20new%20enhancements%20and%20the%20opportunity%20for%20the%20performance%20engineering%20team%20to%20do%20even%20more%20great%20work.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EPredicate%20Pushdown%20and%20more%20efficient%20Shuffle%20Management%20build%20on%20the%20common%20performance%20patterns%2Foptimizations%20that%20are%20often%20included%20in%20releases.%20The%20Azure%20Synapse%20specific%20optimizations%20in%20these%20areas%20have%20been%20ported%20over%20to%20augment%20the%20enhancements%20that%20come%20with%20Spark%203.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2018.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EAdaptive%20Query%20Execution%20(AQE)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EThere%20is%20an%20attribute%20of%20data%20processing%20jobs%20run%20by%20data-intensive%20platforms%20like%20Apache%20Spark%20that%20differentiates%20them%20from%20more%20traditional%20data%20processing%20systems%20like%20relational%20databases.%20It%20is%20the%20volume%20of%20data%20and%20subsequently%20the%20length%20of%20the%20job%20to%20process%20it.%20It's%20not%20uncommon%20for%20queries%2Fdata%20processing%20steps%20to%20take%20hours%20or%20even%20days%20to%20run%20in%20Spark.%20This%20presents%20unique%20challenges%20and%20opportunities%20to%20take%20a%20different%20approach%20to%20optimize%20and%20access%20the%20data.%20Over%20several%20days%20the%20query%20plan%20shape%20can%20change%20as%20estimates%20of%20data%20volume%2C%20skew%2C%20cardinality%2C%20etc.%2C%20are%20replaced%20with%20actual%20measurements.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EAdaptive%20Query%20Execution%20(AQE)%20in%20Azure%20Synapse%20provides%20a%20framework%20for%20dynamic%20optimization%20that%20brings%20significant%20performance%20improvement%20to%20Spark%20workloads%20and%20gives%20valuable%20time%20back%20to%20data%20and%20performance%20engineering%20teams%20by%20automating%20manual%20tasks.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%20text-decoration%3A%20underline%3B%20background%3A%20white%3B%22%3EAQE%20assists%20with%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%20style%3D%22margin-left%3A%20.375in%3B%20direction%3A%20ltr%3B%20unicode-bidi%3A%20embed%3B%20margin-top%3A%200in%3B%20margin-bottom%3A%200in%3B%22%20type%3D%22disc%22%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3EShuffle%20partition%20tuning%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3E%3A%20This%20is%20a%20major%20source%20of%20manual%20work%20data%20teams%20deal%20with%20today.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%20font-family%3A%20inherit%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3EJoin%20strategy%20optimization%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3E%3A%20This%20requires%20human%20review%20today%20and%20deep%20knowledge%20of%20query%20optimization%20to%20tune%20the%20types%20of%20joins%20used%20based%20on%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%20font-family%3A%20inherit%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3Eactual%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3E%26nbsp%3Brather%20than%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%20font-family%3A%20inherit%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3Eestimated%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bdata.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2018.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EDynamic%20Partition%20Pruning%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EOne%20of%20the%20common%20optimizations%20in%20high-scale%20query%20processors%20is%20eliminating%20the%20reading%20of%20certain%20partitions%2C%20with%20the%20adage%20that%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%20background%3A%20white%3B%22%3Ethe%20less%20you%20read%2C%20the%20faster%20you%20go%3C%2FSPAN%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E.%20However%2C%20not%20all%20partition%20elimination%20can%20be%20done%20as%20part%20of%20query%20optimization%3B%20some%20require%20execution%20time%20optimization.%20This%20feature%20is%20so%20critical%20to%20the%20performance%20that%20we%20added%20a%20version%20of%20this%20to%20the%20Apache%20Spark%202.4%20codebase%20used%20in%20Azure%20Synapse.%20This%20is%20also%20built%20into%20the%20Spark%203.0%20runtime%20now%20available%20in%20Azure%20Synapse.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2022.5pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EANSI%20SQL%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EOver%20the%20last%2025%2B%20years%2C%20SQL%20has%20become%20and%20continues%20to%20be%20one%20of%20the%20de-facto%20languages%20for%20data%20processing%3B%20even%20when%20using%20languages%20such%20as%20Python%2C%20C%23%2C%20R%2C%20Scala%2C%20these%20frequently%20just%20expose%20a%20SQL%20call%20interface%20or%20generate%20SQL%20code.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EOne%20of%20SQL's%20challenges%20as%20a%20language%2C%20going%20back%20to%20its%20earliest%20days%2C%20has%20been%20the%20different%20implementations%20by%20different%20vendors%20being%20incompatible%20with%20each%20other%20(including%20Spark%20SQL).%20ANSI%20SQL%20is%20generally%20seen%20as%20the%20common%20definition%20across%20all%20implementations.%20Using%20ANSI%20SQL%20leads%20to%20supporting%20the%20least%20amount%20of%20rework%20and%20relearning%3B%20as%20part%20of%20Apache%20Spark%203%2C%20there%20has%20been%20a%20big%20push%20to%20improve%20the%20ANSI%20compatibility%20within%20Spark%20SQL.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EWith%20these%20changes%20in%20place%20in%20Azure%20Synapse%2C%20the%20majority%20of%20folks%20who%20are%20familiar%20with%20some%20variant%20of%20SQL%20will%20feel%20very%20comfortable%20and%20productive%20in%20the%20Spark%203%20environment.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2022.5pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EPandas%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EWhile%20we%20tend%20to%20focus%20on%20high-scale%20algorithms%20and%20APIs%20when%20working%20on%20a%20platform%20like%20Apache%20Spark%2C%20it%20does%20not%20diminish%20the%20value%20of%20highly%20popular%20and%20heavily%20used%20local-only%20APIs%20like%20pandas.%20In%20fact%2C%20for%20some%20time%2C%20Spark%20has%20included%20support%20for%20User%20Defined%20Functions%20(UDF's)%20which%20make%20it%20easier%20and%20more%20scalable%20to%20run%20these%20local%20only%20libraries%20rather%20than%20just%20running%20them%20in%20the%20driver%20process.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EGiven%20that%20~70%25%20of%20all%20API%20calls%20on%20Spark%20are%20Python%2C%20supporting%20the%20language%20APIs%20is%20critical%20to%20maximize%20existing%20skills.%20In%20Spark%203%2C%20the%20UDF%20capability%20has%20been%20upgraded%20to%20include%20a%20capability%20only%20available%20in%20newer%20versions%20of%20Python%2C%20type%20hints.%20When%20combined%20with%20a%20new%20UDF%20implementation%2C%20with%20support%20for%20new%20Pandas%20UDF%20APIs%20and%20types%2C%20this%20release%20supports%20existing%20skills%20in%20a%20more%20performant%20environment.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2022.5pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EAccelerator%20aware%20scheduling%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20%23333333%3B%20background%3A%20white%3B%22%3EThe%20sheer%20volume%20of%20data%20and%20the%20richness%20of%20required%20analysis%20have%20made%20ML%20a%20core%20workload%20for%20systems%20such%20as%20Apache%20Spark.%20While%20it%20has%20been%20possible%20to%20use%20GPUs%20together%20with%20Spark%20for%20some%20time%2C%20Spark%203%20includes%20optimization%20in%20the%20scheduler%2C%20a%20core%20part%20of%20the%20system%2C%20brought%20in%20from%20the%20Hydrogen%20project%20to%20support%20more%20efficient%20use%20of%20(hardware)%20accelerators.%20For%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fsynapse-spark-gpu%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3Ehardware-accelerated%20Spark%20workloads%20running%20in%20Azure%20Synapse%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20style%3D%22color%3A%20%23333333%3B%20background%3A%20white%3B%22%3E%2C%20there%20has%20been%20deep%20collaboration%20with%20Nvidia%20to%20deliver%20specific%20optimizations%20on%20top%20of%20their%20hardware%20and%20some%20of%20their%20dedicated%20APIs%20for%20running%20GPUs%20in%20Spark.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2022.5pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EDelta%20Lake%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EDelta%20Lake%20is%20one%20of%20the%20most%20popular%20projects%20that%20can%20be%20used%20to%20augment%20Apache%20Spark.%20Azure%20Synapse%20uses%20the%20Linux%20Foundation%20open-source%20implementation%20of%20Delta%20Lake.%20Unfortunately%2C%20when%20running%20on%20Spark%202.4%2C%20the%20highest%20version%20of%20Delta%20Lake%20that%20is%20supported%20is%20Delta%20Lake%200.6.1.%20By%20adding%20support%20for%20Spark%203%2C%20it%20means%20that%20newer%20versions%20of%20Delta%20Lake%20can%20be%20used%20with%20Azure%20Synapse.%20Currently%2C%20Azure%20Synapse%20is%20shipping%20with%20support%20for%20Linux%20Foundation%20Delta%20Lake%200.8.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EThe%20biggest%20enhancements%20in%200.8%20versus%200.6.1%20are%20primarily%20around%20the%20SQL%20language%20and%20some%20of%20the%20APIs.%20It%20is%20now%20possible%20to%20perform%20most%20DDL%20and%20DML%20operations%20without%20leaving%20the%20Spark%20SQL%20language%2Fenvironment.%20In%20addition%2C%20there%20have%20been%20significant%20enhancements%20to%20the%20MERGE%20statement%2FAPI%20(one%20of%20the%20most%20powerful%20capabilities%20of%20Delta%20Lake)%20expanding%20scope%20and%20capability.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2022.5pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EGet%20Started%20Today%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3ECustomers%20with%26nbsp%3B*qualifying%20subscription%20types%20can%20now%20try%20the%20Apache%20Spark%20pool%20resources%26nbsp%3Bin%20Azure%20Synapse%20using%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Flimited-time-free-quantities-offer-for-azure-synapse-analytics%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3Efree%20quantities%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20style%3D%22font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3E%26nbsp%3Buntil%20July%2031%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3Est%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3E%2C%202021%26nbsp%3B(up%20to%20120%20free%20vCore-hours%20per%20month).%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%20style%3D%22margin-left%3A%20.375in%3B%20direction%3A%20ltr%3B%20unicode-bidi%3A%20embed%3B%20margin-top%3A%200in%3B%20margin-bottom%3A%200in%3B%22%20type%3D%22disc%22%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3EIf%20you%20don%E2%80%99t%20have%20one%20already%2C%20follow%20this%20tutorial%20to%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fquickstart-create-workspace%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3Ecreate%20a%20Synapse%20workspace%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3EFollow%20this%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dfi3g4N5zPBI%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20background%3A%20white%3B%22%3Estep-by-step%20video%20tutorial%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20style%3D%22font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bon%20how%20to%20create%20your%20first%20Apache%20Spark%20pool%20in%20Azure%20Synapse%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditoreuanga_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22euanga_2-1621922107427.png%22%20style%3D%22width%3A%20779px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283400iC9C5341CFF9337AA%2Fimage-dimensions%2F779x438%3Fv%3Dv2%22%20width%3D%22779%22%20height%3D%22438%22%20role%3D%22button%22%20title%3D%22euanga_2-1621922107427.png%22%20alt%3D%22euanga_2-1621922107427.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2382605%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%20background%3A%20white%3B%22%3EStarting%20today%2C%20the%26nbsp%3BApache%20Spark%203.0%20runtime%20is%20now%20available%20in%20Azure%20Synapse%3C%2FSPAN%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E.%20This%20version%20builds%20on%20top%20of%20existing%20open%20source%20and%20Microsoft%20specific%20enhancements%20to%20include%20additional%20unique%20improvements%20listed%20below.%20The%20combination%20of%20these%20enhancements%20results%20in%20a%20significantly%20faster%20processing%20capability%20than%20the%20open-source%20Spark%203.0.2%20and%202.4.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EThe%20public%20preview%20announced%20today%20starts%20with%20the%20foundation%20based%20on%20the%20open-source%20Apache%20Spark%203.0%20branch%20with%20subsequent%20updates%20leading%20up%20to%20a%20Generally%20Available%20version%20derived%20from%20the%20latest%203.1%20branch.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20SegoeUI%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22euanga_4-1621922192795.png%22%20style%3D%22width%3A%20770px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283402i0BD93DD72F8A105F%2Fimage-dimensions%2F770x431%3Fv%3Dv2%22%20width%3D%22770%22%20height%3D%22431%22%20role%3D%22button%22%20title%3D%22euanga_4-1621922192795.png%22%20alt%3D%22euanga_4-1621922192795.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2382605%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Spark%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2394515%22%20slang%3D%22en-US%22%3ERe%3A%20Apache%20Spark%203.0%20support%20in%20Azure%20Synapse%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394515%22%20slang%3D%22en-US%22%3E%3CP%3EReally%20happy%20to%20see%20this%20new%20functionality%20added%20to%20Azure%20Synapse%20Analytics.%20The%20advanced%20Delta%20Lake%20support%20as%20well%20as%20Spark%203.0%20with%20performance%20improvements%20is%20a%20welcome%20upgrade%20to%20the%20Azure%20Synapse%20environment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2449494%22%20slang%3D%22en-US%22%3ERe%3A%20Apache%20Spark%203.0%20support%20in%20Azure%20Synapse%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2449494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F880549%22%20target%3D%22_blank%22%3E%40euanga%3C%2FA%3E%2C%20that's%20great%20news.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20known%20limitations%2Fbugs%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Spark%202.4%20also%20visualization%20using%20Pandas%2FPlotly%2FSeaborn%20worked%20in%20Synapse%20notebooks%20(%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fspark%2Fapache-spark-data-visualization-tutorial%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fspark%2Fapache-spark-data-visualization-tutorial%3C%2FA%3E).%3C%2FP%3E%3CP%3EIf%20I%20run%20the%20same%20notebook%20on%20a%20Spark%203.0%20cluster%2C%20the%20cells%20are%20executed%20with%20no%20error%20but%20no%20chart%20is%20displayed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎May 25 2021 08:00 AM
Updated by: