Questions tagged with Database
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
16
views
asked 11 hours agolg...
Trying to connect to redshift database in python shell jobs. Tried with packages like psycopg2, redshift connector and pg. All of them gave similar error, hence I'm assuming problem is to establish...
1
answers
0
votes
54
views
asked 20 hours agolg...
I've been getting a slew of INSUFFICIENT errors from CloudFront in the last week.
I'm attempting to use Athena to discover what is happening with these 5xx Error Rates. I have a database already...
2
answers
0
votes
38
views
asked a day agolg...
l have created a test mysql database but l am failing to connect using mysql navicat. l am getting this error.
2002 - Can't connect to server on...
1
answers
0
votes
68
views
asked 4 days agolg...
Hi,
I am trying to get oracle_fdw working for PostgreSQL-Aurora to access an on-prem OracleDB following this...
4
answers
0
votes
55
views
asked 4 days agolg...
Approach for Client-Side Encryption with AWS KMS, Separate Keys for Each Column, and Key Rotationlg...
I'm working on implementing client-side encryption in my application, using AWS KMS for key generation. I aim to have a separate key for each column that needs encryption, and the encryption process...
1
answers
0
votes
64
views
asked 4 days agolg...
Can I restore the IBM db2(9.7) dump file to the newly created IBM db2(11.5) server directly?
2
answers
0
votes
219
views
asked 5 days agolg...
I have a dump file of IBM DB2 and want to restore it to a newly created IBM DB2 RDS server. Which tool should I use to restore it?
1
answers
0
votes
236
views
asked 5 days agolg...
I am downsizing my RDS instances, and for example I had a machine with 8GB Ram with 6 GB of free memory and then after I modify this database to a 4GB Ram machine, I could see in the monotoring...
3
answers
0
votes
56
views
asked 5 days agolg...
Hello
I am running Document DB of engine version 5.00 in production account.
Around 4:57 a.m. (KST) on April 24 (DB cluster maintenance period)
We received a notification that the connection with the...
0
answers
0
votes
30
views
asked 5 days agolg...
I'm using AWS RDS, and in my MYSQL (>8.0) database, the SYSTEM_VARIABLES_ADMIN permission for all users is deleted every 10 minutes. It wasn't deleted originally, but it's suddenly being deleted, and...
4
answers
2
votes
199
views
asked 5 days agolg...
SELECT *
FROM tvseso_h
WHERE DATE(tvseso_h.call_creation_date) BETWEEN ? AND ?;
the call_creation_date datatype in source table is in TIMESTAMP and when i created the view as tvseso_h for the same...
0
answers
0
votes
60
views
asked 6 days agolg...