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.
Q 1 - The query "SHOW DATABASE LIKE 'h.*' ; gives the output with database name
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'
