- 6684 Views
- 7 replies
- 3 kudos
Resolved! Delta Live Tables error pivot
I'm facing an error in Delta Live Tables when I want to pivot a table. The error is the following: And the code to replicate the error is the following:import pandas as pd import pyspark.sql.functions as F pdf = pd.DataFrame({"A": ["foo", "foo", "f...
- 6684 Views
- 7 replies
- 3 kudos
- 3 kudos
Hi, Was this a specific design choice to not allow Pivots in DLT? I'm under the impression they expect fixed table structures in DLT design for a reason, but I don't understand the reason? Conceptually, I understand the fixed structures makes lineage...
- 3 kudos
- 4207 Views
- 6 replies
- 3 kudos
Resolved! I am looking to use the pivot function with Spark SQL (not Python)
Hello. I am trying to using the Pivot function for email addresses. This is what I have so far:Select fname, lname, awUniqueID, Email1, Email2From xxxxxxxxPivot ( count(Email) as Test For Email In (1 as Email1, 2 as Email2) )I get everyth...
- 4207 Views
- 6 replies
- 3 kudos
- 3 kudos
source data:fname lname awUniqueID EmailJohn Smith 22 jsmith@gmail.comJODI JONES 22 jsmith@live.comDesired output:fname lname awUniqueID Em...
- 3 kudos