Hive Sql 行转多列实际案例

1、行转多列实际案例

 1 SELECT MR_Longitude,MR_Latitude,b,MAX(a) FROM
 2 (
 3 select a,b,
 4 MR_Longitude * 360 *1.0/ 16777216 MR_Longitude,
 5 MR_Latitude * 90 / 8388608 MR_Latitude
 6 FROM etl_4g_mro_zte 
 7 lateral view explode(
 8 split(concat_ws(',',MR_LteScRSRP,MR_LteNcRSRP1,MR_LteNcRSRP2,MR_LteNcRSRP3,MR_LteNcRSRP4,MR_LteNcRSRP5),','))r1 AS a             -----没有','
 9 lateral view explode(
10 split(concat_ws(',',MR_LteScEarfcn,MR_LteNcEarfcn1,MR_LteNcEarfcn2,MR_LteNcEarfcn3,MR_LteNcEarfcn4,MR_LteNcEarfcn5),',')) f1 as b
11
12 WHERE MR_Longitude IS NOT NULL 
13 AND MR_Longitude <>''
14 AND DAY=20170323

注： 行转多列可以认为多列是一个字段处理，多个转换之间不能有 "，" 分割开

转载于:https://www.cnblogs.com/Swidasya/p/7482629.html