Drill your data on hadoop cluster using Apache Drill
I have been working on MapR and Cloudera big data distribution for the past year.  I have been fascinated by its capability.  One of my favorite is Apache Drill, a schema on read SQL interface to HDFS file system.  Its pretty slick, you can query the data via its native shell interface or its web interface or using Drill Explorer client that you can install on your machine.  Learn more about Apache Drill and  best practices for Apache Drill
Happy Drilling !