phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Riesland, Zack" <>
Subject RE: Phoenix vs Hive
Date Tue, 14 Jul 2015 12:47:15 GMT
If the counts are, indeed, different, then the next question is: how are you getting data from
hive to phoenix?

From: anil gupta []
Sent: Tuesday, July 14, 2015 3:48 AM
Subject: Re: Phoenix vs Hive

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( 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 <<>>

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 & Regards,
Anil Gupta
View raw message