Questions tagged with 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.
Hi,
In Athena, in the Console, I am getting a `HIVE_CURSOR_ERROR` when running:
(Queries, file paths etc. are anonymized)
```
SELECT DISTINCT file_path
FROM (
SELECT xid,
"$path" as...
2
answers
0
votes
363
views
asked a year agolg...
Calculating YTDlg...
Assume i have below dataset
Brand Date Revenue
Brand A 1/1/2023 30
Brand B 2/1/2023 50
Brand C 3/1/2023 60
I am trying to calculate YTD value which is Year to Date, on...
1
answers
0
votes
374
views
asked a year agolg...
I am using Data Quality to evaluate the dataset and I am routing the failed rules and failed records. But when i check the s3 bucket for the failed records i am seeing empty files along with the...
0
answers
0
votes
121
views
asked a year agolg...
Has anyone found a good way to parse tables that come back from Textract that are inverted? Specifically, getting the table name or column headers as they are not recognized via the API itself. Here...
0
answers
0
votes
81
views
asked a year agolg...
My Quicksight analysis data is failed to refresh multiple times now. Refresh was working fine till couple hours ago
0
answers
0
votes
78
views
asked a year agolg...
[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query. Please contact AWS support for further assistance. You will not be charged for this...
1
answers
0
votes
241
views
asked a year agolg...
Hello,
I have a Glue Pyspark job that writes to Amazon S3 in a CSV format, I don't see any file with CSV extension on Amazon S3. How can see it ?
I am using `write_dynamic_frame.from_options`...
3
answers
0
votes
294
views
asked a year agolg...
Hey folks,
Please guide me with the link about the best ways to take a snapshot of EMR cluster without downtime.
Thank you
1
answers
0
votes
385
views
asked a year agolg...
Hi there,
I am wondering whether there is any proved way, to do data ETL from Azure SQL PaaS to Redshift. IHAC whose legacy system is running on the former and is trying to do the data analytics...
1
answers
0
votes
278
views
asked a year agolg...
Using the step: "Derived Column" where I can use SQL functions to derive new columns I found SUBSTRING works but CHARINDEX it doesn't. And as usual with AWS documentation, there's no place or...
1
answers
0
votes
379
views
asked a year agolg...
Analytic Eventslg...
Hello everyone,
We have been working on to integrate aws analytic events with our react-native mobile app.Recently I have added new events and made few changes to the existing events in my local...
0
answers
0
votes
77
views
asked a year agolg...
I am new to AWS Glue and I am encountering an issue while trying to use the "google bigquery connector 0.24.2 for aws glue 3.0" in an AWS Glue Job. The goal is to establish a connection between my RDS...
1
answers
0
votes
317
views
asked a year agolg...