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');
'NoSQL > Hive' 카테고리의 다른 글
hive table 통계 정보 수집 (0) | 2017.02.19 |
---|---|
hive load data (0) | 2017.02.19 |
hive table merge (1) | 2017.02.18 |
hive skip line 설정 (0) | 2017.02.16 |
hive avro table 자동적재 using sqoop (0) | 2016.11.11 |