title: Hive - LIKE Operator
body: <p>I can not figure out how I deal with that problem: </p>
  
  <p>This is my Data:</p>
  
  <pre><code>Table1:         Table2:
  BRAND           PRODUCT           SOLD
  Sony            Sony ABCD         1233
  Apple           Sony adv          1233
  Google          Sony aaaa         1233
  IBM             Apple 123         1233
  etc.            Apple 345         1233
                  IBM 13123         1233
  </code></pre>
  
  <p>Is it possible to filter the query that I have a table where stands the brand and the total solds?
  My idea is:</p>
  
  <pre><code>Select table1.brand, sum(table2.sold) from table1
  join table2
  on (table1.brand LIKE '%table2.product%')
  group by table.1.brand
  </code></pre>
  
  <p>That was my idea, but i always get an Error</p>
  
  <p>The biggest problem is the Like-Operator or is there any other solution?</p>