All Questions
Tagged with database-partitioning partition
38 questions
1
vote
1
answer
199
views
Updating the sym column in a trade table
I would like to update my sym column in my trade table so that at the end of every sym there is a _1 appended onto the end of it.
I have tried update sym:sym _ "_1" from trade which gave me ...
- 11
0
votes
1
answer
125
views
Citus - Possible to undo citus's create_time_partitions results?
I'm working on a database with Citus and I would like to know if it's possible to undo the results made by executing create_time_partitions. I know that it is possible to "undistribute" a ...
- 132
0
votes
0
answers
288
views
Querying Partitioned Db2 Table
I am trying to select data from specific partitions of a DB2 Table.
I got this from the DB2 Catalog:
Partitioning Info for Table : GMMOM.FINDATA
Column Name Column Type Length Scale ...
- 21
0
votes
0
answers
803
views
PostgreSQL How to Switch/Exchange Partition?
I have been working on MSSQL and i am using Alter table switch partition command on MSSQL in some of my procedures.
How can i achive the same results on PostgreSQL with good performance?
Is there ...
0
votes
2
answers
5k
views
How to automate partition drop and alter table activity in oracle sql developer
I need a procedure that will help me to drop partition older than 3 months (current month + last 3 older months). And then I need to create the new partition in sequence.
for example if current ...
0
votes
1
answer
318
views
ORACLE - When splitting a partition, can I meanwhile still read data in it?
Statements
let say I have a schema partitioned by range of date (but no subpartitions)
let say I have partition P1 in this schema containing a lot of rows
at some point, let say I want to split it
as ...
- 89
0
votes
1
answer
270
views
Added Daily Partition before the insert
i have the following table
CREATE TABLE "ICTPART_DAILY_SUMMARY"
(
"EVENT_START_DATE" DATE
"ACCOUNTING_METHOD" CHAR(1),
......etc
)
...
- 11
0
votes
1
answer
701
views
Adding a Partition FOR 30 DAYS
I have the following table :
CREATE TABLE "ICTPART_DAILY_SUMMARY"
(
"EVENT_START_DATE" DATE
"ACCOUNTING_METHOD" CHAR(1),
......etc
)
PARTITION ...
- 11
6
votes
1
answer
1k
views
Initial extent size when converting to partitioned table
Working in an Oracle 19c database on Linux x86/64 trying to convert non-partitioned table to partitioned table.
Since Oracle12, alter table modify partition has been available to convert non-...
- 63
0
votes
1
answer
583
views
Oracle - How the rows are handled in partitioned table, if the respective interval is already dropped?
I have a existing table which is partitioned based on range partitioning
Schema :
create table History(
hid number(19,0),
type varchar2(255 char),
lastupdated timestamp (6) not null enable,
name ...
- 239
0
votes
1
answer
528
views
Non Distributed Data _ Spring Batch Partitioner
Just take a case where I am reading data from a Database with conditions (millions of rows), doing some business on data and then updating it.
I am using a Column Range Partitioner ( Id column ) ...
- 43
0
votes
2
answers
403
views
How to partition and find the most latest value in SQL
I have a table as follows:
ID | col1 | Date Time
1 | WA | 2/11/20
1 | CI | 1/11/20
2 | CI | 2/11/20
2 | WA | 3/11/20
3 | WA | 2/10/20
3 | WA | 1/11/20
3 | WA | 2/...
- 235
0
votes
2
answers
2k
views
mysql query using partition name vs where clause
I have a table partitioned by date.I noticed that when I query the table using the partition name it is faster as against querying using where clause.
Eg:
select max(db_load_timestamp) from ...
- 365
1
vote
1
answer
3k
views
How do I partition table over two columns?
Table T1 has cols - app_id,start_time,end_time,value.
We have multiple applications and would like to partition tables by app_id and start_time (weekly partitions).
This is how the child partitions ...
- 1,094
2
votes
1
answer
1k
views
MySQL partitioning based on the first letter of varchar field
I have a very similar problem asked in Partitioning table based on first letter of a varchar field for Postgres, however, I want to do this in mysql 5.7.
Is it possible to partition a table in MySQL ...
