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
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
8 reads
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
49 reads
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
48 reads
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
425 reads
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
47 reads
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
9 reads
in my last post I wrote about thinking of the tools as being a separate thing from the event. Not a complicated concept, but does it matter? Maybe. Let...
2021-01-16
6 reads
I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it to. I put a lot...
2021-01-16
5 reads
I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it to. I put a lot...
2021-01-16
178 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers