hive从ods_order_info表中搜索order_status=2的id与用户id并输出查询到的id与用户id建yizhifu表并以作为新表分隔符以gmall1_dataorder_infodata作为数据路径

CREATE TABLE yizhifu( order_id STRING, user_id STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/gmall1_data/order_info/data';

INSERT INTO TABLE yizhifu SELECT order_id, user_id FROM ods_order_info WHERE order_status = 2;