Chapter 7 Wrong code in the window function example

[xuewei4d]

Spark-The-Definitive-Guide/code/Structured_APIs-Chapter_7_Aggregations.scala

Line 171 in 38e8814

dfWithDate.where("CustomerId IS NOT NULL").orderBy("CustomerId")

First, the column Quantity is parsed as String. It should be IntegerType.

Second orderBy(CustomerId) should be orderBy(desc(Quantity))

[bllchmbrs]

want to just open a pull request if you're seeing something wrong?

[shanmugavel04]

@xuewei4d
===> I ran the below command - dfWithDate.printSchema() resulted in Quantity as an IntegerType
root
|-- InvoiceNo: string (nullable = true)
|-- StockCode: string (nullable = true)
|-- Description: string (nullable = true)
|-- Quantity: integer (nullable = true)
|-- InvoiceDate: string (nullable = true)
|-- UnitPrice: double (nullable = true)
|-- CustomerID: integer (nullable = true)
|-- Country: string (nullable = true)
|-- date: date (nullable = true)
===> orderBy("CustomerId") or orderBy($"Quantity".desc) resulted in the same result.