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 need to find the difference between two timestamp range. I tried using DATEDIFF but not getting the exact result. Below is the query I am using:
```
select
rtrim(datediff(hour,'2024-05-15...
1
answers
0
votes
262
views
asked 12 days agolg...
I'm having the same issue. Data is stored in below format in s3 as JSON array with partitions
S3 path - s3://fleet-fuelcard-data-import-dev/lambda/fuelsoft-morgan/660306/2024/Apr/03-Apr-2024.json....
1
answers
0
votes
48
views
asked 12 days agolg...
How to build AWS Glue ETL Jobs or Data Quality Jobs, if access to console is not allowed as per company policy. Does not having AWS Console access defeats the purpose AWS Glue? What features cannot be...
2
answers
0
votes
123
views
asked 12 days agolg...
I've been trying to test out Iceberg tables with Amazon Redshift Spectrum and have come across a major issue.
Here is my setup:
1. I create an iceberg table via spark (emr 7.0) and insert data across...
0
answers
1
votes
202
views
asked 12 days agolg...
when I followed this document https://docs.amazonaws.cn/en_us/redshift/latest/mgmt/jdbc20-configuration-options.html#jdbc20-plugin_name-option to connect redshift with IdpTokenAuthPlugin, I got an...
0
answers
0
votes
329
views
asked 13 days agolg...
I have deployed opensearch serverless collection. The collection type is VectorSearch. I have also defined all the security policies, like data access policies, encryption policy (Using KMS key),...
0
answers
0
votes
72
views
asked 13 days agolg...
Hi,
I want to read a tar file from s3, uncompress it and load it to another s3 bucket using Glue job. But I am facing "fileobj must implement read".
obj=s3.getObject(bucketname,key)
objbuffer =...
1
answers
0
votes
132
views
asked 13 days agolg...
An error occurred in RDSADMIN.RDS_FILE_UTIL when executing the following SQL during Oracle.
Could you please tell me the cause of the error and how to deal with it?
SQL statement:
> SELECT *
FROM...
1
answers
0
votes
135
views
asked 13 days agolg...
We have an existing ECS Cluster, and inside it, there's a service with a task definition container. The database host is stated in task definition. I created a new database, but now it is private (new...
3
answers
0
votes
238
views
asked 13 days agolg...
Here is the error I get in EMR Studio Workspace.
"To link or unlink Git repositories, you must configure VPC network connections in the Edit Studio page"
I have tried to create just a studio,...
0
answers
0
votes
45
views
asked 13 days agolg...
Hello AWS developers,
Please I would like to know, is migrating already existing RDS instances to IPV6 easy or complex?
If it's fairly easy, then please can I get an easy step by step...
1
answers
0
votes
131
views
asked 13 days agolg...
I'm trying to execute queries in Athena that involve multiple tables using joins. However, when I attempted to run several queries simultaneously (8 queries), I encountered the error. To address this,...
1
answers
0
votes
91
views
asked 13 days agolg...