Questions in Analytics
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.
I'm creating a role in AWS Glue to read CSV files from an S3 bucket. I'm granting full access to S3, but I can't seem to avoid this error. I contacted support, and they suggested increasing the usage...
0
answers
0
votes
11
views
asked 41 minutes agolg...
Hi,
I have a Glue which reads data from Database and database connection details like host, user name and password are stored in AWS secret manager. We have environment specific AWS secret manager...
0
answers
0
votes
13
views
asked 4 hours agolg...
Athena query failed with error:
```
Amazon Athena experienced an internal error while executing this query. Please try submitting the query again and if the issue reoccurs, contact AWS support for...
1
answers
0
votes
34
views
asked 11 hours agolg...
I have a RDS database that are running with t3.micro with gp2 storage, and I want to modify for magnetic, I will pay something for changing the type of the storage type? I try to do this some hours...
I have an RDS MySQL, which used my owner DB instance parameter group, where I have:
max_connections =6000
table_open_cache = 6000
thread_cache_size = 4000
require_secure_transport =...
0
answers
0
votes
44
views
asked 18 hours agolg...
ERROR: function convert_timezone("unknown", "unknown", timestamp with time zone) does not existlg...
I have a column with datatype "timestamp with time zone" in UTC. I want to convert it to EST while accounting for daylight savings time. If we call the column [col1], I have tried the query as...
0
answers
0
votes
11
views
asked 19 hours agolg...
Hi,
I have configuration:
- rds mysql 8.0.36 multi az deployment (active - standby)
- few instances of read-replica
I have configured job to scale in and scale out of my main database (to save $ after...
1
answers
0
votes
58
views
asked a day agolg...
I have an int stored in my s3 file and the table has int as a type. However, randomly athena seems to be adding a .0 to the end of the int for some files and not others and returning the following...
Accepted AnswerAmazon Athena
1
answers
0
votes
28
views
asked a day agolg...
Hi.. in case of using redshift multi AZ cluster, Is it possible to run a scheduled query on cluster maintanence time ?
1
answers
0
votes
16
views
asked a day agolg...
I have the following scenario :
- I have an Opensearch domain A in AWS account A
- I have another Opensearch domain B in AWS account B
- I would like to take a snapshot in domain A and then restore it...
AWS Glue 4.0 support Apache Hudi 0.12.1 version. What steps can I follow to upgrade the version of Hudi to 0.14 in AWS Glue 4.0
2
answers
0
votes
36
views
asked a day agolg...
This was working before, as recently as a week or two ago but Athena now fails with "INVALID_PARAMETER_USAGE: Incorrect number of parameters: expected 207 but found 0." when the query has more than...
0
answers
0
votes
28
views
asked a day agolg...