gunli opened a new issue #237: REPALCE聚合类型的字段的数据导入只支持导入第一条吗?
URL: https://github.com/apache/incubator-doris/issues/237
 
 
   **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)覆盖前面的。
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to