Can you reproduce the issue? possibly with the smaller tables and send that to the ML?
Edward On Mon, Jan 9, 2012 at 12:46 PM, Guy Doulberg <guy.doulb...@conduit.com>wrote: > Hey Dave, > I didn't understand your question, > > The Inconsistant is slightly different, about 2% of differences, > > Thanks > > Guy > > On 01/09/2012 07:05 PM, David Houston wrote: > > Hi Guy, > > Inconsistant by way of the results are total off or the order is different? > > Thanks > > Dave > On Jan 9, 2012 5:03 PM, "Guy Doulberg" <guy.doulb...@conduit.com> wrote: > >> Hi guys, >> >> We are using hive for a while now, and recently we have encountered an >> issue we just can't understand, >> >> We are selecting(the select includes count(*)) over a join of two big >> tables. >> >> We ran the same query twice consequently over the same two tables , and >> each time the result were slightly different. >> >> We don't know how should we debug this issue, where should we look, any >> ideas? >> >> Thanks >> >> Guy Doulberg, >> Data infrastructure engineer, >> Conduit >> >