Partition prunning using CURRENT_DATE?

[Oscar Morante]

I'm trying to trigger partition prunning like this:

   select *
   from dfs.`json/by-date`
   where dir0 = cast(current_date as varchar);



Thanks,

--
Oscar Morante
"Self-education is, I firmly believe, the only kind of education there is."
                                                         -- Isaac Asimov.

But apparently, it only works when passing a literal. Am I missing something?

signature.asc
Description: Digital signature