Home > other >  Hive whether to support the set @ rownum=0 this setting
Hive whether to support the set @ rownum=0 this setting

Time:02-25

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
  • Related