Skip to content

Instantly share code, notes, and snippets.

@minudika
Created July 21, 2019 13:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save minudika/e23394b96572d596fbfdf95c57d35202 to your computer and use it in GitHub Desktop.
Save minudika/e23394b96572d596fbfdf95c57d35202 to your computer and use it in GitHub Desktop.
from dayFilterStream
select messageId, username, ifThenElse(minLoginTime<=loginHour and loginHour<=maxLoginTime, 0.0, ifThenElse(minLoginTime-2<loginHour and loginHour<maxLoginTime+2, 0.5, 1.0)) as risk
insert into OutputStream;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment