1. Categories >> Software >> Big Data >> Hadoop >> Apache Hive
  2. Suggest New Category

What types of costs are associated with creating the index on hive tables?

Question Posted / abhay verma


What types of costs are associated with creating the index on hive tables?..

Answer / Mahesh

Creating an index in Hive can increase query performance by reducing the amount of data that needs to be scanned. However, it also incurs costs related to storage (since each index requires additional space) and maintenance (rebuilding or reorganizing the index periodically to maintain its efficiency).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Hive Interview Questions

Are there any problems which can only be solved by MapReduce and cannot be solved by PIG? In which kind of scenarios MR jobs will be more useful than PIG?

1 Answers  

Differentiate between describe and describe extended?

1 Answers  

If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?

1 Answers  

Explain Hive Thrift server?

1 Answers  

What is the maximum size of string data type supported by hive? Mention the hive support binary formats.

1 Answers  

How can you delete the DBPROPERTY in Hive?

1 Answers  

What are the file formats that Hive supports and can use be used for storage?

1 Answers  

What ate the key components of Hive Architecture?

1 Answers  

What is the current version of Hive?

1 Answers  

LOWER or LCASE function in Hive with example?

1 Answers  

How do we write our own custom serde?

1 Answers  

Give some points of hive for hadoop ?

1 Answers  

For more Apache Hive Interview Questions Click Here
Categories