Search code examples
sqlimpala

How to parse today's date into a parameter

I want to create a parameter with today's date in order to add it in my queries in an sql script. I tried the below:

${var:id_date} =  from_timestamp(date_trunc('second', now()),'yyyyMMdd');

But I am facing the below issue.

ParseException: Syntax error in line 1:undefined: ${var:id_date} = select from... ^ Encountered: IDENTIFIER Expected: ALTER, COMMENT, COMPUTE, COPY, CREATE, DELETE, DESCRIBE, DROP, EXPLAIN, GRANT, INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, UPDATE, UPSERT, USE, VALUES, WITH CAUSED BY: Exception: Syntax error

Solution

  • When setting variable use set var:id_date=...;

    set var:id_date=from_timestamp(date_trunc('second', now()),'yyyyMMdd');

    select * from mytable where id_date=${var:id_date};