Home » Microsoft » 70-475 v.2 » HOTSPOT
HOTSPOT
You have the following Hive query.
CREATE TABLE UserVisits (username string, urlvisited string, time date);
LOAD DATA INPATH ‘wasb:///Logs’ OVERWRITE INTO TABLE UserVisits;
Use 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:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: moves the contents of Logs to the UserVisits table directory
The LOAD DATA statement streamlines the ETL process for an internal Impala table by moving a data file or all the data files in a directory from an HDFS location into the Impala data directory for that table.
Box 2: Managed
The default kind of table produced by the CREATE TABLE statement is known as an internal table. (Its counterpart is the external table, produced by the CREATE EXTERNAL TABLE syntax.). Internal tables are managed by Impala, and use directories inside the designated Impala work area.
References: https://www.cloudera.com/documentation/enterprise/5-2-x/topics/impala_load_data.html https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_tables.html#tables