Hive中inline(array(struct))直接解析struct结构中的内容

从struct 类型的 named_struct_1字段 解析其中内容：page_id, page_name, log_date

create table tmp_user_scan_info_struct_mid stored as orc as
select 
    uid,
    named_struct('page_id', page_id, 
                 'page_name', page_name, 
                 'log_date', log_date
                 ) as named_struct_1
from tmp_user_scan_info;

select * from tmp_user_scan_info_struct_mid;
+------+---------------------------------------------------------+--+
| uid  |                     named_struct_1                      |
+------+---------------------------------------------------------+--+
| 0    | {
  
  "page_id":10,"page_name":"A","log_date":"2015-01-01"}  |
| 0    | {
  
  "page_id":20,"page_name":"B","log_date":"2015-01-02"}  |
| 1    | {
  
  "page_id":10,"page_name":"A","log_date":"2016-02-01"}  |
| 1    | {
  
  "page_id":20,"page_name":"B","log_date":"2016-02-02"}  |
+------+---------------------------------------------------------+--+

select
    uid,
    page_id,
    page_name,
    log_date
from tmp_user_scan_info_struct_mid t
lateral <