Skip to content
Advertisement

Athena sql query to find items not containing a value

I have a table in a bucket, I am using Athena to get the required data My table looks like

I need to find all the resources where A-1 is not found the result should give me i-2. How to write in sql

Advertisement

Answer

You can use aggregation to group all rows having the same resourceid together, and then filter out groups of rows where appname 'A-1' does not appear:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement