From user-return-515-apmail-phoenix-user-archive=phoenix.apache.org@phoenix.incubator.apache.org Wed Apr 9 14:58:50 2014 Return-Path: X-Original-To: apmail-phoenix-user-archive@minotaur.apache.org Delivered-To: apmail-phoenix-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 539FC10EDF for ; Wed, 9 Apr 2014 14:58:50 +0000 (UTC) Received: (qmail 20045 invoked by uid 500); 9 Apr 2014 14:58:47 -0000 Delivered-To: apmail-phoenix-user-archive@phoenix.apache.org Received: (qmail 18035 invoked by uid 500); 9 Apr 2014 14:58:45 -0000 Mailing-List: contact user-help@phoenix.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@phoenix.incubator.apache.org Delivered-To: mailing list user@phoenix.incubator.apache.org Received: (qmail 17098 invoked by uid 99); 9 Apr 2014 14:58:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Apr 2014 14:58:37 +0000 X-ASF-Spam-Status: No, hits=-1998.1 required=5.0 tests=ALL_TRUSTED,HTML_MESSAGE,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 09 Apr 2014 14:58:36 +0000 Received: (qmail 16094 invoked by uid 99); 9 Apr 2014 14:58:12 -0000 Received: from minotaur.apache.org (HELO minotaur.apache.org) (140.211.11.9) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Apr 2014 14:58:12 +0000 Received: from localhost (HELO mail-yk0-f172.google.com) (127.0.0.1) (smtp-auth username jamestaylor, mechanism plain) by minotaur.apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Apr 2014 14:58:12 +0000 Received: by mail-yk0-f172.google.com with SMTP id 200so2261661ykr.31 for ; Wed, 09 Apr 2014 07:58:11 -0700 (PDT) MIME-Version: 1.0 X-Received: by 10.236.31.40 with SMTP id l28mr14828147yha.17.1397055491703; Wed, 09 Apr 2014 07:58:11 -0700 (PDT) Received: by 10.170.195.68 with HTTP; Wed, 9 Apr 2014 07:58:11 -0700 (PDT) In-Reply-To: References: Date: Wed, 9 Apr 2014 07:58:11 -0700 Message-ID: Subject: Re: Joining with a bigint From: James Taylor To: "user@phoenix.incubator.apache.org" Content-Type: multipart/alternative; boundary=089e0111b99a50880c04f69d54a3 X-Virus-Checked: Checked by ClamAV on apache.org --089e0111b99a50880c04f69d54a3 Content-Type: text/plain; charset=ISO-8859-1 Definitely a bug - please file a JIRA and we'll get this fixed up in our next point release. Thanks, James On Wed, Apr 9, 2014 at 12:24 AM, Dan Di Spaltro wrote: > It actually looks like the star operator in the select clause is causing > the issue to happen, if I pick a specific attribute it works. If I do > foo.* then it fails, or if I do a global star it fails. > > > On Tue, Apr 8, 2014 at 11:05 PM, Dan Di Spaltro wrote: > >> I am using a pretty recent version of 4.0 and running into a weird >> problem that is probably a bug. If I create a simple table >> >> create foo ( >> id bigint not null primary key, >> attr varchar) >> >> create foo_bar ( >> id bigint not null primary key, >> foo_id bigint, >> bar_id bigint >> ) >> >> create bar ( >> id bigint not null primary key, >> attr2 varchar >> ) >> >> And try to run select * from foo inner join foo_bar on foo_bar.foo_id = >> foo.id >> >> I get a type mismatch "type mismatch. expected: LONG but was: VARCHAR at >> column:" is this some compiler issue? Have you successfully joined on a >> LONG? >> >> Thanks, >> >> -Dan >> >> -- >> Dan Di Spaltro >> > > > > -- > Dan Di Spaltro > --089e0111b99a50880c04f69d54a3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Definitely a bug - please file a JIRA and we'll get th= is fixed up in our next point release.

Thanks,
James


On Wed, Apr 9, 2014 at 12:24 AM, Dan Di Spaltro <dan.dispaltro@gmail= .com> wrote:
It actually looks like the star operator in the select cla= use is causing the issue to happen, if I pick a specific attribute it works= . =A0If I do foo.* then it fails, or if I do a global star it fails.
<= div class=3D"gmail_extra">


On Tue, Apr 8, 2014 at 11:05 PM, Dan Di = Spaltro <dan.dispaltro@gmail.com> wrote:
I am using a pretty recent version of 4.0 and running into= a weird problem that is probably a bug. =A0If I create a simple table
=
create foo (
=A0id bigint not null primary key,
=A0attr varchar)

create foo_bar (
= =A0id bigint not null primary key,
=A0foo_id bigint,
= =A0bar_id bigint
)

create bar (
=A0id bigint not null primary key,
=A0attr2 varchar
)

And try to run s= elect * from foo inner join foo_bar on foo_bar.foo_id =3D foo.id

I get a type= mismatch "type mismatch. expected: LONG but was: VARCHAR at column:&q= uot; is this some compiler issue? =A0Have you successfully joined on a LONG= ?

Thanks,

-Dan

--
Dan Di Spaltro



--
Dan Di Spaltro
--089e0111b99a50880c04f69d54a3--