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
