title: Hive insert vs Hive Load: What are the trade offs?
body: <p>I'm learning Hadoop/Big data technologies. I would like to ingest data in bulk into hive. I started working with a simple CSV file and when I tried to use <code>INSERT</code> command to load each record by record, one record insertion itself took around 1 minute. When I put the file into HDFS and then used the <code>LOAD</code> command, it was instantaneous since it just copies the file into hive's warehouse. I just want to know what are the trade offs that one have to face when they opt in towards <code>LOAD</code> instead of <code>INSERT</code>.</p>