从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,