All Content tagged with Analytics

Trying to have a Glue Crawler/Athena automatically pick up a timestamp format of `yyyy-MM-dd'T'HH:mm:ss.SSS'Z'`. I have confirmed all the values in my dataset are formatted as this format, example:...

Came across the following useful documentation: https://docs.aws.amazon.com/prescriptive-guidance/latest/apache-iceberg-on-aws/best-practices-read.html#read-sort-order I have a large table where I...

We have loved the flexibility of the Athena engine, but are starting to get concerned about its instability. Recently we've identified needs to rerun major queries that return zero records the first...

Hello, we are facing a very odd issue with AWS Glue. When we run AWS Glue Crawler against the RDS Postgres v14 we get very vague error logs from CloudWatch (see below). Now, admittedly the schema is...

Hi, My Athena Query to transform the data is failing randomly with the error: Exception: Final state of Athena job is FAILED, query_execution_id is 97b49928-68f8-44e0-af7e-1fc7ec7cefcb. Error:...

The following query returns an error ``` SELECT * from UNNEST(SEQUENCE( (SELECT min(col1) from table1), current_date, INTERVAL '1' DAY )) ``` but this query works just...

We use AWS OpenSearch domain with GitLab to enable Advanced search feature. Just want to know incase of AWS OpenSearch domain down, will it impact at only indexing or other places also?

Hey everyone, I have a problem. I have an ESP32 with a BME280 sensor. I use platformIO to flash it with RTOS and publish temperature, humidity and pressure to a aws topic. I get the data on IoT Core...

I have a use case where I need to run Batch EMR job on schedule (daily). I can make folders on date basis for my data coming from IoT. Or I can make folders for each device sending IoT data and put...

Hi, I am looking for some advice on changing cluster from dc2.large 4 nodes to ra3.xlplus 1 node. The priority reason is more storage however this had been untouched since setup for my company a few...

We want to know display count of in app message for user endpoint. Our mobile team send custom event for increasing display count. How can we see displayed in app message count according to user...

Hey everyone I am trying to query a set of JSON files in S3 with Athena and I am getting the Hive cursor error for invalid JSON even though the files in question are valid single-line JSON. Is there a...