自定义Spark启动的metastore_db和derby.log生成路径

CREATE TABLE purchase_analysis AS > SELECT > get_json_object(log_line, '$.phoneNumber') AS user_id, > get_json_object(log_line, '$.productId') AS product_id, > CAST(get_json_object(log_line, '$.shopPrice') AS INT) AS price, > from_unixtime(unix_timestamp( > get_json_object(log_line, '$.times'), > 'yyyy-MM-dd HH:mm:ss' > )) AS purchase_time, > get_json_object(log_line, '$.title') AS product_name > FROM raw_purchase_logs; Query ID = root_20250423042001_d8f007cb-c053-4e7e-82aa-0683940fb16f Total jobs = 3 Launching Job 1 out of 3 Number of reduce tasks is set to 0 since there's no reduce operator Starting Job = job_1745405696032_0002, Tracking URL = http://hadoop01:8088/proxy/application_1745405696032_0002/ Kill Command = /home/hadoop03/hadoop/hadoop-3.3.4/bin/mapred job -kill job_1745405696032_0002 Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0 2025-04-23 04:20:17,326 Stage-