python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Query String Array JSON
I have a table in Athena, where the data ingestion was done through a MongoDB, where a column of the table is an array of JSON.
Only the table column is as a string, and I don't know how to run a quer...
Bruno
Votes: 0
Answers: 1
Performance tuning AWS Athena alternative query to using LIKE function
I'm querying 20GB of domain data with AWS Athena. I'm trying to get all IP values that match a domain. My query goes like this:
SELECT ip_value FROM domains
WHERE domain_name LIKE '%<some_domain>...
M. Phys
Votes: 0
Answers: 0
Delta Table / Athena And Spark
I have my delta table, which can be read from Athena.
When I try to get the data through a query from spark I get the following error:
Caused by: org.apache.spark.SparkException: Job aborted due to s...
Josefina Andrea Araya Tapia
Votes: 0
Answers: 1
Multiple SQL statements connected via WITH fail due to 'mismatched input'
The following SQL - statement arose due to the fact that SQL cannot process in the same query newly created columns and calculations with these.
The error message is:
line 22:1: mismatched input 'WIT...

Andreas L.
Votes: 0
Answers: 0