PrepAway - Latest Free Exam Questions & Answers

Hot Area:

HOTSPOT
You have the following script.
CREATE TABLE UserVisits (username string, url string, time date)
STORED AS TEXTFILE LOCATION “wasb:///Logs”;
CREATE TABLE UserVisitsOrc (username string, url string, time date)
STORED AS ORC;
INSERT INTO TABLE UserVisitsOrc SELECT * FROM UserVisitsUse the drop-down menus to select the answer choice that completes each statement based on the information
presented in the script.
NOTE: Each correct selection is worth one point.
Hot Area:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
A table created without the EXTERNAL clause is called a managed table because Hive manages its data.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL


Leave a Reply