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 <[email protected]>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 <[email protected]> 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 <[email protected]>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 <[email protected] >>> > 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 < >>>> [email protected]> 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
