hive:
https://www.cnblogs.com/yanshw/p/12058160.html
https://www.cnblogs.com/qingyunzong/p/8847597.html
spark:
https://blog.csdn.net/kaede1209/article/details/81145560