Home >> Big Data Hadoop >> How will you optimize Hive performance in Big Data Hadoop

How will you optimize Hive performance in Big Data Hadoop

1)-Use Tez

2)-Use ORCFile

3)-Use Vectorization

4)-Cost based query optimization

5)-Write good SQL

Post Your Comment

Next Questions
Hive Difference between Sort By and Order By
Sqoop vs Flume
What is the default file format to import data using Apache Sqoop
we have around 300 tables in a database. I want to import all the tables from the database except the tables named Table298, Table 123, and Table299. How can I do this without having to import the tables one by one using sqoop
How can you execute a free form SQL query in Sqoop to import the rows in a sequential manner
How will you list all the columns of a table using Apache Sqoop
What is the difference between Sqoop and DistCP command
What is Sqoop metastore
What is the significance of using --split-by clause for running parallel import tasks in Apache Sqoop

Copyright ©2022 coderraj.com. All Rights Reserved.