So I have strict mode on and I like to keep it that way. I am trying to do this query.
INSERT OVERWRITE TABLE vertical_stats_recent PARTITION (dt=2015101517) SELECT ... FROM entry_hourly_v3 INNER JOIN article_meta ON entry_hourly_v3.entry_id = article_meta.entry_id INNER JOIN channel_meta ON channel_meta.section_name = article_meta.channel WHERE entry_hourly_v3.dt=2015101517 AND article_meta.dt=2015101517 AND channel_meta.hitdate=20151015 AND article_meta.publish_timestamp > ((unix_timestamp() * 1000) - (1000 * 60 * 60 * 24 * 2)) GROUP entry_hourly_v3, channel_meta and article_meta are partitioned tables. *Your query has the following error(s):* Error while compiling statement: FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "entry_hourly_v3" Table "entry_hourly_v3" I also tried putting views on the table and I had no luck. Is there any way I can do this query without turning strict mode off?