SparkSQL中posexplode高阶函数设置别名

• posexplode(t.names) as (`arr_pos`, `arr_value`)
• posexplode(t.names) as (arr_pos, arr_value)

spark.sql(
      """
        |with t_emp as(
        |select t.deptno,
        |       collect_list(t.ename) as names
        |  from emp t
        | group by t.deptno
        | )
        |select t.deptno, t.names, posexplode(t.names) as (`arr_pos`, `arr_value`)
        |  from t_emp t
        |""".stripMargin)
        .show(false)

+------+-------------------------------------------