AWS Athena: use SELECT ... LIKE doesn't return any result

Question

I have created a table using AWS Glue crawler and ran a test query:
![Enter image description here](/media/postImages/original/IMmKs6dOu3RR6uSv52EP_Wdw)
As you can see, the first row has the word "cool" in column 'tweet'.
However, when I use SELECT ... WHERE ...LIKE to find that row, nothing returns.
![Enter image description here](/media/postImages/original/IM1EK40CTqSUauMrpcbxWKnA)
Any idea why this is happening?

Answer

I use double quotes for column names and single for values

```
SELECT * FROM tweets WHERE "tweet" LIKE '%cool%';
```

Answer

Can yo try to remove the single quote around tweet?

AWS Athena: use SELECT ... LIKE doesn't return any result

Contenuto pertinente