(PARTITION BY accountNo ORDER BY orderNo) AS accountRank
FROM accountOrders
)
P.S – You will need to check the above query for any syntax errors.
– Shiva
From: Sonu Jyotshna
Sent: Saturday, February 9, 2019 10:17 AM
To: user@spark.apache.org
Subject: Multiple column
Hello,
I have a requirement where I need to group by multiple columns and
aggregate them not at same time .. I mean I have a structure which contains
accountid, some cols, order id . I need to calculate some scenarios like
account having multiple orders so group by account and aggregate will work