You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "phillbrown (via GitHub)" <gi...@apache.org> on 2023/03/31 14:50:32 UTC
[GitHub] [druid] phillbrown opened a new issue, #14006: Error when using string_to_mv() from a subquery
phillbrown opened a new issue, #14006:
URL: https://github.com/apache/druid/issues/14006
### Affected Version
25.0
### Description
Steps to reproduce:
1. Load the [attached](https://github.com/apache/druid/files/11123016/string-to-mv.zip) data using native batch ingestion with the [attached](https://github.com/apache/druid/files/11123016/string-to-mv.zip) spec
2. Run the following query using the SQL native engine
```
SELECT STRING_TO_MV(mvstring, ',')
FROM (
SELECT DISTINCT "parent_id", MV_TO_STRING("multi_values", ',') AS mvstring
FROM "example"
GROUP BY 1, 2
)
```
The query should return the following error:
```
Error: Unknown exception
Cannot coerce [[Ljava.lang.String;] to VARCHAR
org.apache.druid.java.util.common.ISE
```
Interestingly the query runs as expected if we use the ms query engine. I'm using the out-the-box auto configuration.
--
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.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
Re: [I] Error when using string_to_mv() from a subquery (druid)
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #14006: Error when using string_to_mv() from a subquery
URL: https://github.com/apache/druid/issues/14006
--
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
Re: [I] Error when using string_to_mv() from a subquery (druid)
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #14006:
URL: https://github.com/apache/druid/issues/14006#issuecomment-2014091089
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.
--
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
Re: [I] Error when using string_to_mv() from a subquery (druid)
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #14006:
URL: https://github.com/apache/druid/issues/14006#issuecomment-2065521270
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.
--
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
[GitHub] [druid] LakshSingla commented on issue #14006: Error when using string_to_mv() from a subquery
Posted by "LakshSingla (via GitHub)" <gi...@apache.org>.
LakshSingla commented on issue #14006:
URL: https://github.com/apache/druid/issues/14006#issuecomment-1592384201
Resolved by #14260
--
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
[GitHub] [druid] LakshSingla commented on issue #14006: Error when using string_to_mv() from a subquery
Posted by "LakshSingla (via GitHub)" <gi...@apache.org>.
LakshSingla commented on issue #14006:
URL: https://github.com/apache/druid/issues/14006#issuecomment-1591903491
Thanks for reporting the issue along with the steps to repro it. Raised a PR to solve the same.
--
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