1,113 questions
0
votes
1
answer
65
views
Partitioned Table - Query filtering on partition field
I have a large table which I want to move to a partitioned model. I created the partitioned table, same fields as the original and partioning by a particular timestamp field (by range). I then ...
- 101
0
votes
1
answer
33
views
How partition by custom hash function in MySql?
I am trying to create table like this:
CREATE TABLE `my_table` (
`query_id` varchar(255) NOT NULL,
PRIMARY KEY (`query_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
PARTITION BY hash (TO_DAYS(...
- 33.7k
0
votes
1
answer
41
views
How to use references to partitioned table in PostgreSQL?
I research declarative partitioning and prepared such query for partitioned table:
create table _my_message
(
id uuid not null,
chat_id uuid constraint _my_message_chat_fkey references _chat,
...
...
- 1,960
0
votes
1
answer
32
views
Does the partitioned table itself contain data with declarative partitioning? [closed]
I research declarative partitioning and prepared such code for it:
Created partitioned table:
create table _my_message
(
id uuid not null,
chat_id uuid constraint _my_message_chat_fkey references ...
- 1,960
1
vote
0
answers
30
views
Creating a table using partition projection in AWS Athena
I am trying to create a table on top of an S3 bucket that has the following structure:
s3://mybucket/productA/${model}/${qa}/${year}/${month}/${day}/
I created the table using the following SQL query:...
0
votes
3
answers
59
views
Oracle Partition in For Loop Select
I need to fetch all rows in a specific partition of a table and print the values to a file.
CREATE OR REPLACE PROCEDURE
WriteRecordToFile
(
mypartition IN VARCHAR2,
myfilename IN VARCHAR2,
...
- 33
2
votes
0
answers
25
views
alter table modify option to remove partitioning completely?
Oracle allows easy redefinition of partitioning schemes with the syntax alter table XYZ modify partition by ... which simplifies the task of either converting a non-partitioned table to a partitioned ...
- 12.2k
0
votes
0
answers
26
views
Jakarta @Version sql update version error
All entity with @version
During saving, have next error
could not execute statement [Not found 3 param.] [update cons_data.e_fin_form set version=? where id=? and report_type=? and version=?]; SQL [...
1
vote
1
answer
122
views
Why is MIN($column) doing an Index scan instead of seeking to min value?
I have a table with more than a billion rows, with one of the column definitions being:
row_id int NOT NULL
And an index on it
CREATE NONCLUSTERED INDEX row_id_IX ON dbo.test_table ( row_id ASC ) ...
- 570
0
votes
1
answer
36
views
Is partitioning the correct feature for periodical deletions in large tables?
If I have two tables in a (Oracle) database that keeps an history of records through time :
CREATE TABLE Records(
RecordPackId NUMBER,
RecordId NUMBER,
Data VARCHAR2(4000),
PRIMARY KEY ...
- 319
-1
votes
1
answer
82
views
Respect existing partitions and not create new
We have an existing database and a DACPAC-based deployment procedure to send it schema updates at deploy time. The database has an existing partition function and existing partition schemes, and the ...
- 6,281
0
votes
1
answer
85
views
automatic table partition when data insert
I have table which is contained list partition in postgres database
create table test(id int, name character varying) partition by list(id);
when I insert data, it is throwing an error.
insert into ...
- 1
2
votes
1
answer
145
views
Alternatives to partitioning by an ENUM column in MariaDB
For performance reasons, I would like to partition a table that I have based on an enum field. This table is expected to have a very large amount of data, and partitioning on this enum column makes a ...
- 4,796
0
votes
1
answer
70
views
Has anyone been able to use values regexp_like in partitioning by list in Oracle 19c?
I am attempting to partition a table based on a varchar2 column. I would like to partition it by 1) all alpha characters, 2) all numeric characters and 3) both alpha and numeric characters.
column to ...
0
votes
0
answers
108
views
When to vacuum freeze a partition of a postgres table?
I have a postgresql-12 database containing tables that are partitioned on timestamp column. So, rows with timestamp belonging in day N are inserted in a child table that is attached to the parent ...
- 301