update hive queries with IP filtering (bug 1061734)