Beehive as an Operator

Question

[enter link description here] [1]

Table1:

BRAND
Sony
Apple
Google
Ibm
and etc.

Table2:

hive> select * from PRODUCT; SonyABC,Applepqr 101 Sonyadvv,IBMabc 102 Sonyaaaa 103 Apple123,Sonyxyz 104 Apple345,IBMabc 105 IBM13123SonyABC 106 My data is like above.and i need output like bellow.Please suggest a query SonyABC,Applepqr 101 Sony,Apple Sonyadvv,IBMabc 102 Sony,IBM Sonyaaaa 103 Sony Apple123,Sonyxyz 104 Apple,Sony Apple345,IBMabc 105 Apple,IBM IBM13123,SonyABC 106 IBM,Sony 

Answer 1

There may be some problem in your data, but it works as follows hive> select * from BRAND; Sony Apple Google IBM

 hive> select * from PRODUCT; SonyABC 101 Sonyadvv 102 Sonyaaaa 103 Apple123 104 Apple345 105 IBM13123 106 select PRODUCT.*, BRAND.* from BRAND, PRODUCT where trim(PRODUCT_ID) like concat(trim(BRAND_ID),'%'); SonyABC 101 Sony Sonyadvv 102 Sony Sonyaaaa 103 Sony Apple123 104 Apple Apple345 105 Apple IBM13123 106 IBM Time taken: 11.381 seconds, Fetched: 6 row(s)