Repository navigation
SQL JSON_OBJECT() function results in RUNTIME_FAILURE when querying INFORMATION_SCHEMA.COLUMNS #16356
Closed as not planned
Description
Affected Version
Druid 29.0.1
Description
Running the following query
select JSON_OBJECT('name': COLUMN_NAME, 'type': DATA_TYPE)
from INFORMATION_SCHEMA.COLUMNS
produces
Error: RUNTIME_FAILURE (OPERATOR)
cannot translate call json_object($t17, $t18, $t3, $t19, $t7)
java.lang.RuntimeException
Note that the error message quotes the json_object call to receive five parameters, but maybe that's an unrelated internal detail.
For comparison, the following works (but is useless):
select JSON_OBJECT('name': 'foo', 'type': 'VARCHAR')
Activity
github-actions commentedon Feb 5, 2025
This issue has been marked as stale due to 280 days of inactivity.
It will be closed in 4 weeks if no further activity occurs. If this issue is still
relevant, please simply write any comment. Even if closed, you can still revive the
issue at any time or discuss it on the dev@druid.apache.org list.
Thank you for your contributions.
github-actions commentedon Mar 5, 2025
This issue has been closed due to lack of activity. If you think that
is incorrect, or the issue requires additional review, you can revive the issue at
any time.