hive instrt_Hive查询：将字符串与关键字列表匹配(Hive query: Match string with list of keywords)...

I have a hive table with tweets about movies and a table with keywords mapped to movie titles

keyword example:

title keyword

------ -------

3 Days to Kill 3daystokill

3 Days to Kill 3 days to kill

12 Years a Slave 12YearsASlave

tweets example:

id text

------ -------

125675146 3daystokill sucks!

125673498 3 days to kill is awesome!

239873985 I like 12 Years a Slave :)

I would like to be able to find the tweets matching the keywords for a certain movie title. For example, I want to find all the tweets that mention keywords from 3 Days to Kill (3daystokill and 3 days to kill).

I thought something like this, but the results are empty :(

SELECT k.keyword, t.text

FROM keywords k JOIN tweets t

ON t.text = CONCAT('%',k.keyword,'%')

WHERE k.title = "3 Days to Kill";