You can do major compaction via Hbase shell. Whats the exact query you are running? How you mapped hbase table to hive? You can also run Row_Counter job( http://thinkonhadoop.blogspot.com/2013/11/hbase-table-row-count.html) of hbase to count number of rows. This would help figure out whether Phoenix is wrong or hive.
On Tue, Jul 14, 2015 at 12:20 AM, Halil Ibrahim Simsek <[email protected]> wrote: > Hi, > > I have two questions, > > - When I run the same COUNT query on hive and phoenix they give me > different results. While hive gives 40K phoenix gives 800K. What could > cause this big difference? > - Is there a way to do major compaction via phoenix? > > Thanks. > -- Thanks & Regards, Anil Gupta
