title: Insert data into avro-formatted, partitioned hive table with data from HDFS
body: <p>I have created a hive table named employee (avro formatted) with partition on department. </p>
  
  <p>I have the avro dataset in my HDFS location. My dataset is also having department id. </p>
  
  <p>I would like to import the data into Hive table with the data from HDFS. During the import, I want the data to be kept in its respective partition. </p>
  
  <p>How to achieve this? any idea?</p>