Hive data models represent
Directories in HDFS
Excellent ! Your Answer is Correct.
Table in HDFS
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 absent but can be accessed
Excellent ! Your Answer is Correct.
Physically present and can be accessed
Physically absent and can’t be accessed
Physically present but can’t be accessed
On dropping external tables, Hive:
On dropping external tables, Hive:
Retains data, but deletes metadata
Excellent ! Your Answer is Correct.
Retains metadata, but deletes data
Drops both, data and metadata
Retains both, data and metadata
On dropping managed tables, Hive:
On dropping managed tables, Hive:
Drops both, data and metadata
Excellent ! Your Answer is Correct.
Retains data, but deletes metadata
Retains metadata, but deletes data
Retains both, data and metadata
Hive managed tables stores the data in
Hive managed tables stores the data in
HDFS warehouse path
Excellent ! Your Answer is Correct.
Any HDFS path
Local Linux path
None of the Option is Correct
Hive can load the data from:
Hive can load the data from:
All Options are Correct
Excellent ! Your Answer is Correct.
Local File system
HDFS File system
Output of a Pig Job
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.
Are useful for enterprise wide data
Can load the data only from local file system
Can load the data only from HDFS
Hive queries response time is in order of
Hive queries response time is in order of
Seconds at least
Excellent ! Your Answer is Correct.
Minutes at least
Hours at least
Milliseconds 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