qqp question1: What are the best practices around designing tables on Hive? Also are there any tips/tricks on improving hive performance. I understand that there may not be any silver bullets but any pointers would be very helpful. question2: What are the most useful Hive UDFs/UDAFs in practice, both out of the box or independently developed?