1

I have two tables which are using ORC compression and am using TEZ as execution engine. Table_a contains more than 900k records and table_b contains 17 million records. This query taking longer time I have waited for 2 days but the query execution was not completed. what am I doing wrong in this query.

select min(up.id) as comp002uniqueid, min(cp.product_id) as p_id 
from 
(select * from table_a where u_id is null) up ,  table_b cp 
where  cp.title like concat('% ',up.productname,' %') 
group by up.productname;
James Z
  • 12,209
  • 10
  • 24
  • 44
Shiva Prasad G
  • 27
  • 6
  • 1
    Welcome to StackOverflow. `Lac` and `Crore` are figures used only in India - it will be helpful if you used thousands, millions or billions for number of records so that larger audience can related with your question. – Wand Maker Nov 12 '15 at 06:09
  • Also some logs would be useful. Do you have the same problem with the Map Reduce execution engine? – Ben Watson Nov 12 '15 at 08:20
  • a possible duplicate of http://stackoverflow.com/questions/31340218/hive-like-operator – madhu Nov 12 '15 at 08:23
  • yes i have tried that solution but it did not work for me.. – Shiva Prasad G Nov 24 '15 at 06:57

0 Answers0