How to dynamically add months in Apache drill

[Bharani Manickam]

Hello,

DATE_ADD function doesn't support a column as the interval argument in drill 
queries.

We have a requirement to pass a column as Interval Month to derive a forecasted 
date. Do you have any work around for this please?

The requirement is something like this -


Query that works
select
  a,
  DATE_ADD(date '2015-05-15', interval '1' month)
from
(
select '1' a, INSERTED_AT from dfs.data.bi_interaction limit 3
);

Query that doesn't work

select

  a,

  DATE_ADD(date '2015-05-15', interval a month)

from

(

 select '1' a, INSERTED_AT from dfs.data.bi_interaction limit 3

);



Thanks
Bharani