I'm using HDP 2.5.3.
Hive Setting
ACID Transacctions ON
Execution Engine TEZ
CBO ON
Fetch column stats at compiler ON
Default ORC Stripe Size
64MB
ORC Compression Algorithm ZLIB
ORC Storage Strategy SPEED
Here's my question.
If I created hive table like this,
CREATE TABLE test01
no int,
id string,
code, string
ROW FORMAT DELIMITED
FIELDS TERMININATED BY '|'
STORED AS ORC
then, what is default tableproperties of test01 table's ORC options?
TBLPROPERTIES (
'orc.compress' = '?',
'orc.create.index'='?',
'orc.stripe.size'='?',
'orc.row.index.stride'='?'
)
for example.
TBLPROPERTIES (
'orc.compress' = 'ZLIB',
'orc.create.index'='true',
'orc.stripe.size'='67108864',
'orc.row.index.stride'='50000'
)