Is there anyway to pass a Lookup function to TIME FORMAT som Apache Druid #general

Is there anyway to pass a Lookup function to TIME_...

Rishi Rana

01/10/2023, 7:50 PM

Is there anyway to pass a Lookup function to TIME_FORMAT, something like below. gives error

java.lang.AssertionError: not a literal: LOOKUP(CONCAT($81, &apos;&apos;), &apos;TestTimeZone&apos;)

does that mean we can not pass a function

Copy code

SELECT
  TIME_FORMAT(__time,'YYYY_MM_dd', LOOKUP(CONCAT(somecolumname,''), 'TestTimeZone')),
  column2
FROM sometable