Depends on your definition of analytical and storage tool. I think Hive (especially with TEZ+llap) would qualify as an analytical tool, especially because you can extend it with sql procedures, can use any Java function directly in sql , it has wide range of analytical functions etc. The storage part is also covered with orc and parquet (and many more formats).
> On 14. Aug 2017, at 18:36, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > > This may be rather mute point. > > We had a discussion in the office about Hive and Impala! > > A colleague insisted that Hive and Impala are storage tools. Changed his mind > when I mentioned that one can use Impala on Hive tables for faster query > access. > > With regard to Hive, my view is that Hive supports HQL that in turn has > analytical functions like RANK etc built in. So in effect it is not only a > storage, but can be used as an analytical tool as well? > > What are your views? > > Thanks, > > Dr Mich Talebzadeh > > LinkedIn > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > > http://talebzadehmich.wordpress.com > > Disclaimer: Use it at your own risk. Any and all responsibility for any loss, > damage or destruction of data or any other property which may arise from > relying on this email's technical content is explicitly disclaimed. The > author will in no case be liable for any monetary damages arising from such > loss, damage or destruction. >