Questions tagged with Amazon Athena

lg...

I have an app that has been connecting to Athena via ODBC with no previous issues. All of a sudden I am getting the following error: ``` Warning: Error in : nanodbc/nanodbc.cpp:1655: 00000: [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 100, HTTP Response Code: 502, Error Message: Failed to parse error payload [Execution ID: c6c6a1bc-d7ea-4f79-bccd-e90aa6e767f7] ``` When I look up the execution ID in athena, there is no error. The query runs successfully. It looks like the issue is between the Athena Client and Athena. Unfortunately the error message is really ambiguous. Any advice on how to debug this further would be much appreciated. Thanks!lg...

Hello, We are trying to replicate our existing tables to live in another region and I was wondering if there is an established process to accomplish this easily and quickly (and ideally to update the tables on a continuing schedule as the existing tables are updated)? I am able to create the external table with the same DDL as I was in the other region, but running MSCK REPAIR TABLE to try load the partitions into the new table fails with: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask We have created Quicksight dashboards based on these tables and we would like to move them to us-east-1 so the user management and actual datasets and dashboards all live in the same region. Our understanding was that to do this we will need to migrate our Athena tables as well.lg...

Hii, I'm trying to do an innor join on a substring in athena. The substring of the barcode (example: 3SOLGH3413663) is the partycode. And in the partycodelijst_nanette there is a corresponding name (partycode = OLGH klantnaam = OLGHEXAMPLE). So I want to join those databases. But I can't figure out how to use the like operator in this way. Could somebody help me? SELECT "week"("a"."waarneming_waarndt") "week" , "a"."barcd" "barcode" , SUBSTRING("a"."barcd", 3, 4) AS "partycode" , "b"."first_klantnaam" "klantnaam" FROM (("collo_bup_nrs"."nrs" "a" LEFT JOIN "retaildcc"."partycodelijst_nanette" "b" ON ("b"."partycode" LIKE '%' + "a"."barcd" LIKE '%'+"b"."partycode"+'%')lg...

Queries fail on iceberg table, possibly after running OPTIMIZE It's unclear if it is specifically because of null values. GENERIC_INTERNAL_ERROR: Dictionary is missing for Page Spark/Glue also fails on some queries that touch the relevant data. In general, athena will respond to queries on some data, but not the specific affected files.lg...

I am trying to run a cross-account Athena query : 1. I can list thedefault catalog ARN ""glue:arn:aws:glue:us-east-1:999999999999:catalog" fine (https://docs.aws.amazon.com/athena/latest/ug/security-iam-cross-account-glue-catalog-access.html) 2. I am unclear how to reference other connector catalogs 3. Standard presto "show catalogs" doesn't work How do I reference and query a catalog cross account. Note the second catalog is a connector (hive) from the athena.lg...

 I'm guessing I don't have access to the datalake I'm querying, BUT I've already onboarded my AWS accounts to access the database. Can someone tell me where I can check these permissions?lg...

I have a KFH application that puts compressed json files as snappy into an S3 bucket. I have also a Glue Crawler that creates schema using that bucket. However, the crawler classifies the table as UNKNOWN in case I activate snappy compression. It cannot detect the file is in JSON format indeed. According to below doc, Glue crawler provides snappy compression with JSON files but I wasn't able to achieve it. https://docs.aws.amazon.com/glue/latest/dg/add-classifier.html#classifier-built-in I have also thought it might be related to the file extension and tried below names but it didn't work: Original: ``` |-----s3://my-bucket/my-table/day=01/file1.snappy ``` (1) ``` |-----s3://my-bucket/my-table/day=01/file1.snappy.json ``` (2) ``` |-----s3://my-bucket/my-table/day=01/file1.json.snappy ``` Thanks.lg...

I have simple JSON log data like: ``` { "referer":"https://example.org", "data": { "datum1": "value1", "datum2":"value2", "ts":2381738917239 } } ``` How do I get that stuff *easily* in the Athena so I can type: `select * from mytable where data.ts > '2022-06-01 and datum1 = 'filter'` The documention is really comprehensive (spent a couple of hours browsing it), but I am really not that interesting about knowing all the SerDe details, I just need to get this simple thing going and preferrably fast. Like in Snowflake (took a minute or two to do it). BR, Jonilg...

We have connected Athena to a DocumentDB cluster with GeoJSON data stored inside. When trying to query these data we're getting following error: GENERIC_USER_ERROR: Encountered an exception[java.lang.RuntimeException] from your LambdaFunction[arn:aws:lambda:eu-west-1:<>:<>] executed in context[S3SpillLocation{bucket='<>', key='<>', directory=true}] with message[Error while processing field geoPoint] Is there any way to query GeoJSON data in DocumentDB from Athena? Query id: 138f4f39-a8d0-4cff-b0a3-357d2d310196lg...

As the title, i've try to test a query to create a new database. The workgroup been set,  and the query is pretty simple like this along with the error.  So i checked the iam, seems fine  Then the s3 policy  And the odd part is the query result is failed, but the database is actually been created. BTW, ive try the create a new table in this database too, same error of failed, but table is created. Is anyone can help me to solve this?lg...

Hi folks , got the below error while running query in athena editor after triggering crawler SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns This query ran against the "demodb" database, unless qualified by the query **Note** : the table got populated in the workgroup but when I try to preview table it should run the query but got the syntax error , Any help would be great , Thankslg...