Are you upgrading your HDP(cluster) or just the hive component(not recommended)?
If you are upgrading HDP generally speaking you should be good. Scripts should continue to work.( In general though if you are using some specific features you may run into issues). If you are looking to take advantage of new features in hive2 that's a different story and really isn't the same as upgrading.
Why don't you download the latest sandbox and test our your scripts to see what potential issues you could run into?