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.
Is there any way to configure AWS Athena to add proper file extension?
Say `CTAS` query creates Parquet files but with no extension at all.
Accepted AnswerAmazon Athena
1
answers
0
votes
41
views
asked 5 days agolg...
I'm trying to update RDS mysql version
checking the compatibility report then showing below error
2) MySQL 8.0 syntax check for routine-like...
1
answers
0
votes
253
views
asked 5 days agolg...
I'm using an Amazon Aurora PostgreSql DB cluster and I am receiving the following error after a failover:
"PG::ReadOnlySqlTransaction: ERROR: cannot execute UPDATE in a read-only transaction"
I'm...
1
answers
1
votes
50
views
asked 6 days agolg...
can someone explain me the difference between scoped permission vs when we give permission to normal user
document is little bit tough to understand, if some one can explain the by comparing it with...
1
answers
0
votes
39
views
asked 6 days agolg...
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
36
views
asked 6 days agolg...
Hi everyone,
I continue to have problems with zero-ETL, which ends on its own in three days.
even though both sides of those services are currently active. Can someone please assist us with a...
1
answers
0
votes
42
views
asked 6 days agolg...
Hello,
I have parquets files in S3 that i parse using Glue Crawler and query in Athena. I found that some files have two columns "x" and "y" that have a type **int64** while other files have them as...
1
answers
0
votes
71
views
asked 6 days agolg...
Unable to push Glue job to GitHub. Empty connections list is now allowed if connection is specified.lg...
Hi,
I am trying to Push the Glue job to GitHub repo. I have got added the access permissions to my role as specified in...
3
answers
0
votes
66
views
asked 6 days agolg...
I have a 5.7.mysql_aurora.2.12.2 cluster and both cluster and instance are using default parameter group `default.aurora-mysql5.7`. After created and selected AuroraDB for MySQL8.0 compatible cluster...
1
answers
0
votes
86
views
asked 6 days agolg...
I am using aws lakeformation workflow to create a data lake following [this](https://docs.aws.amazon.com/lake-formation/latest/dg/getting-started-tutorial-jdbc.html) guide. everything is setup as...
0
answers
0
votes
67
views
asked 6 days 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
116
views
asked 6 days agolg...
Hi all,
Following this tutorial https://docs.aws.amazon.com/opensearch-service/latest/developerguide/configure-client-ddb.html.
I have shared opensearch pipeline configuration for sinking all dynamoDB...
0
answers
0
votes
78
views
asked 6 days agolg...