set hive.mapred.supports.subdirectories=true;
set metaconf:hive.metastore.try.direct.sql;

set metaconf:hive.metastore.try.direct.sql=false;
set metaconf:hive.metastore.try.direct.sql;
set hive.metastore.try.direct.sql;

reset -d metaconf:hive.metastore.try.direct.sql;
set metaconf:hive.metastore.try.direct.sql;
set hive.metastore.try.direct.sql;