hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Navdeep Agrawal <>
Subject RE: Hive Statistics
Date Wed, 23 Jul 2014 09:46:50 GMT
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 every time
a new row is getting created  in mysql db in part_col_stats table .

From: Andre Araujo []
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 db are:

On 23 July 2014 16:07, Navdeep Agrawal <<>>
Thank you Nitin for reply. I am using mysql database ,and also I can see new row created for
the partition ,but all values are zero . I think explicitly giving mysql data base wont make
a difference .

From: Nitin Pawar [<>]
Sent: Tuesday, July 22, 2014 11:05 PM
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 Agrawal <<>>

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=true;

to get max value of a column it is running full Map reduce on column ..
what i want to use is max value stored in meta store ,but i am unable to catch these statistics

my table desc is
load_inst_id int
src_filename string
server_date date

my analyze query is
analyze table mytable partition(server_date=’2013-11-30′) compute statistics for columns

i am always getting 0 as loadinstant id ,i have to turn off my hive.compute.query.using.stats
to get correct result(through map reduce max(load_inst_id))

Nitin Pawar

André Araújo
Big Data Consultant/Solutions Architect
The Pythian Group - Australia -<>
Office (calls from within Australia): 1300 366 021 x1270
Office (international): +61 2 8016 7000  x270 OR +1 613 565 8696   x1270
Mobile: +61 410 323 559
Fax: +61 2 9805 0544
IM: pythianaraujo @ AIM/MSN/Y! or<> @ GTalk

“Success is not about standing at the top, it's the steps you leave behind.” — Iker
Pou (rock climber)


View raw message