With Ranger Masking, does it only mask for HiveServer2 or Hive CLI as well?

[#1]

I am testing out Ranger column masking and it is successfully masking for HiveServer2 but not in the hive CLI. Is this the expected result or could I have something set up incorrectly?

[#2 · Accepted solution]

Hi @Chad Woodhedad,

This is expected. Hive rules in Ranger will apply only during access through HiveServer2 (JDBC). When accessing Hive with Hive CLI, only the HDFS rules in Ranger will apply (no masking then).