Hive SQL 语句优化：获取用户 ID、自然用户 ID 和省份 ID

SELECT u.user_id, u.natural_cust_id, u.prov_id\nFROM zq_dwa.dwa_m_cus_al_cb_user_info u\nINNER JOIN\n(SELECT a.natural_cust_id, b.cust_level\nFROM zq_dwa.dwa_m_cus_al_cb_user_info a\nLEFT JOIN zq_dwa.dwa_m_cus_al_list_nat_info b ON a.natural_cust_id = b.nature_id\nWHERE b.cust_level = '0'\n\nUNION ALL\n\nSELECT a.prov_id, a.natural_cust_id, b.cust_level\nFROM zq_dwa.dwa_m_cus_al_cb_user_info a\nLEFT JOIN zq_dwa.dwa_m_cus_al_list_nat_info b ON a.prov_id = b.prov_id AND a.natural_cust_id = b.nature_id\nWHERE b.cust_level = '1') t\nON u.user_id = t.user_id AND u.natural_cust_id = t.natural_cust_id AND u.prov_id = t.prov_id\nGROUP BY u.natural_cust_id\nORDER BY u.total_fee\nLIMIT 50;