[GitHub] [druid] gianm commented on issue #13019: Query planning fails for metadata query with ARRAY_AGG

[GitBox <gi...@apache.org>]

gianm commented on issue #13019:
URL: https://github.com/apache/druid/issues/13019#issuecomment-1238873533

   Ah, yeah. That's because system tables (`sys` and `INFORMATION_SCHEMA`) run using Calcite's interpreter, not the Druid query engine, so Druid-specific SQL extensions doesn't work on them. That includes not just `ARRAY_AGG`, but also most `TIME_*` functions, sketch functions, etc.
   
   We'll want to fix this at some point by making system table queries run through Druid's regular query engine. Perhaps this means expressing them as `inline` datasources, or perhaps it means creating new datasource types that correspond to these system tables.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org