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:

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:

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 0

Your email address will not be published. Required fields are marked *