Re: Override COUNT() function

2013-07-02 Thread Navis류승우
2 July 2013 08:50 > To: user@hive.apache.org > Subject: Re: Override COUNT() function > > MetadataOnlyOptimizer changes GBY on partition columns to simple TableScan > with one line dummy. > > I think similar things can be done with stats. > > 2013/6/28 Peter Marron : >> Hi,

RE: Override COUNT() function

2013-07-02 Thread Peter Marron
ssage- From: Navis류승우 [mailto:navis@nexr.com] Sent: 02 July 2013 08:50 To: user@hive.apache.org Subject: Re: Override COUNT() function MetadataOnlyOptimizer changes GBY on partition columns to simple TableScan with one line dummy. I think similar things can be done with stats. 2013/6/28

Re: Override COUNT() function

2013-07-02 Thread Navis류승우
MetadataOnlyOptimizer changes GBY on partition columns to simple TableScan with one line dummy. I think similar things can be done with stats. 2013/6/28 Peter Marron : > Hi, > > > > I feel sure that someone has asked for this before, but here goes… > > > > In the case where I have the query > > >

Override COUNT() function

2013-06-28 Thread Peter Marron
Hi, I feel sure that someone has asked for this before, but here goes... In the case where I have the query SELECT COUNT(*) FROM table; There are many cases where I can determine the count immediately. (For example if I have run something like: ANALYZE TABLE tablename [PARTITIO