title: How to load the data from HDFS to hive table
body: <p>Please tell me how to load the data from HDFS to hive table?? Because I lost the tweets which downloaded yesterday. 
  To load the data I used following.</p>
  
  <pre><code>LOAD DATA LOCAL INPATH '/user/hue/twitter/tweets/2017/03/10' 
  OVERWRITE INTO TABLE tweets 
  PARTITION (datehour=20170310). 
  </code></pre>
  
  <p>Give me a correct query This is my table.I send it as two steps </p>
  
  <pre><code>CREATE EXTERNAL TABLE twitter.tweets ( 
  id BIGINT, 
  created_at STRING, 
  source STRING, 
  favorited BOOLEAN, 
  retweeted_status STRUCT&lt; 
                   text:STRING,   
                   user:STRUCT &lt; screen_name:STRING, name:STRING &gt;, 
                   retweet_count:INT
                   &gt;, 
  entities STRUCT&lt; 
                   urls:ARRAY&lt;STRUCT&lt;expanded_url:STRING&gt;&gt;, 
                   user_mentions:ARRAY&lt;STRUCT &lt;
                                               screen_name:STRING,    
                                               name:STRING
                                              &gt;
                                       &gt;,
                   hashtags:ARRAY&lt;STRUCT&lt;text:STRING&gt;&gt;
                 &gt;, 
  text STRING, 
  –user STRUCT&lt; 
        screen_name:STRING, 
        name:STRING,  
        friends_count:INT, 
        followers_count:INT, 
        statuses_count:INT, 
        verified:BOOLEAN, 
        utc_offset:INT, 
        time_zone:STRING
        &gt;, 
  in_reply_to_screen_name STRING )
  PARTITIONED BY (datehour INT) 
  ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe' 
  LOCATION '/twitter';
  </code></pre>
  
  <p>The sample data : atttached just little </p>
  
  <pre><code>{"filter_level":"low","retweeted":false,"in_reply_to_screen_‌​name":null,"possibly‌​_sensitive":false,"t‌​runcated":false,"lan‌​g":"en","in_reply_to‌​_status_id_str":null‌​,"id":84064934204214‌​8865,"extended_entit‌​ies":{"media":[{"siz‌​es":{"thumb":{"w":15‌​0,"resize":"crop","h‌​":150},"small":{"w":‌​340,"resize":"fit","‌​h":340},"medium":{"w‌​":600,"resize":"fit"‌​,"h":600},"large":{"‌​w":960,"resize":"fit‌​","h":960}},"source_‌​user_id":15934076,
  </code></pre>
  
  <p>I found that to load the data from HDFS to hive table is, </p>
  
  <pre><code>LOAD DATA INPATH '/user/hue/twitter/tweets/2017/03/10' OVERWRITE INTO TABLE tweets PARTITION (datehour=20170310). 
  </code></pre>
  
  <p>Is this correct and will I lost my source file?? If so what is the solution query??</p>