doris数据库中字段是变量 去掉单引号问题

doris支持mysql的协议,在使用mybaits连接doris数据库时,为了考虑方法的兼容性,数据库表的字段是动态拼接的,在其他数据库中没问题
但是再doris会出错,那么如何去掉字段中自动增加的’单引号呢?

mapper.xml传输接收参数时,#号改成$符号就可以实现!
代码实例中

 <foreach item="value" collection="filters" index="">
                and #{value.attributeKey}
                ....
                </foreach>

改成:

 <foreach item="value" collection="filters" index="">
                and ${value.attributeKey}
                ....
                </foreach>
先mysql中有一个字段的值是[{"param_name":"db_code_src","param_value":"doris_dc","required":1,"description":"数据库代号,如不清楚,可联系管理员"},{"param_name":"sql","param_value":"SELECT GROUP_CONCAT(position_id,',') AS position_id\nFROM\n (\n SELECT t1.position_id,SUM(open_pv) AS open_pv\n FROM ads_hd.dm_ad_position_hourly t1\n JOIN ctl_mysql_media.ads_media.app_entrance t2 ON t2.position_id=t1.position_id\n WHERE thedate>=%year%%month%%day%@-169hour AND thedate<=%year%%month%%day%@-1hour\n AND CONCAT(thedate+0,thehour)>=%year%%month%%day%%hour%@-169hour\n AND CONCAT(thedate+0,thehour)<%year%%month%%day%%hour%@-1hour\n GROUP BY position_id\n ) t\nWHERE open_pv>0 AND open_pv<1000","required":1,"description":"查询hive表格中的数据"},{"param_name":"redis_host","param_value":"r-bp1d0291c2eba514202.redis.rds.aliyuncs.com","required":1,"description":"redis账号"},{"param_name":"redis_port","param_value":"6379","required":1,"description":"redis端口"},{"param_name":"redis_password","param_value":"bxm1122AdnewZ05A02542R","required":1,"description":"redis密码"},{"param_name":"redis_db","param_value":"0","required":1,"description":"redis数据库"},{"param_name":"key","param_value":"AD:NEW:POSITIONS","required":1,"description":"key中的变量值要和sql中的字段一样,并用{}括住:例子:k:{k1}:{k2}"},{"param_name":"field","param_value":"","required":0,"description":"field中的变量值要和sql中的字段一样,并用{}括住:例子:field:{field},非hashKey可以不填写"},{"param_name":"value","param_value":"{position_id}","required":0,"description":"value中的变量值要和sql中的字段一样,并用{}括住:例子:{\"k\":{v},如果value最外层是{},那就要多写成{{\"k\":{v}}}"},{"param_name":"expire","param_value":"","description":"过期时间,格式:5s, 5m, 5h分别代表秒,分,时","required":0},{"param_name":"delete_field","param_value":"","description":"删除的数据标记,例子:data_type:1","required":0}],这个字段值中包含多个json对象,想要把这些json对象拆分开
最新发布
03-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值