title: Create hive table from file stored in hdfs in orc format
body: <p>I want to know if its possible create a hive table from a file stored in hadoop file system (users.tbl) in ORC format. I read that ORC format its better than text in terms of optimization. So I would like to know if its possible create a hive table using <code>stored as orc tblproperties</code> and <code>location</code> attributes to create a table from the hdfs file but in orc format.</p>
  
  <p>Something as:</p>
  
  <pre><code>create table if not exists users
  (USERID BIGINT,
   NAME STRING,
   EMAIL STRING,
   CITY STRING)
  STORED AS ORC TBLPROPERTIES ("orc.compress"="SNAPPY")
  LOCATION '/tables/users/users.tbl';
  </code></pre>
  
  <p>Insted of text:</p>
  
  <pre><code>create table if not exists users
      (USERID BIGINT,
       NAME STRING,
       EMAIL STRING,
       CITY STRING)
       ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE 
       LOCATION '/tables/users/users.tbl';
  </code></pre>