Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A439B9C75 for ; Mon, 9 Jan 2012 17:06:23 +0000 (UTC) Received: (qmail 74212 invoked by uid 500); 9 Jan 2012 17:06:22 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 74142 invoked by uid 500); 9 Jan 2012 17:06:21 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 74134 invoked by uid 99); 9 Jan 2012 17:06:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jan 2012 17:06:21 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of root@crankyadmin.net does not designate 209.85.212.176 as permitted sender) Received: from [209.85.212.176] (HELO mail-wi0-f176.google.com) (209.85.212.176) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jan 2012 17:06:14 +0000 Received: by wibhq4 with SMTP id hq4so4169701wib.35 for ; Mon, 09 Jan 2012 09:05:50 -0800 (PST) MIME-Version: 1.0 Received: by 10.180.82.5 with SMTP id e5mr6088532wiy.18.1326128750322; Mon, 09 Jan 2012 09:05:50 -0800 (PST) Received: by 10.180.105.232 with HTTP; Mon, 9 Jan 2012 09:05:50 -0800 (PST) X-Originating-IP: [92.40.254.158] Received: by 10.180.105.232 with HTTP; Mon, 9 Jan 2012 09:05:50 -0800 (PST) In-Reply-To: <4F0B1DB0.2030209@conduit.com> References: <4F0B1DB0.2030209@conduit.com> Date: Mon, 9 Jan 2012 17:05:50 +0000 Message-ID: Subject: Re: inconsistent results when doing a select over a join From: David Houston To: user@hive.apache.org Content-Type: multipart/alternative; boundary=f46d0443041416e2dd04b61b695b X-Virus-Checked: Checked by ClamAV on apache.org --f46d0443041416e2dd04b61b695b Content-Type: text/plain; charset=ISO-8859-1 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" 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 > --f46d0443041416e2dd04b61b695b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Hi Guy,

Inconsistant by way of the results are total off or the order is differe= nt?

Thanks

Dave

On Jan 9, 2012 5:03 PM, "Guy Doulberg"= <guy.doulberg@conduit.com> wrote:

Hi guys,

We are using hive for a while now, and recently we have encountered an issu= e we just can't understand,

We are selecting(the select includes count(*)) over a join of two big table= s.

We ran the same query twice consequently over the same two tables , and eac= h 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

--f46d0443041416e2dd04b61b695b--