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
