title: Hive import from HDFS as ORC
body: <p>I exported a hive table in hdfs using </p>
  
  <p><code>export table abc to '/tmp/123'</code></p>
  
  <p>It created two directories <code>/data</code> and <code>/metadata</code> and keeps data and metadata accordingly. </p>
  
  <p>Now I sent this data to another hadoop cluster using <strong>distcp</strong> command. </p>
  
  <p>Now I want to import this data in a table xyz (<em>not created yet</em>)</p>
  
  <p>Now using hive import command</p>
  
  <p><code>import table xyz from '/tmp/123'</code></p>
  
  <p>It created Table xyz with data but in text format.</p>
  
  <p>I want this xyz in ORC format.</p>
  
  <p>Yes, I can create another table using this text table. </p>
  
  <p>Is there any better way for that ??</p>
  
  <p>Can I mention anywhere in command?</p>