Data Storage for Joins and ACID transactions + Hadoop Cluster

[Divya Gehlot]

Hi,
Which Data storage is best for multiple joins on the run time in Hadoop.
Tried Hive but performance is poor.
Pointers/Guidance appreciated.


Thanks,
Regards,
Divya