0

I create a query variables with where condition 

set Source_record= 'select count(1), batch_id from customer 
where customer_type = 'Retail' group by batch_id’ ;

I get error message

“Syntax error, found: '=' at line 1,”

Is something wrong with where conditions?

Kaushik Nayak
  • 30,772
  • 5
  • 32
  • 45
Anson
  • 243
  • 1
  • 5
  • 20
  • 1
    hive is not the same with mysql. look at this SO post: https://stackoverflow.com/questions/23988960/storing-query-result-in-a-variable – jose_bacoy Mar 01 '18 at 15:12
  • Possible duplicate of [Storing query result in a variable](https://stackoverflow.com/questions/23988960/storing-query-result-in-a-variable) – Kaushik Nayak Mar 01 '18 at 16:12

0 Answers0