+1 vote
in DevOps by
How Hive can improve performance with ORC format tables?

1 Answer

0 votes
by

Hive can store the data in highly efficient manner in the Optimized Row Columnar (ORC) file format. It can ease many Hive file format limitations. Using ORC files can improves the performance when reading, writing, and processing data. Enable this format by run this command and create table like this.

set hive.compute.query.using.stats=true;

set hive.stats.dbclass=fs;

CREATE TABLE orc_table (

id int,

name string

)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ‘\;’

LINES TERMINATED BY ‘\n’

STORED AS ORC;

Related questions

0 votes
asked Nov 21, 2023 in C Plus Plus by JackTerrance
0 votes
asked Sep 6, 2022 in AWS by sharadyadav1986
...