Just doing a poll to see
What are the preferred methods to perform Direct Query for data in Hadoop or any other big data platform like Netezza, TeraData, etc. to obtain satisfactory levels of performance with respect to fetch times when almost all data is needed at the onset giving the user ability to drill into record level detail and possible tips/tricks for the same. I understand it is all relative but a discussion such as this in a summary form might help.
I am hoping this poll serves as a guide to many of us embarking or already on the path. Can add additional options
Sorry couldn't do a poll as the option is disabled
1. HBase
2. HBase/Phoenix - JDBC
3. Hive
4. Hive with Tez
5. Solr
6. JethroData
7. Netezza
8. TeraData
