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.
>  

Reply via email to