title: Hive Query Control Flow?
body: <p>What is the control flow of a hive query ?</p>
  
  <p>Let's Say, I would like to join Emp_Table with Dept_Table,</p>
  
  <p>How does the flow goes ?</p>
  
  <p>From which table in the meta store, it fetches all relevant informations ?</p>
  
  <p>Such as, 
  1) Where is the file that corresponds to Emp_Table ? (HDFS Location)
  2) What are the names of fields of table Emp_Table ?
  3) What is the delimiter in the file that contains the data of Emp_Table ?
  4) How about the data is bucketed or partitioned, in that case from where (Meta Store Table Name) and how (Query) that gives the HDFS Folder locations ? </p>