title: loading data from hdfs into hive results null output in the table
body: <p>I am trying to load the data from HDFS into hive data warehouse using hive serialization and deserialization query but while retrieving from the table results null output. </p>
  
  <p>Can any one please help me out?</p>
  
  <pre><code>hive&gt;create table stations(usaf string, wban string, name string)
      &gt;row format serde 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
      &gt;with SERDEPROPERTIES(
      &gt;"input.regex" ="(\\d{6}) (\\d{5}) (.{29}) .*"
      &gt;);
  
  hive&gt; load data inpath '/user/cloudera/input-new/ncdc/metadata/stations-fixed-width.txt'
      &gt;into table stations;
  </code></pre>
  
  <p>While retrieving from table </p>
  
  <pre><code>   hive&gt;select * from stations limit 4;
  </code></pre>
  
  <p>Results:</p>
  
  <pre><code>   NULL NULL NULL
     NULL NULL NULL
     NULL NULL NULL
  </code></pre>
  
  <p>Sample data look like this:</p>
  
  <pre><code>010014 99999 SOERSTOKKEN                   NO NO    ENSO  +59783 +005350 +00500
  </code></pre>