CODEWITHSUNDEEP
sqlimpala
DrGenius
DrGenius

Reputation: 967

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

Upvotes: 1

Views: 172

Answers (1)

leftjoin
leftjoin

Reputation: 38335

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};

Upvotes: 1

Related Questions