使用createOrReplaceTempView
products.createOrReplaceTempView("products")
val q1 = spark.sql("SELECT PERCENTILE(product_price, 0.25) FROM products")
如果使用global temp view
products.createGlobalTempView("products")
val q1 = spark.sql("SELECT PERCENTILE(product_price, 0.25) FROM global_temp.products").map(_.getAs[Double](0)).collect.apply(0)
sql后面需要加上global_tem