Unanswered Questions tagged with Amazon Athena
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 have a service logs as below format
```
{"date":"2024-03-13T16:19:22.456430Z","stream":"stdout","log":"{\"level\":\"info\",\"message\":\"request arrived - method: GET url:...
0
answers
0
votes
232
views
asked 8 days agolg...
Currently I'm trying to get data source from Athena in AWS Grafana.
Under the section - Apps/AWS Data Sources/Data sources, I selected Service as 'Athena' and when i select the Regions as 'Asia...
0
answers
0
votes
314
views
asked 15 days agolg...
I have this table:
```
RetsIncomingTable:
Type: AWS::Glue::Table
Properties:
CatalogId: !Ref AWS::AccountId
DatabaseName: !Ref TheDatabase
TableInput:
Name:...
0
answers
0
votes
129
views
asked 19 days agolg...
I have an iceberg table defined like this:
CREATE TABLE IF NOT EXISTS staging (
id STRING,
staging_timestamp BIGINT,
... blah blah blah ...
)
PARTITIONED BY...
0
answers
0
votes
147
views
asked 20 days agolg...
hi all,
I am running my athena script, in athena console and got this error,
`GENERIC_INTERNAL_ERROR: io.airlift.bytecode.CompilationException: Error compiling class:...
0
answers
0
votes
95
views
asked 24 days agolg...
The files in the bucket have json arrays in a single line separated by comma like below:
[{"key" : 20}, {"key" : 30}, {"key" : 40}]
When i create table with this, only the first record is being...
0
answers
0
votes
95
views
asked 25 days agolg...
Hi all,
I want to protect the connection between Power BI and Amazon Athena. I gave the end users IAM credentials, so they can setup their DSN in their local machines and start creating reports in...
0
answers
0
votes
57
views
asked a month agolg...
When trying to insert data into an Athena/Iceberg table, using Java Athena JDBC Driver 3.0.0, getting error "Member must have length less than or equal to 1024".
# The table:
CREATE TABLE IF NOT...
0
answers
0
votes
191
views
asked 2 months agolg...
![Reference table](/media/postImages/original/IMC_LZPd3JRsS-H1eO9mS9Fg)
Hello, I’ve a problem with the ordering generated by row_number, I have two STRING type columns (str_dt,str_ts) I need to order...
0
answers
0
votes
188
views
asked 2 months agolg...
[Simba][AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Unable to load AWS credentials from any provider in the chain: [EnvironmentVariableCredentialsProvider: Unable to load AWS...
0
answers
0
votes
417
views
asked 2 months agolg...
The query below on current AWS Athena version 3 gives a wrong result for the centroid, which lies way below the polygon (POINT (6.127790214246207 46.2084751184263)). The exact same query in PostGIS...
0
answers
0
votes
415
views
asked 2 months agolg...
Hi
Trying to craw connect logs create bad metadata with fields like this inside the table:
struct<connect\:Subtype:struct<ValueString:string>>
obvious running this struct inside athena result in a...
0
answers
0
votes
417
views
asked 2 months agolg...