Tag: Hadoop Hive

Directories in HDFS

Table in HDFS

Table in Metastore DB

None of the Option is Correct

Physically absent but can be accessed

Physically present and can be accessed

Physically absent and can’t be accessed

Physically present but can’t be accessed

Retains data, but deletes metadata

Retains metadata, but deletes data

Drops both, data and metadata

Retains both, data and metadata

Drops both, data and metadata

Retains data, but deletes metadata

Retains metadata, but deletes data

Retains both, data and metadata

HDFS warehouse path

Any HDFS path

Local Linux path

None of the Option is Correct

All Options are Correct

Local File system

HDFS File system

Output of a Pig Job

All Options are 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

Are Managed by Hive for their data and metadata

Are useful for enterprise wide data

Can load the data only from local file system

Can load the data only from HDFS

Seconds at least

Minutes at least

Hours at least

Milliseconds at least

Database

View

Table

Partitions