Hello Everyone!   On Hive 1.1.0 the following query executes for one hour & the table has nearly 2 billion records.   select C1, C2, C3, C4, from <tablename> where NOT ( instr(FileName,'<sometext>')> 0 or instr(FileName,'<sometext>')> 0 or instr(FileName,'<sometext>')>0 or FileName='' ) and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' and FILENAME not like '%<sometext>%' ..........;     Kindly suggest some better ways to optimise the above query.   Thanks In Advance, Janani     ... View more