hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Min Zhou <coderp...@gmail.com>
Subject about join query
Date Wed, 10 Jun 2009 06:38:18 GMT
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

Mime
View raw message