Hadoop is a distributed computing (E.g. MapReduce) and storage (HDFS) framework. Hive is part of the hadoop ecosystem and provides an sql-like interface to hadoop. Redshift is a proprietary database system by Amazon. It's functionality is comparable with Hive on top of Hadoop: but lacking lots of options.