Guest User

Untitled

a guest
Apr 19th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. CREATE TEMPORARY FUNCTION get_max_salary(
  2. dept STRING,
  3. limit_val int64
  4. ) AS (
  5. (
  6. select max(salary)
  7. from `temp.department`
  8. where department=dept
  9. limit limit_val
  10. ));
  11.  
  12. Error: Syntax error: Expected "@" or integer literal or keyword CAST
  13. but got identifier "limit_val"; failed to parse CREATE [TEMP] FUNCTION
  14. statement at [9:7]
Add Comment
Please, Sign In to add comment