Following quiz provides Multiple Choice Questions (MCQs) related to Hive. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
The DISTRIBUTED BY clause send a range of values to the same reducer.
Q 7 - Consider the below two sets of queries.
Query A:
hive> INSERT OVERWRITE TABLE sales
SELECT * FROM history WHERE action = 'purchased';
hive> INSERT OVERWRITE TABLE credits
SELECT * FROM history WHERE action = 'returned';
and
Query B:
hive> FROM history
INSERT OVERWRITE sales SELECT * WHERE action = 'purchased'
INSERT OVERWRITE credits SELECT * WHERE action = 'returned'
