hive orc file format

CREATE TABLE test_orc STORED AS ORC TBLPROPERTIES("ORC.COMPRESS"="SNAPPY") AS SELECT * FROM test;

sqoop import --connect jdbc:mysql://localhost/test --table TEST10 --username root  --m 1 --hcatalog-database default --hcatalog-table TEST10_ORC --create-hcatalog-table --hcatalog-storage-stanza "stored as orcfile"

CREATE TABLE IF NOT EXISTS reportdb.report001(

  firstname       STRING,

  lastname        STRING,

  accountnumber   INT,

  balance         DECIMAL(18, 9)

)

CLUSTERED BY (firstname, lastname) INTO 1 BUCKETS

STORED AS orc

TBLPROPERTIES('transactional' = 'true','orc.compress'='ZLIB','orc.create.index'='true');