phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: Joining with a bigint
Date Wed, 09 Apr 2014 21:02:16 GMT
Guess the index might be the cause here. Could you please attach the
"create index" DDL?


On Wed, Apr 9, 2014 at 4:55 PM, Dan Di Spaltro <dan.dispaltro@gmail.com>wrote:

> Yeah I am actually having trouble reproducing it with a simpler example as
> well.  I was trying to do it but then ran into
> https://issues.apache.org/jira/browse/PHOENIX-926 my guess is the
> original issue I ran into might have something to do with indexes I was
> using.  Ill keep digging and file an issue when I can actually reproduce it
> with a similar example.
>
>
> On Wed, Apr 9, 2014 at 1:05 PM, Maryann Xue <maryann.xue@gmail.com> wrote:
>
>> Hi Dan,
>>
>> Which version did you check out? I could not reproduce this problem,
>> either with master branch or 4.0 branch. Could you please check it again?
>>
>>
>> Thanks,
>> Maryann
>>
>>
>> On Wed, Apr 9, 2014 at 10:58 AM, James Taylor <jamestaylor@apache.org>wrote:
>>
>>> 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 <dan.dispaltro@gmail.com
>>> > 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 <
>>>> 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.  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
>>>>
>>>
>>>
>>
>>
>> --
>> Thanks,
>> Maryann
>>
>
>
>
> --
> Dan Di Spaltro
>



-- 
Thanks,
Maryann

Mime
View raw message