Hadoop data exploration tools

[Knowledge gatherer]

Hi all,

    What are the various data exploration tools available supporting ANSI
SQL commands, which can run fast to give the output.

Thanks in advance...