Question

Which of the following will prefix the query string with parameters?

(a) SET hive.exec.compress.output=false

(b) SET hive.compress.output=false

(c) SET hive.exec.compress.output=true

(d) All of the mentioned

This question was posed to me during a job interview.

My doubt is from Querying Data with HiveQL topic in division Hive and HBase of Hadoop

Answer 1

The correct choice is (a) SET hive.exec.compress.output=false

The explanation: Use lzop command utility or your custom Java to generate .lzo.index for the .lzo files.