Apache HIVE Hadoop Developer mamun Exam 100% Correct

Apache HIVE Hadoop Developer mamun Exam 100% Correct




1. Consider the following Hive query:



SELECT customers.*, orders.* FROM customers JOIN orders ON
(customers.customerID = orders.customerID);



Which of the following is correct?



A. The customers.* expression is invalid and generates a syntax error

B. The keyword ON generates a syntax error

C. The equals sign "=" generates a syntax error

D. The customers and orders tables are joined on the customerID field - ANSWER Di



If sqoop is using hive-import, is it importing from hive or to hive? - ANSWER To



Once you have HIVE installed, how to get to HIVE?



a. just type hive and you will get HIVE console (CLI)

b. execute the HIVE GUI

c. you have to install HDFS and then you can run./hive

d. find the directory of HIVE executable and run chmod 755 hive - ANSWER A



Is HIVE a relational database? - ANSWER No

, Difference b/w HIVE and PIG:



a. There is no difference

b. HIVE is the datastore against which you can run PIG commands

c. Similar products made by two different vendors

d. PIG does not emulates SQL while HIVE does - ANSWER B



HIVE sends job to whom? - ANSWER Ans: jobtracker (1.0) YARN Resource Manager
(2.0)



What does HIVE job require to run mapreduce? - ANSWER Ans: there is a generic
mapper and reducer (based on XML) that it can use. As such, HIVE acts as an
interpreter language.



7. HIVE warehouse default directory:

a. at the hdfs location /user/hive/warehouse

b. /hdfs/warehouse

c. /vol1/warehouse

d. /namenode/warehouse - ANSWER A



8. True/False: Can HIVE tables have schema?



a. Yes

b. No - ANSWER True



HIVE stores the metadata into a relational database called the ______?



a. Kernel