我有一个JSON看起来像:
[ {
"metric_name" : "ga:bounces",
"metric_value" : "16",
"report_date" : "20210625",
"utm_campaign" : "retail_group",
"utm_source" : "(direct)",
"utm_content" : "(not set)",
"utm_term" : "(not set)",
"utm_medium" : "search"
}, {
"metric_name" : "ga:sessionDuration",
"metric_value" : "1576.0",
"report_date" : "20210625",
"utm_campaign" : "rb_olv",
"utm_source" : "google",
"utm_content" : "(not set)",
"utm_term" : "(not set)",
"utm_medium" : "cpc"
}]我想要的:
[ {
"metric_name" : "ga:bounces",
"metric_value" : "16",
"report_date" : "20210625",
"utm_marks" : "utm_campaign=retail_group&utm_medium=search"
}, {
"metric_name" : "ga:sessionDuration",
"metric_value" : "1576.0",
"report_date" : "20210625",
"utm_marks" : "utm_campaign=rb_olv&utm_source=google&utm_medium=cpc"
}]如果一些UMT值在()中,我应该忽略它(键+值),它可以是(none),(direct),(not provided),(not set)
我试着用QueryRecord
SELECT
metric_name,
metric_value,
'utm_campaign=' || utm_campaign || '&utm_source=' || utm_source || '&utm_medium=' || utm_medium || '&utm_term=' || utm_term || '&utm_content=' || utm_content as utm_marks
FROM FLOWFILE但是它不会截断像(none)、(direct)这样的值。我如何改进语句?
发布于 2021-07-14 23:52:02
QueryRecord使用Apache Calcite进行SQL解析/评估,看看它们的CASE语句,您也许可以执行类似CASE WHEN utm_source != '(not set)' THEN '&utm_source=' || utm_source ELSE '' END的操作
https://stackoverflow.com/questions/68360453
复制相似问题