Hive data models represent
Table in HDFS
Directories in HDFS
Excellent ! Your Answer is Correct.
Table in Metastore DB
None of the Option is Correct
Category: Hadoop Hive
The partitioned columns in Hive tables are
The partitioned columns in Hive tables are
Physically present but can’t be accessed
Physically absent but can be accessed
Excellent ! Your Answer is Correct.
Physically present and can be accessed
Physically absent and can’t be accessed
On dropping external tables, Hive:
On dropping external tables, Hive:
Drops both, data and metadata
Retains both, data and metadata
Retains data, but deletes metadata
Excellent ! Your Answer is Correct.
Retains metadata, but deletes data
On dropping managed tables, Hive:
On dropping managed tables, Hive:
Retains both, data and metadata
Retains metadata, but deletes data
Drops both, data and metadata
Excellent ! Your Answer is Correct.
Retains data, but deletes metadata
Hive managed tables stores the data in
Hive managed tables stores the data in
Any HDFS path
HDFS warehouse path
Excellent ! Your Answer is Correct.
None of the Option is Correct
Local Linux path
Hive can load the data from:
Hive can load the data from:
All Options are Correct
Excellent ! Your Answer is Correct.
HDFS File system
Output of a Pig Job
Local File system
Partitioned tables in Hive:
Partitioned tables in Hive:
All Options are Correct
Excellent ! Your Answer is Correct.
Are aimed to increase the performance of the queries
Modify the underlying HDFS structure
Are not useful if the filter columns for query are different from the partition columns
Managed tables in Hive:
Managed tables in Hive:
Are Managed by Hive for their data and metadata
Excellent ! Your Answer is Correct.
Can load the data only from HDFS
Can load the data only from local file system
Are useful for enterprise wide data
Hive queries response time is in order of
Hive queries response time is in order of
Milliseconds at least
Seconds at least
Excellent ! Your Answer is Correct.
Hours at least
Minutes at least
Which of the following is the highest level of Data Model in Hive?
Which of the following is the highest level of Data Model in Hive?
Database
Excellent ! Your Answer is Correct.
View
Table
Partitions