Many users are used to using ‘select * from tables’ in oracle/mysql But i should not allow them to query like that in hive Is there any way to prevent a full_table scan in hive? Like trigger or somethng else? Thanks a lot! Answer To prevent full table scan use these settings. Hive will generate exception if partition predicate is