title: which hive table gives better performance?
body: <p>i'm beginner to hadoop. </p>
  
  <p>internal table: the table is stored in hive warehouse and if it is dropped, both the metadata and data is deleted.
  external table: the table is stored in hdfs and if it is dropped, only the metadata is deleted.
  now, which table gives better performance while querying?please give reason.</p>
  
  <p>also, it is highly appreciable if you could give some more difference for this tables in real time.</p>
  
  <p>thanks in advance.</p>