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 cha...
Comments
Post a Comment