Lingual is a powerful tool that will let you query, integrate - multiple data sources, migrate workloads, to hadoop via an ANSI SQL interface. Lingual comes with a CLI, JDBC driver, shell, as well as out of the box integrations to HDFS, HBase, ORCL, S#, Redshift and more. It is open source and free to use.
http://www.cascading.org/lingual