Checking array in Athena

arrays amazon-athena
dunstantom picture dunstantom · Apr 12, 2017 · Viewed 8.3k times · Source

I have a table in Athena where one of the columns is of type array<string>. However, when I run

select * from mytable
where array_contains(myarr,'foobar')
limit 10

it seems Athena doesn't have the array_contains function:

SYNTAX_ERROR: line 2:7: Function array_contains not registered

Is there an alternative way to check if the array contains a particular string?

Answer

David דודו Markovitz picture David דודו Markovitz · Apr 13, 2017 
select * 
from   mytable
where  contains(myarr,'foobar')
limit  10

Related questions

How can I remove a specific item from an array?

I have an array of numbers and I'm using the .push() method to add elements to it. Is there a simple way to remove a specific element from an array? I'm looking for the equivalent of something like: array.remove(…

Read More
How do I declare and initialize an array in Java?

How do I declare and initialize an array in Java?

Read More
For-each over an array in JavaScript

How can I loop through all the entries in an array using JavaScript? I thought it was something like this: forEach(instance in theArray) Where theArray is my array, but this seems to be incorrect.

Read More