Have you also tried to copy hive-site.xml to the <DREMIO_HOME>/conf folder, also if this is Dremio 4.2 and above please do the below too
If Hive 2.x source then
cd <DREMIO_HOME>/plugins/connectors
mkdir hive2.d
cd hive2.d
ln -s <DREMIO_HOME>/conf <DREMIO_HOME>/plugins/conectors/hive2.d
If Hive 3.x source then
cd <DREMIO_HOME>/plugins/connectors
mkdir hive3.d
cd hive3.d
ln -s <DREMIO_HOME>/conf <DREMIO_HOME>/plugins/conectors/hive3.d
Thanks
Bali