SAP HANA and Hadoop are two different things. SAP HANA is an ANSI SQL database. It maintains ACID constraints, and therefore is good for transactional & analytical applications. It is high performing database which is good for transactional applications. You can also go ahead and execute complex queries over this high performing database.
Hadoop is a framework that allows you to store large datasets in a distributed environment, so that, you can process it parallely. The power of Hadoop lies in storing data that can be of different varieties, i.e. structured, semi-structured & un-structured data. But Hadoop is not suited for transactional applications.
Talking about SAP HANA VORA, it is in-memory query engine which extends Apache Spark execution framework to provide interactive analytics on Hadoop. It provides in-memory processing on top of Hadoop and enterprise functionality to simplify the IT landscape for organisations.
To summarize I would say, HANA is an in-memory database which focuses on performance, while Hadoop’s power lies in reducing the storage cost. SAP HANA can be used for transactional purposes & Hadoop can used for storing unstructured data in an efficient manner.