HIve Interview Questions

1. What is a map join in hive

2. UDF?

3. Distinct- how is it used in hive? Is there any other way to get the ‘distinct’ done without using

the key word?

4. What is metastore?

5. Where we can get the information of a metastore.

6. What is parameter in hive-site.xml which corresponds to metastore configuration?

7. If you have 10 different user and you want to change the metastore for one user, how you can

do that?

8. Suppose you have data from Jan to Dec and one month data is corrupted, what strategies would

you use so that your existing clean data need not be uploading again?

9. What is dynamic partitioning?

10. What is the restriction on dynamic partitioning (strict mode - non-strict mode?).

11. Default value per node of number of dynamic partition supported.

12. What is rlike?

13. External table and manage table.

14. What if you have to create a manage table from external table, what would happen to the data

(data will move or copy).

15. Can we change the table name, how?

16. Can we change column name, how?

17. Map join how that works, is there any setting that we need to do or not?

18. Something on serde?

19. Rc file format?