Query Regarding Preaggregation

[Anubhav Tarar]

Hi Dev,

Is there a way that i can create preaggregate tables in hive to improve the
performance of my aggregation queries which takes too much time?

-- 
Thanks and Regards

*   Anubhav Tarar *


* Software Consultant*
  *Knoldus Software LLP    *
   LinkedIn  Twitter
fb 
  mob : 8588915184

Re: Hiveserver2 - Beeline How to enable progress bar (Tez)

[Jyotsna G]

Do you have other configurations enabled?
https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.tez.exec.inplace.progress

https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Beeline%E2%80%93CommandLineShell



On Wed, Mar 7, 2018 at 9:28 AM, Shankar Mane  wrote:

> Does anyone has this is working. I am still looking for response here.
>
> On Fri 2 Feb, 2018, 3:03 PM Shankar Mane,  wrote:
>
>> I have set Tez as a default execution engine.
>>
>> On 02-Feb-2018 2:59 PM, "Margusja"  wrote:
>>
>> Does it depends what kind of engine you are using - tez versus mr?
>>
>> Br margus
>>
>>
>> On 1 Feb 2018, at 17:57, Shankar Mane  wrote:
>>
>> Any update?
>>
>> I m not getting progress bar with beeline client. tried both embedded and
>> remote connection.
>>
>> It's working properly with Hive CLI.
>>
>>
>> On 30-Jan-2018 6:01 PM, "Shankar Mane"  wrote:
>>
>> May i know, how to enable Tez progress bar in beeline ? I am using Tez
>> has a execution engine.
>>
>> I have followed some steps but failed. steps are:
>> set hive.async.log.enable=false
>> set hive.server2.in.place.progress=true
>>
>>
>> Env Details:
>> RHEL
>> hive 2.3.2
>> hadoop 2.9.0
>> Tez 0.9.1
>> Apache Distribution
>>
>> Also while connecting to hiveserver, i am getting below error:
>> 
>>
>> 2018-01-30T16:08:46,204  INFO [main] http.HttpServer: Started
>> HttpServer[hiveserver2] on port 10002
>> Exception in thread "org.apache.hadoop.hive.common.JvmPauseMonitor$
>> Monitor@2489e84a" java.lang.NoSuchMethodError: com.google.common.base.
>> Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J
>> at org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor.run(
>> JvmPauseMonitor.java:185)
>> at java.lang.Thread.run(Thread.java:748)
>>
>> 
>>
>>
>>
>>
>>

Re: Hiveserver2 - Beeline How to enable progress bar (Tez)

[Shankar Mane]

Does anyone has this is working. I am still looking for response here.

On Fri 2 Feb, 2018, 3:03 PM Shankar Mane,  wrote:

> I have set Tez as a default execution engine.
>
> On 02-Feb-2018 2:59 PM, "Margusja"  wrote:
>
> Does it depends what kind of engine you are using - tez versus mr?
>
> Br margus
>
>
> On 1 Feb 2018, at 17:57, Shankar Mane  wrote:
>
> Any update?
>
> I m not getting progress bar with beeline client. tried both embedded and
> remote connection.
>
> It's working properly with Hive CLI.
>
>
> On 30-Jan-2018 6:01 PM, "Shankar Mane"  wrote:
>
> May i know, how to enable Tez progress bar in beeline ? I am using Tez has
> a execution engine.
>
> I have followed some steps but failed. steps are:
> set hive.async.log.enable=false
> set hive.server2.in.place.progress=true
>
>
> Env Details:
> RHEL
> hive 2.3.2
> hadoop 2.9.0
> Tez 0.9.1
> Apache Distribution
>
> Also while connecting to hiveserver, i am getting below error:
> 
>
> 2018-01-30T16:08:46,204  INFO [main] http.HttpServer: Started
> HttpServer[hiveserver2] on port 10002
> Exception in thread
> "org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor@2489e84a"
> java.lang.NoSuchMethodError:
> com.google.common.base.Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J
> at
> org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor.run(JvmPauseMonitor.java:185)
> at java.lang.Thread.run(Thread.java:748)
>
> 
>
>
>
>
>