**Describe the bug**
REPLACE聚合类型的字段导入多条数据时只导入了第一条。

**To Reproduce**
Steps to reproduce the behavior:
1. 用Palo v0.8.2版本搭建单FE和单BE的测试环境;
2. 创建testDb.testTable表如下:
```sql

CREATE TABLE `testTable` (
  `k1` bigint(20) COMMENT "",
  `k2` varchar(100) COMMENT "",
  `v` bigint(20) REPLACE COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`k1`, `k2`)
DISTRIBUTED BY HASH(`k1`) BUCKETS 8
PROPERTIES (
"storage_type" = "COLUMN"
); 
```
3. 导入如下数据curl --location-trusted -u root: -T palo_test_data.log 
"http://x.x.x.x:yyyy/api/testDb/testTable/_load?label=7_label&column_separator=%2c";
```txt
100,t1,80000
200,t2,300
300,t3,5000
400,t4,2000
500,t5,1000000
600,t6,60000
100,t1,900000
100,t1,20000
```
4. 查询数据,key为100,t1的数据只有第一条80000
```sql
mysql> select * from testTable;
+------+------+---------+
| k1   | k2   | v       |
+------+------+---------+
|  200 | t2   |     300 |
|  600 | t6   |   60000 |
|  300 | t3   |    5000 |
|  400 | t4   |    2000 |
|  100 | t1   |   80000 |
|  500 | t5   | 1000000 |
+------+------+---------+
6 rows in set (0.13 sec)
```

**Expected behavior**
期望是最后一条记录(100,t1,20000)覆盖前面的。



[ Full content available at: 
https://github.com/apache/incubator-doris/issues/237 ]
This message was relayed via gitbox.apache.org for [email protected]

Reply via email to