[mailto:a...@flonet.com]
> *Sent:* Tuesday, October 21, 2014 6:19 PM
> *To:* user; lars hofhansl
>
> *Subject:* Re: count on large table
>
>
>
> Hi Lars,
>
>
>
> We have 10 Region Servers and 2 1TB on each. The table is not salted, but
> we pre split regions when
Please check IPV6 , if enabled …disable it and synchronize the ntpd and
restart. It might help.
From: Abe Weinograd [mailto:a...@flonet.com]
Sent: Tuesday, October 21, 2014 6:19 PM
To: user; lars hofhansl
Subject: Re: count on large table
Hi Lars,
We have 10 Region Servers and 2 1TB on each
gt; *From:* Abe Weinograd
> *To:* user ; lars hofhansl
> *Sent:* Monday, October 13, 2014 9:30 AM
>
> *Subject:* Re: count on large table
>
> Hi Lars,
>
> Thanks for following up.
>
> Table Size - 120G doing a du on HDFS. We are using Snappy compression on
> t
o attach a profiler to one of the busy
region server, or at least get us stack trace?
Thanks.
-- Lars
From: Abe Weinograd
To: user ; lars hofhansl
Sent: Monday, October 13, 2014 9:30 AM
Subject: Re: count on large table
Hi Lars,
Thanks for following up.
Table Size - 120G doing a du on
t;
> -- Lars
>
> --
> *From:* Abe Weinograd
> *To:* user
> *Sent:* Wednesday, October 8, 2014 9:15 AM
> *Subject:* Re: count on large table
>
> Good point. I have to figure out how to do that in a SQL Tool like
> Squirrel or workben
ber 8, 2014 9:15 AM
Subject: Re: count on large table
Good point. I have to figure out how to do that in a SQL Tool like Squirrel or
workbench.
Is there any obvious thing i can do to help tune this? I know that's a loaded
question. My client scanner batches are 1000 (also tried 100
To: user
Subject: Re: count on large table
Good point. I have to figure out how to do that in a SQL Tool like Squirrel or
workbench.
Is there any obvious thing i can do to help tune this? I know that's a loaded
question. My client scanner batches are 1000 (also tried 1 with no
Good point. I have to figure out how to do that in a SQL Tool like
Squirrel or workbench.
Is there any obvious thing i can do to help tune this? I know that's a
loaded question. My client scanner batches are 1000 (also tried 1 with
no luck).
Thanks,
Abe
On Tue, Oct 7, 2014 at 9:09 PM, su.
Hi, Abe
Maybe setting the following property would help...
phoenix.query.timeoutMs
360
Thanks,
Sun
From: Abe Weinograd
Date: 2014-10-08 04:34
To: user
Subject: count on large table
I have a table with 1B rows. I know this can is very specific to my
environment, but just d
