Re: inconsistent results when doing a select over a join

[Guy Doulberg]

Thanks, 
I am trying to reproduce it again,

But what should I send the ML?



On Mon 09 Jan 2012 07:54:24 PM IST, Edward Capriolo wrote:
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 <mailto: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
    <mailto: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