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
