参考:named_struct类型怎么用-CSDN博客
set -eu
sh datax_run.sh \
-src hdfs \
-srcdb ads_trnintldb \
-srctblnames adm_intltrn_res_global_domestic_line_hotdata \
-querys "select to_json(named_struct(
'data_domain',data_domain
,'type',type
,'period' ,period
,'channel' ,channel
,'departure_location_code_country_code' ,departure_location_code_country_code
,'departure_location_name' ,departure_location_name
,'arrival_location_code_country_code' ,arrival_location_code_country_code
,'arrival_location_name',arrival_location_name
,'id_cnt' ,id_cnt
,'rank_no' ,rank_no
,'departure_location_code' ,departure_location_code
,'arrival_location_code' ,arrival_location_code
)) as body from adm_intltrn_res_global_domestic_line_hotdata WHERE d = '${zdt.format("yyyy-MM-dd")}' " \
-tar qmq \
-writer_subject "train.triptrain.line.station.order.update.notify" \
-tarcolorders "body" \
-qps 100 \
-exportfileformat ORCFILE