All the components in Aster Data seems to have a similar component in Hadoop stack.
AFS => HDFS
SQL-MR => Hive
AMC => Ambari
ACT => beeline/hive terminal
Postgres for storing metadata => Hive can be configured to store metadata in any RDBMS
Queen/Worker => NameNode/Datanode
SQL-GR => Giraph
Apart from providing a package of pre-built functions, is there anything that is strikingly different and not available in Hadoop?
I think u unnecessarily went for nitty grity. The question was in conceptual terms. Say Netezza and Teradata MPP. In Basic concept they are same and they do the same kind of work but they are two different physical implementation with their own algo,storage,indexes etc.
On a very high level Hive and Aster has similarity as they both run map reduce on a distributed storage .
The Only difference on very high level is that at very high level Aster can run typical RDMS query as well as implicit map reduce where as Hive is only map reduce.