Synapse Analytics and .NET for Apache Spark Example 3 - CTE()
The next example is how to do a CTE (Common Table Expression). When creating the CTE I will also rename one of the columns from “dataType” to “x”.
T-SQL WITH...
2021-01-19
3 reads
Ed Elliott's Sql Developer Blog
Synapse Analytics Spark Example 2 - ROW_NUMBER()
The next example is how to do a ROW_NUMBER(), my favourite window function.
T-SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data Spark SQL SELECT *, ROW_NUMBER() OVER(ORDER...
2021-01-18
404 reads
Synapse Analytics and .NET for Apache Spark Example 2 - ROW_NUMBER()
The next example is how to do a ROW_NUMBER(), my favourite window function.
T-SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data Spark SQL SELECT *, ROW_NUMBER() OVER(ORDER...
2021-01-18
42 reads
Synapse Analytics and .NET for Apache Spark Example 2 - ROW_NUMBER()
The next example is how to do a ROW_NUMBER(), my favourite window function.
T-SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data Spark SQL SELECT *, ROW_NUMBER() OVER(ORDER...
2021-01-18
2 reads
Synapse Analytics Spark Example 1 - Group By
I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move to Apache Spark. Synapse Analytics...
2021-01-18
38 reads
Synapse Analytics and .NET for Apache Spark Example 1 - Group By
I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move to Apache Spark. Synapse Analytics...
2021-01-18
6 reads
Synapse Analytics and .NET for Apache Spark Example 1 - Group By
I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move to Apache Spark. Synapse Analytics...
2021-01-18
2 reads
How to get data in a DataFrame via .NET for Apache Spark
When I first started working with Apache Spark, one of the things I struggled with was that I would have some variable or data in my code that I...
2021-01-17
38 reads
How to get data in a DataFrame via .NET for Apache Spark
When I first started working with Apache Spark, one of the things I struggled with was that I would have some variable or data in my code that I...
2021-01-17
1 reads
Git in 10 commands to do 99% of gitting and keeping out of trouble
Git is hard, probably harder than it needs to be but I have been using it for about 5 years and have a workflow that works for me. I...
2021-01-18 (first published: 2021-01-12)
1,013 reads
Blogs
Spark Connect Dotnet Variant Data Type
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
A New Word: Opia
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
Friday Flyway Tips: Searching a Migration
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Forums
Table Partitioning SQL server 2022
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
STRING_AGG's behavior
Comments posted to this topic are about the item STRING_AGG's behavior
The Role of Databases in the Era of AI
Comments posted to this topic are about the item The Role of Databases in...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;