which hive table gives better performance?

Question

i'm beginner to hadoop.

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.

also, it is highly appreciable if you could give some more difference for this tables in real time.

thanks in advance.

Answer 1

There is no performance difference at all between internal table and external table. The only difference is just like what you mentioned - one thing to note is hive warehouse is also in HDFS (with different path)