title: data insertion into hive table
body: <p>I want to insert data into hive table.</p>
  
  <p>1) create database.</p>
  
  <p>2) create table in particular database.</p>
  
  <p>3) create a dummy table in particular position.</p>
  
  <p>4)Using dummy table insert data into main table.</p>
  
  <p>when i insert data process complete without exception but data not insert in table.</p>
  
  <pre><code>hive&gt; create database final;
  </code></pre>
  
  <p>OK
  Time taken: 2.56 seconds</p>
  
  <pre><code>hive&gt; create table final.abc (user_name string, password string)
  &gt; ROW FORMAT DELIMITED   
  &gt; FIELDS TERMINATED BY ',' 
  &gt; LINES TERMINATED BY '\n'
  &gt; STORED AS TEXTFILE;
  </code></pre>
  
  <p>OK
  Time taken: 0.591 seconds</p>
  
  <pre><code>hive&gt; create table foo (user string , password string)          
  &gt; ROW FORMAT DELIMITED   
  &gt; FIELDS TERMINATED BY ',' 
  &gt; LINES TERMINATED BY '\n'
  &gt; STORED AS TEXTFILE
  &gt; Location '/usr/hive/hive-0.10.0/fiels';
  </code></pre>
  
  <p>OK
  Time taken: 0.051 seconds</p>
  
  <pre><code>hive&gt; insert into table final.abc select 'username','password' from foo;
  
  Total MapReduce jobs = 3
  Launching Job 1 out of 3
  Number of reduce tasks is set to 0 since there's no reduce operator
  Starting Job = job_201306191046_0002, Tracking URL =/jobdetails.jsp?jobid=job_201306191046_0002
  Kill Command = /usr/hadoop/hadoop-1.1.2/libexec/../bin/hadoop job  -kill job_201306191046_0002
  Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
  2013-06-19 12:04:36,870 Stage-1 map = 0%,  reduce = 0%
  2013-06-19 12:04:37,878 Stage-1 map = 100%,  reduce = 100%
  Ended Job = job_201306191046_0002
  Ended Job = -331805541, job is filtered out (removed at runtime).
  Ended Job = -1750065493, job is filtered out (removed at runtime).
  Moving data to: hdfs://localhost:9000/tmp/hive-root/hive_2013-06-19_12-04-32_830_4819535129373917658/-ext-10000
  Loading data to table final.abc
  Table final.abc stats: [num_partitions: 0, num_files: 0, num_rows: 0, total_size: 0, raw_data_size: 0]
  
  MapReduce Jobs Launched: 
  Job 0:  HDFS Read: 0 HDFS Write: 0 SUCCESS
  Total MapReduce CPU Time Spent: 0 msec
  OK
  Time taken: 5.475 seconds
  </code></pre>
  
  <p><strong>If any idea please suggest me. where am i wrong.</strong> </p>