About ho_ddeok

ho_ddeok · ‎08-08-2022

FAILED: SemanticException [Error 10017]: Line 5:8 Both left and right aliases encountered in JOIN ''%'' executed sql > select * from table_A a join table_B b on a.col_1 like concat('%', b.col_2, '%') where 1=1 ; I am using HDP 2.6.2 version and Hive 1.2.1000 version

ho_ddeok · ‎08-08-2022

I know Hive only provide equi join. For example, below sql statement. select * from A join B on A.c1 = B.c2 where 1=1; But I want to execute Like join Query in Hive. For example, below sql statement. select * from A join B on A.c1 like B.c2 where 1=1; Please let me know if you know the solution in Hive.

Online	Offline
Last Visited	‎08-09-2022 01:05 AM

Member Since	‎08-08-2022 12:13 AM
Last Visited	‎08-09-2022 01:05 AM
Posts	2

Cloudera Community

Re: How can I solve this sql problem? (like join i...

How can I solve this sql problem? (like join in Hi...