title: Insert into Select command causing exception ParseException line 1:12 missing TABLE at 'table_name' near '<EOF>'
body: <p>I am 2 days old into hadoop and hive. So, my understanding is very basic. I have a question which might be silly. Question :I have a hive external table ABC and have created a sample test table similar to the table as ABC_TEST. My goal is to Copy certain contents of ABC to ABC_TEST depending on select clause. So I created ABC_TEST using the following command:</p>
  
  <pre><code> CREATE TABLE ABC_TEST LIKE ABC;
  </code></pre>
  
  <p>Problem with this is:</p>
  
  <p>1) this ABC_TEST is not an external table.</p>
  
  <p>2) using Desc command, the LOCATION content for ABC_TEST was something like</p>
  
  <pre><code>hdfs://somepath/somdbname.db/ABC_TEST 
  </code></pre>
  
  <blockquote>
    <p>--> On command "<em>hadoop fs -ls hdfs://somepath/somdbname.db/ABC_TEST</em> " I found no files .</p>
    
    <p>--> Whereas, "<em>hadoop fs -ls hdfs://somepath/somdbname.db/ABC</em>" returned me 2 files.</p>
  </blockquote>
  
  <p>3) When trying to insert values to ABC_TEST from ABC, I have the above exception mentioned in the title. Following is the command I used to insert values to ABC_TEST:</p>
  
  <pre><code>INSERT INTO ABC_TEST select * from ABC where column_name='a_valid_value' limit 5;
  </code></pre>
  
  <p>Is it wrong to use the insert into select option in Hive? what am I missing? Please help</p>