title: Difference in create table properties in hive while using ORC serde
body: <p>Below is the structure of one of the existing hive table.</p>
  
  <pre><code>CREATE TABLE `tablename`(
  col1 datatype,
  col2 datatype,
  col3 datatype)
  partitioned by (col3 datatype)
  ROW FORMAT SERDE
    'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
  WITH SERDEPROPERTIES (
    'field.delim'='T',
    'serialization.format'='T')
  STORED AS INPUTFORMAT
    'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
  OUTPUTFORMAT
    'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
  LOCATION
    'maprfs:/file/location'
  TBLPROPERTIES (
    'COLUMN_STATS_ACCURATE'='{\"BASIC_STATS\":\"true\"}',
    'numFiles'='0',
    'numRows'='0',
    'rawDataSize'='0',
    'totalSize'='0',
    'transient_lastDdlTime'='1536752440')
  </code></pre>
  
  <p>Now i want to create a table with same properties, how do i define below properties in create table syntax.</p>
  
  <blockquote>
    <p>field delimiter and seralization format
    TBLPROPERTIES to store numFiles, numRows, radDataSize, totalSize (and what all  other information we can store in TBLPROPERTIES option)</p>
  </blockquote>
  
  <p>Below is one of the create table syntax which i have used</p>
  
  <pre><code> create table test_orc_load (a int, b int) partitioned by (c int) stored as ORC;
  </code></pre>
  
  <p>Table properties which i got using show create table option.</p>
  
  <pre><code>CREATE TABLE `test_orc_load`(
    `a` int,
    `b` int)
  PARTITIONED BY (
    `c` int)
  ROW FORMAT SERDE
    'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
  STORED AS INPUTFORMAT
    'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
  OUTPUTFORMAT
    'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
  LOCATION
    'maprfs:/user/hive/warehouse/alb_supply_chain.db/test_orc_load'
  TBLPROPERTIES (
    'transient_lastDdlTime'='1537774167')
  </code></pre>