hive 第三次作业

作业1:
select sex, firstactivetime, to_date(firstactivetime) as fdt, datediff(‘2021-05-23’,to_date(firstactivetime)) > 300 from user_info;
作业2：
select sex, get_json_object(extra1, ‘$.education’) as education from user_info;

作业3:select from_unixtime(pay_time,’yyyy-MM-dd hh:mm:ss’), goods_category, pay_amount from user_trade where dt between ‘2019-01-01’ and ‘2019-04-30’ ;