Hi ,
I am trying to run query using stats with following flags as set,but it is
always running map reduce job instead of getting direct result from metastore
(Hive 0.13.0.2.1.2.1-471).can some please suggest me to run optimized query or
a workaround it .
Thanks in advance
Set hive.stats.reliabl
Subject: Re: HIveserver jdbc set configurations
You can execute a 'set property=value' statements using Statement.execute().
Such change will only be visible in the current session.
thanks
Prasad
On Fri, Oct 10, 2014 at 4:11 AM, Navdeep Agrawal
mailto:navdeep_agra...@symantec.com&g
You can change the mapreduce.job.queuename by appending it to connection string
after ‘?’ like jdbc:hive2//url:1/db?mapreduce.job.queuename=q1
From: Chen Song [mailto:chen.song...@gmail.com]
Sent: Friday, October 10, 2014 2:38 AM
To: user
Subject: mapreduce.job.queuename doesn't work with hiv
Hi,
I am connecting to hive server2 through jdbc and want to set some properties
like mapreduce.queuename;hive.compute.query.using.stats; how can I achieve that
through java .
Thanks,
Navdeep
Well not the correct way ,you can check the statistics in mysql part_col_stats
like tables in mysql data base if you are using mysql stat database .
Or the other way is calling max,min,distinct on int columns ,largest length on
string columns etc,if they run whole map reduce on these operation th
Well the problem exactly didn’t get solved but I observed this kind of behavior
is persistent when I partition my table by date type otherwise its working .
may its worth a issue .
Thank you
From: Navdeep Agrawal [mailto:navdeep_agra...@symantec.com]
Sent: Thursday, July 24, 2014 1:22 PM
To
11-01' and load_inst_id is not null limit 100
analyze
analyze table devstat partition(server_date='2013-11-30') compute statistics
for columns load_inst_id;
any help will be highly appreciated .stuck here long time …
thanks in advance .
From: Navdeep Agrawal [mailto:navdeep_agra..
11-01' and load_inst_id is not null limit 100
analyze
analyze table devstat partition(server_date='2013-11-30') compute statistics
for columns load_inst_id;
any help will be highly appreciated .stuck here long time …
thanks in advance .
From: Navdeep Agrawal [mailto:navdeep_agra..
db are:
hive.stats.dbclass=
hive.stats.dbconnectionstring=
On 23 July 2014 16:07, Navdeep Agrawal
mailto:navdeep_agra...@symantec.com>> wrote:
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 expl
te=’2013-11-30′) compute statistics;
--Bala G.
On Tue, Jul 22, 2014 at 10:14 AM, Navdeep Agrawal
mailto:navdeep_agra...@symantec.com>> wrote:
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.stat
table mytable partition(server_date=’2013-11-30′) compute statistics;
--Bala G.
On Tue, Jul 22, 2014 at 10:14 AM, Navdeep Agrawal
mailto:navdeep_agra...@symantec.com>> wrote:
i am trying to compute statistics on ORC File but i am unable see any changes
in PART_COL_STATS as well on using
: 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
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
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
14 matches
Mail list logo
