If this does not work, and you have a concrete idea on how to make it work, please open a jira and post your idea there. We can start the discussion from there.
Zheng On Tue, Jun 9, 2009 at 11:54 PM, Zheng Shao <[email protected]> wrote: > We only support EQUI-JOIN: join with equal condition. > > Is it possible to write a UDF: get_pattern(t.url) ? > > SELECT > a.subid, a.id, t.url > FROM > tbl t JOIN aux_tbl a ON get_pattern(t.url) = a.url_pattern > WHERE > t.dt='20090609' > AND a.dt='20090609'; > > Zheng > > > On Tue, Jun 9, 2009 at 11:38 PM, Min Zhou <[email protected]> wrote: > >> I have a query like below, >> >> SELECT >> a.subid, a.id, t.url >> FROM >> tbl t JOIN aux_tbl a ON t.url rlike a.url_pattern >> WHERE >> t.dt='20090609' >> AND a.dt='20090609'; >> >> and parser reported 'FAILED: Error in semantic analysis: line 4:xx Both >> Left and Right Aliases Encountered in Join url_pattern' >> >> how can i correct this query? >> >> Thanks, >> Min >> -- >> My research interests are distributed systems, parallel computing and >> bytecode based virtual machine. >> >> My profile: >> http://www.linkedin.com/in/coderplay >> My blog: >> http://coderplay.javaeye.com >> > > > > -- > Yours, > Zheng > -- Yours, Zheng
