title: Hive table row level security
body: <p>I am supposed to look on how to achieve row level security on our finance Hive tables present in our schema.</p>
  <p>Use Case: I have 1000s of Employee-Manager hierarchy data points from Intern till CEO which keeps on changing frequently (since employees change team all the time). So, I cannot manually keep on updating the User/table/group access everytime.
  If a user queries our secured table then we only want that user to see data/row below his hierarchy.</p>
  <p>To achieve row level data security, I may need to either:</p>
  <ul>
  <li>Build a new tool
  Or</li>
  <li>Use some third party tool</li>
  </ul>
  <p>Options explored:</p>
  <ul>
  <li>AWS IAM</li>
  <li>Apache Ranger
  But looks like they cannot deal with hierarchical data in automated fashion.</li>
  </ul>
  <p>Please help!</p>