The set @ rownum=0;
Select @ rownum:=@ rownum + 1 as I, id from tablename;
In the local environment, then an error ParseException, line1:15 always recognize input near 'rownum' ':' '=' selection in target (state=42000, code=40000)
Excuse me, is a hive does not support this way, or that my statements written there is a problem,
Forget to give everyone a great god answers, hard