Hive RLIKE on a list of strings
<p>I have 2 tables, one with long string + int values, the other with short strings, i would like to match each row in table1 to NOT contain any value in table2</p>

<p>table1 values:
'<strong>i like my iphone now</strong>',
'<strong>iphone is great</strong>',
'<strong>this is also here</strong>'</p>

<p>table2 values:
'<strong>iphone</strong>'
'<strong>galaxy</strong>'</p>

<p>i need the output to be only row 3 in table1
but when i do this:</p>

<pre><code>select * from table1 a, table2 b 
where NOT (a.input RLIKE concat('(^|.* )', TRIM(b.exclude_word), '( .*|$)'));
</code></pre>

<p>it doesn't work because <code>table1 a, table2 join</code> is full outer join and i will always be left with values duplicated that don't match.</p>