work in spark all last summer. So, I don’t think it is
> built into hive.
>
> Hope this helps you,
>
> ~Nikki
>
>
>
> *From: *Robert Grandl
> *Reply-To: *"user@hive.apache.org" , Robert Grandl <
> rgra...@yahoo.com>
> *Date: *Wednesday, D
Wednesday, December 21, 2016 at 9:04 AM
To: User , Dev
Subject: Re: Hive statistics
Hi guys,
I am wondering. Is there any other mailing list for hive related questions?
I feel there is not much activity on the user/dev hive mailing lists or at
least not much support in answering my questions.
Than
Hi guys,
I am wondering. Is there any other mailing list for hive related questions?
I feel there is not much activity on the user/dev hive mailing lists or at
least not much support in answering my questions.
Thanks,Robert
On Tuesday, December 20, 2016 11:01 PM, Robert Grandl
wrote:
Hi guys,
I am wondering if it's possible to estimate the number of distinct keys and
their distribution in a way or another.
More concretely, for every stage, it is possible to determine the number of
distinct keys and for each key the number of values before the data is
actually processed?
T
: user@hive.apache.org
Subject: [HELP]Hive Statistics
Stuck .need help
I created a small table with multiple partition desc (id int ,term int)
partitioned by id ,whenever I run analyze on any id I am getting perfectly good
answers . I am unable to figure out the difference each file is making
.@symantec.com]
Sent: Wednesday, July 23, 2014 3:17 PM
To: user@hive.apache.org<mailto:user@hive.apache.org>
Subject: RE: Hive Statistics
I think that is already configured since I am able to get statistics in other
tables .
Because if I have not set these parameters why every time a new r
.@symantec.com]
Sent: Wednesday, July 23, 2014 3:17 PM
To: user@hive.apache.org
Subject: RE: Hive Statistics
No I have not set these to mysql db . when I set them to the one I am using for
hive I am getting stat publisher not getting initialized .but if I have not set
these parameters why eve
...@pythian.com]
Sent: Wednesday, July 23, 2014 1:22 PM
To: user
Subject: Re: Hive Statistics
Hi, Navdeep,
Please note that the configuration for the stats database is separate from the
configuration for the metastore db.
Can you confirm you have both to use a mysql db?
The properties for the stats
..@gmail.com]
> *Sent:* Tuesday, July 22, 2014 11:05 PM
> *To:* user@hive.apache.org
> *Subject:* Re: Hive Statistics
>
>
>
> by default hive stores the statistics in derby database.
>
>
>
> If you want a persistent look at column statistics, you may want to create
>
: user@hive.apache.org
Subject: Re: Hive Statistics
by default hive stores the statistics in derby database.
If you want a persistent look at column statistics, you may want to create
mysql based database for column statistics.
Your queries look fine
On Tue, Jul 22, 2014 at 10:50 PM, Navdeep
by default hive stores the statistics in derby database.
If you want a persistent look at column statistics, you may want to create
mysql based database for column statistics.
Your queries look fine
On Tue, Jul 22, 2014 at 10:50 PM, Navdeep Agrawal <
navdeep_agra...@symantec.com> wrote:
> Hi ,
Hi ,
i am trying to compute statistics on ORC File but i am unable see any changes
in PART_COL_STATS as well on using
set hive.compute.query.using.stats=true;
set hive.stats.reliable=true;
set hive.stats.fetch.column.stats=true;
set hive.stats.fetch.partition.stats=true;
set hive.cbo.enable=tr
e.org<mailto:user@hive.apache.org>"
mailto:user@hive.apache.org>>
Subject: Re: Hive Statistics information
Hi Sanjay,
What do the logs say when you fire the ANALYZE TABLE... statement on a
table ?
One minor correction to the db connectionstring would be to use & for
the quer
c.Driver
> hive.stats.retries.max=0
> hive.stats.retries.wait=3000
>
> However in the MYSQL hive statistics tables , they don't seem to have
> any data ?
>
> Where does Hive store the statistics information ?
>
> sanjay
>
> CONFIDENTIALITY NOTICE
> =
password=hive_user_vso1
hive.stats.jdbc.timeout=30
hive.stats.jdbcdriver=com.mysql.jdbc.Driver
hive.stats.retries.max=0
hive.stats.retries.wait=3000
However in the MYSQL hive statistics tables , they don't seem to have any data ?
Where does Hive store the statistics information ?
sanjay
CO
15 matches
Mail list logo
