title: serde for simple sequence file in hive
body: <p>I have a sequence file that has Text key and DoubleWritable value. When I load the file as external table </p>
  
  <pre><code>Create external table t (id String, data Double) STORED AS SEQUENCEFILE LOCATION '/output';
  </code></pre>
  
  <p>It is created successfully. However when I try to view the data with <code>select *</code> statement I get the exception </p>
  
  <blockquote>
    <p>"Failed with exception
    java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException:
    class org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe: expects
    either BytesWritable or Text object!"</p>
  </blockquote>
  
  <p>I understand from exception that serde is not correct. I tried to implement the serde for it, but couldn't make it work. How should I implement simple serde for it?</p>