razhangwei
2/24/2015 - 8:36 PM

Hive: view

Hive: view

CREATE VIEW view_s
as SELECT  id_str, text, created_at
FROM gh_rc
where year=2013 AND (month=2 AND day>=15 OR month=3 AND day<=15) 
AND lower(text) RLIKE "(matthew mcconaughey|matthew david mcConaughey)";