By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

0

I have created a table using AWS Glue crawler and ran a test query: Enter image description here 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 Any idea why this is happening?

Topics
Analytics
Tags
Amazon Athena
Language
English
yuan
asked 8 months ago1.6K views
2 Answers
0

Can yo try to remove the single quote around tweet?

profile pictureAWS
EXPERT
AWS-User-alantam
answered 8 months ago
0

I use double quotes for column names and single for values

SELECT * FROM tweets WHERE "tweet" LIKE '%cool%';
profile picture
EXPERT
Gary Mclean
answered 8 months ago
profile picture
EXPERT
Giovanni Lauria
reviewed 8 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content