Re: Long time compiling query/explain.....

2017-08-14 Thread Gopal Vijayaraghavan
> Running Hive 2.2 w/ LLAP enabled (tried the same thing in Hive 2.3 w/ LLAP), > queries working but when we submit queries like the following (via our > automated test framework), they just seem to hang with Parsing > CommandOther queries seem to work fine Any idea on what's going on

Long time compiling query/explain.....

2017-08-14 Thread dan young
Running Hive 2.2 w/ LLAP enabled (tried the same thing in Hive 2.3 w/ LLAP), queries working but when we submit queries like the following (via our automated test framework), they just seem to hang with Parsing CommandOther queries seem to work fine Any idea on what's going on or how to

Re: Can one classify Hive as an analytical tool besides storage?

2017-08-14 Thread Jörn Franke
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

Re: Can one classify Hive as an analytical tool besides storage?

2017-08-14 Thread Al Pivonka
https://hadoopecosystemtable.github.io/ On Mon, Aug 14, 2017 at 12:36 PM, Mich Talebzadeh 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

Can one classify Hive as an analytical tool besides storage?

2017-08-14 Thread Mich Talebzadeh
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