@sushil nagurIn addition to @Sandeep Nemuri If you are upgrading Ambari that should not impact much to the application team. If you are upgrading HDP stack, then you need to copy sqoop jars(like Teradata, Netezza etc.,) or custom jars to latest HDP version. Other than that there should not be much impact.
One more thing if you are trying for rolling upgrade then you need to change Hive ports after upgrade to 10000.
Hope this helps you.