jadami10 opened a new issue, #16022:
URL: https://github.com/apache/pinot/issues/16022
We have a query like below
```
SELECT
ARRAYTOSTRING(
ARRAY [
CONCAT('key_1:', json_extract_scalar(my_json, '$.key1', 'STRING',
'')),
CONCAT('key_2:', json_extract_scalar(my_json, '$.key2', 'STRING', ''))
],
','
)
FROM table
```
under the hood, this fails because `ArrayLiteralTransformFunction only takes
literals as arguments`. The issue is
- `ARRAYTOSTRING` only allows literal values
- `CONCAT` only allows 2 strings
So there is no way to actually support something like this without a bunch
of nested `CONCAT` statements. I haven't worked too deeply in this part of the
code before. Does it make more sense to
- support non-literal values for `ARRAY` (is this feasible?)
- add more iterations of `CONCAT` for more string options
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
