title: Hive Reading a sequence File
body: <p>I am having an issue regarding the binary data i see in Hive tables when querying a table stored as Sequencefile format. </p>
  
  <p>I used Sqoop to import data from Databse specified following options:</p>
  
  <pre><code>--as-sequencefile --fields-terminated-by '\001' --null-string '\\N' --null-non-string '
  </code></pre>
  
  <p>created a Hive external table to point to the location i imported DB Data:</p>
  
  <pre><code>CREATE EXTERNAL TABLE if not exists Test(
  test_id string,
  s_date timestamp)
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '\001'
  STORED AS sequencefile 
  LOCATION '&lt;location where i importedsqoop data&gt;
  </code></pre>
  
  <p>I was thinking that my Hive tabe would deserialize data and display the data in a readable format but i see data as a binary or non-readable foramt. </p>
  
  <p>Do i need any more steps to be followed in order for hive to deserialize the data? </p>
  
  <p>Thank you. Nish. </p>