Member since
07-24-2024
2
Posts
2
Kudos Received
0
Solutions
11-28-2024
08:07 AM
1 Kudo
Hi Ryan, thank you for your quick reply. I'll try the proposed solution, at least because it seems to be the only one to solve the situation. Thanks again
... View more
11-27-2024
03:45 AM
1 Kudo
Hi at all, I got a timeseries table with existing range partitions based on timestamp field, that covers years from 2022 to 2024 month by month. The problem is that last partition has an open bound (PARTITION 1717200000000 <= VALUES) and contains data from "1717200000000" (Saturday, June 1, 2024 0:00:00) to now, and is still storing live data with obviously performance loss during query. From the docs I haven't found a command that lets me split last partition in other partitions in order to update them, but the only way seems to drop last partition and continue adding since this time, and the problem is that by dropping last partition I will lose three and more months of data, that is obviously not possible. Is there an alternative to prevent data loss and adding range partitions to improve performances? Thanks in advance
... View more
Labels:
- Labels:
-
Apache Kudu