[hive] Avoid use database call for SET queries

– Reproduction –

1. Open Hive Query editor
2. Execute the following commands:
set hive.mapred.supports.subdirectories=false;
set mapred.input.dir.recursive=true;
select * from customers limit 1;

The error message:
Error while processing statement: FAILED: Hive Internal Error: hive.mapred.supports.subdirectories must be true if any one of following is true: hive.optimize.listbucketing , mapred.input.dir.recursive and hive.optimize.union.remove.

You will see the same error for all subsequent queries.

Workaround is to create a new hive session.