Parts of the stinger release are available in HDP 2 (via hive 0.12). This includes optimizer improvements and ORC file format . There is no separate install on top of HDP 2.0 that is required.
What format are you using ? You would want to try using the ORC file format to get a big portion of the improvements.
You can checkout our blogs on ORC – http://hortonworks.com/blog/orcfile-in-hdp-2-better-compression-better-performance/
The next set of improvements are going to be coming through use of Apache Tez and vectorization. Vectorization in hive already available in apache hive trunk codebase (if you want to build that and use on top of HDP2.0). Apache Tez integration work is available on a branch of apache hive codebase.