You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/05/30 03:30:23 UTC
[GitHub] [incubator-doris] Kikyou1997 opened a new issue, #9841: [Bug] Unable to query data of new added partition when set partition_prune_algorithm_version = 2.
Kikyou1997 opened a new issue, #9841:
URL: https://github.com/apache/incubator-doris/issues/9841
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
1.0
### What's Wrong?
When we partition a table by some columns which contains a TEXT type column, and insert some data to those partitions.Then, we just restart the FE and add some new partition to this table, then insert data to those new added partition. At this time point, if we execute any query which results should contain the new inserted data, the returned result from FE would miss all the new inserted data of new added partition.
### What You Expected?
Result set should contain the data of new added partition
### How to Reproduce?
As described above, here I will give an example.
1.
```sql
CREATE TABLE `case_table` (
`c_date_col` date NOT NULL,
`c_text_col` text NOT NULL
) ENGINE=OLAP
UNIQUE KEY(`c_date_col`, `c_text_col`)
PARTITION BY LIST(`c_date_col`, `c_text_col`)
(
PARTITION p_20000101_day values in (("2000-01-01","day"))
)
DISTRIBUTED BY HASH(`c_date_col`, `c_text_col`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2"
);
```
2. insert some data to partition p_20000101_day...
3. Restart FE
4.
```sql
alter table ads_keep_polaris_user_composite_indexs add partition p_20000102_day values in (("2000-01-02","day"));
```
5. insert some data to partition p_20000102_day...
6. Execute any query contains a filter with partition keys.
### Anything Else?
No
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] Kikyou1997 closed issue #9841: [Bug] Unable to query data of new added partition when set partition_prune_algorithm_version = 2.
Posted by GitBox <gi...@apache.org>.
Kikyou1997 closed issue #9841: [Bug] Unable to query data of new added partition when set partition_prune_algorithm_version = 2.
URL: https://github.com/apache/incubator-doris/issues/9841
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org