title: Hive Select Into
body: <p>I have a database people in hive. It's schema is as follows:</p>
  
  <pre><code>name string,
  dob_date int,
  dob_month int,
  dob_year int.
  </code></pre>
  
  <p>I have successfully loaded data from a file into the database.<br>
  Now I want to have people having <code>dob_year=1990</code> into a new table.<br>
  The following code doesn't work :</p>
  
  <pre><code>Select * into people1990 from people where dob_year=1990;
  </code></pre>