title: How to insert data into a Hive(0.13.1) table?
body: <p>I am using Hive version 0.13.1. While trying to insert data into an existing table getting an error while using the below query:</p>
  
  <pre><code>CREATE TABLE table1 (order_num int, payment_type varchar(20), category varchar(20));
  INSERT INTO TABLE table1 VALUES (151, 'cash', 'lunch');
  </code></pre>
  
  <p>ERROR : </p>
  
  <blockquote>
    <p>ParseException line 1:25 cannot recognize input near 'VALUES' '('
    '151' in select clause</p>
  </blockquote>
  
  <p>While searching, got everyone suggesting above query, but unfortunately it's not working for me. Is it due to different Hive version? <br>I am getting this ambiguity due to link <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingvaluesintotablesfromSQL" rel="nofollow noreferrer">here</a><br> Needs help to insert data to an existing table in Hive.</p>