【 TiDB 使用环境】生产环境
【 TiDB 版本】7.1 spark版本3.2.4
【复现路径】
表结构
| delivery_budget_business | CREATE TABLE delivery_budget_business (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘id’,
delivery_id bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘交付项目ID’,
budget_id bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘预算ID’,
quote_id bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘报价ID’,
pda_id bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘预算项ID’,
product_name varchar(200) NOT NULL DEFAULT ‘’ COMMENT ‘产品’,
pda_amount decimal(18,6) DEFAULT NULL COMMENT ‘报价金额’,
pda_tax_rate decimal(18,6) DEFAULT NULL COMMENT ‘税率(%)’,
tax_rate decimal(18,6) DEFAULT NULL COMMENT ‘税率(%)’,
pda_exchange_date date DEFAULT NULL COMMENT ‘概算汇率日期’,
create_by bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘创建者’,
update_by bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘更新者’,
gmt_create timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
gmt_modify timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘修改时间’,
pda_exchange decimal(18,6) DEFAULT NULL COMMENT ‘概算汇率’,
exchange decimal(18,6) DEFAULT NULL COMMENT ‘预算汇率’,
exchange_date date DEFAULT NULL COMMENT ‘预算汇率日期’,
maintenance_product tinyint(4) DEFAULT NULL COMMENT ‘1是维保产品 0不是维保产品’,
PRIMARY KEY (id) /*T![clustered_index] CLUSTERED */,
KEY idx_delivery (delivery_id),
KEY idx_budget (budget_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=110217 COMMENT=‘预算-商务信息’ |
tispark 版本
查询方式，如图
一个SQL中
pda_amount/(1+tax_rate/100) 字段能正常显示
但是sum（pda_amount/(1+tax_rate/100)）即不显示值
如果去除group by又可以显示