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'm using MERGE INTO with UPDATE on top of ICEBERG.
For example
`MERGE INTO accounts t USING monthly_accounts_update s
ON (t.customer = s.customer)
WHEN MATCHED
THEN UPDATE SET...
0
answers
0
votes
153
views
asked 5 months agolg...
The goal is to create a temp table with consecutive numbers from 1 to 25567.
I tried this SQL statements:
-- Create temp table
DROP TABLE IF EXISTS numbers;
CREATE TEMP TABLE numbers
...
1
answers
0
votes
198
views
asked 5 months agolg...
Using SQL Alchemy ORM to query an AWS athena database. First off, here is the raw SQL query, which is working perfectly
```sql
WITH zi AS (SELECT
trip.start_dt,
address.zone_id
FROM...
1
answers
0
votes
466
views
asked 5 months agolg...
I had a MySQL RDS DB Instance but now I cannot see it supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com
and I caanot access it.
I had some past due billing for 2 months but I have already...
1
answers
0
votes
201
views
asked 5 months agolg...
I am tring to import data in my sql database manged by light sail, it gives me error of
22:10:33 Restoring saral_lagani_db (annual_report_link)
Running: mysql.exe...
1
answers
0
votes
183
views
asked 5 months agolg...
I wanted to upgrade the mysql engine from 5.7 to 8.0, but I got the error 'The parameter value for lower_case_table_names can't be changed for MySQL 8.0 DB instances.' I've very carefully checked that...
2
answers
0
votes
320
views
asked 5 months agolg...
Hi,
I'm using Athena Table - ICEBERG type.
I would like to update with Select statement in order to update bunch of records at a time. For example:
`UPDATE skus_market_share_sum1
SET...
2
answers
0
votes
537
views
asked 5 months agolg...
I am using Athena together with SQL Alchemy ORM. I just created a table (for testing some machine learning model integration) and pushed some data to it using SQL Alchemy ORM. But unfortunately, I can...
1
answers
0
votes
600
views
asked 5 months agolg...
Hi,
I created ICEBERG table by using CTAS command.
By mistake I deleted the Parquet files and afterwards tried to drop the table.
Now once I'm trying to delete the table I'm getting the following...
1
answers
0
votes
422
views
asked 5 months agolg...
Hi everyone,
I would like some help in connecting to RDS using SQL management studio. For some reason, I cannot connect but works fine when doing nslookup and telnet through EC2 to connect to my...
3
answers
0
votes
286
views
asked 5 months agolg...
Hi
Started a WordPress site on ec2.
The problem is as the amount data stored increases the site is not loading.
Site loads only after an increase in instance.
The same pattern is repeated after...
2
answers
0
votes
208
views
asked 5 months agolg...
Hello,
I will try to explain as briefly as possible.
We have a MySQL Aurora 8.0 server(version 3.05.1 if you want to reproduce it), where the server default variable value for autocommit is set to...
1
answers
0
votes
287
views
asked 5 months agolg...