title: Error of Wrong Format in hive while loading data from hdfs
body: <p>I have successfully created a table but when m loading the data stored in hdfs streamed from twitter i got the error:</p>
  
  <pre><code>"Loading data to table default.tweets
  Failed with exception Wrong file format. Please check the file's format.
  FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask"
  </code></pre>
  
  <p>I dont know what to do next . Here is the creation:</p>
  
  <pre><code>CREATE EXTERNAL TABLE tweets (
      &gt;    id BIGINT,
      &gt;    created_at STRING,
      &gt;    source STRING,
      &gt;    favorited BOOLEAN,
      &gt;    retweet_count INT,
      &gt;    retweeted_status STRUCT&lt;
      &gt;       text:STRING,
      &gt;       user:STRUCT&lt;screen_name:STRING,name:STRING&gt;&gt;,
      &gt;    entities STRUCT&lt;
      &gt;       urls:ARRAY&lt;STRUCT&lt;expanded_url:STRING&gt;&gt;,
      &gt;       user_mentions:ARRAY&lt;STRUCT&lt;screen_name:STRING,name:STRING&gt;&gt;,
      &gt;       hashtags:ARRAY&lt;STRUCT&lt;text:STRING&gt;&gt;&gt;,
      &gt;    text STRING,
      &gt;    user STRUCT&lt;
      &gt;       screen_name:STRING,
      &gt;       name:STRING,
      &gt;       friends_count:INT,
      &gt;       followers_count:INT,
      &gt;       statuses_count:INT,
      &gt;       verified:BOOLEAN,
      &gt;       utc_offset:INT,
      &gt;       time_zone:STRING&gt;,
      &gt;    in_reply_to_screen_name STRING
      &gt; ) 
      &gt; ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
      &gt; LOCATION '/user/flume/tweets';
  </code></pre>
  
  <p>Please guide me.
  Thanks</p>