Can you create more than one table in Hive for a single data file?

1.	Can you create more than one table in Hive for a single data file?
Answer» In Hive, multiple tables can be CREATED for a SINGLE data file using the same HDFS DIRECTORY. As we know already that metastore acts as the central repository for Hive metadata and it stores metadata like schemas and locations. Data already remain in the same file. So, it becomes a very easy task to RETRIEVE the different results for the corresponding same data based UPON the schema.

Answer»

In Hive, multiple tables can be CREATED for a SINGLE data file using the same HDFS DIRECTORY. As we know already that metastore acts as the central repository for Hive metadata and it stores metadata like schemas and locations.

Data already remain in the same file. So, it becomes a very easy task to RETRIEVE the different results for the corresponding same data based UPON the schema.

Discussion

No Comment Found

Related InterviewSolutions

What do you mean by trigger in SQL?
What do you mean by SQL injection?
What do you mean by alias in SQL?
What are the differences between IN and BETWEEN operators?
What do you mean by SciPy?
Explain pass, continue and break statements in Python?
How can you differentiate between append() and extend() in Python?
Explain Decorator in Python?
How memory can be managed in Python?
How can you differentiate between “is” and “==” operators in Python?

Can you create more than one table in Hive for a single data file?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment