python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - database-partitioning

Possible to modify an existing partitioned Oracle table to utilize INTERVAL?

We have an existing table w/ monthly partitions of data. The partitions are added, it appears, yearly, via {insert process here we're still researching}. Trouble came when {X} forgot to add the '22 ...
test-img

i_robot73

oracle

database-partitioning

Votes: 0

Answers: 0

Best way to automate addition of future partitions to a postgres table

I am unaware of the best practices involved in the automation of the addition of future partitions to a table. So the situation is like this: In the month of say, Dec 2021, we want to create partition...
test-img

Prabhatika Vij

postgresql

database-partitioning

Votes: 0

Answers: 1

Latest Answer

Option 1 is not sufficient, because you need a way to run the code automatically (that's the hard part). It doesn't matter much if you use PL/pgSQL or a client side language for the procedural parts o...
test-img

Laurenz Albe

How the hash function by partitioner in Cassandra is decided for a particular data set to ensure even distribution of data across multiple cluster?

As we know from Cassandra's documentation[Link to doc] that partitioner should be such that the data is distributed evenly across multiple nodes to avoid read hotspots. Cassandra offers various partit...
test-img

khush

cassandra

database-partitioning

distributed-database

murmurhash

Votes: 0

Answers: 1

Latest Answer

In short - it doesn't. It is a deterministic hash function with the partitioner, so the same value will result in the same hash value each time and position on the ring. If you design a data model whe...
test-img

Andrew

Yearly Partitioning a Integer column which stores Date as ID

I have a table which has a DATE_ID column (Integer data type). This column basically stores dates in ID format. Input data: DATE_ID 19961210 19991001 20051212 20090108 I need to part...
test-img

Vaibhav Gupta

oracle

oracle12c

database-partitioning

Votes: 0

Answers: 2

Latest Answer

I got the solution: CREATE TABLE test ( DATE_ID INTEGER ) partition BY RANGE (DATE_ID ) interval(10000) (partition p0 values less than(19961231), partition p1 values less than(19991231), partiti...
test-img

Vaibhav Gupta

Posts

Questions

Blogs

Jobs