You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2020/08/06 09:36:46 UTC
[GitHub] [druid] phakudi opened a new issue #10246: Cannot use virtual columns in groupby dimensions
phakudi opened a new issue #10246:
URL: https://github.com/apache/druid/issues/10246
Hi There,
We are trying to use virtual columns for grouping by. And it does not work.
```
{
"queryType": "groupBy",
"dataSource": "trace_info",
"granularity": "none",
"virtualColumns": [
{
"type": "expression",
"name": "tenant",
"expression": "replace(array_offset(tags, array_offset_of(tagNames, 'tenant')), 'tenant:', '')"
},
{
"type": "expression",
"name": "rc",
"expression": "replace(array_offset(tags, array_offset_of(tagNames, 'row_count')), 'row_count:', '')"
}
],
"dimensions": [
"tenant"
],
"aggregations": [
{
"type": "longSum",
"name": "trc",
"fieldName": "rc"
}
],
"intervals": [
"2020-08-04T10:00:00.000/2020-08-04T11:00:00.000"
]
}
```
----------------------------------------------------------------
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.
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] dylwylie commented on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
dylwylie commented on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-696074745
great newss - thanks for the update @phakudi
----------------------------------------------------------------
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.
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] dylwylie closed issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
dylwylie closed issue #10246:
URL: https://github.com/apache/druid/issues/10246
----------------------------------------------------------------
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.
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] phakudi commented on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
phakudi commented on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-669824440
The documentation is not awfully clear.on how to use virtual columns as group by dimensions. I could be wrong here too. Please help.
Thanks!
Phani
----------------------------------------------------------------
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.
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] dylwylie commented on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
dylwylie commented on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-669890933
No issues stand out in your query apart from there's no specified outputType so the default will be float.
Could you elaborate on what's not working? What response do you get? Do you've any corresponding log messages on the historical or broker nodes?
----------------------------------------------------------------
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.
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] phakudi commented on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
phakudi commented on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-695947300
Hi @dylwylie thanks for your response. Yes. I fixed the outputType and it started working. You can close this issue.
----------------------------------------------------------------
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.
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] phakudi edited a comment on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
phakudi edited a comment on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-669824440
The documentation is not very clear.on how to use virtual columns as group by dimensions. I could be wrong here too. Please help.
Thanks!
Phani
----------------------------------------------------------------
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.
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] dylwylie closed issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
dylwylie closed issue #10246:
URL: https://github.com/apache/druid/issues/10246
----------------------------------------------------------------
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.
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] dylwylie edited a comment on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
dylwylie edited a comment on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-696074745
great news - thanks for the update @phakudi
----------------------------------------------------------------
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.
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] dylwylie commented on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
dylwylie commented on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-696074745
great newss - thanks for the update @phakudi
----------------------------------------------------------------
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.
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] phakudi commented on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
phakudi commented on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-695947300
Hi @dylwylie thanks for your response. Yes. I fixed the outputType and it started working. You can close this issue.
----------------------------------------------------------------
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.
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] dylwylie edited a comment on issue #10246: Cannot use virtual columns in groupby dimensions
Posted by GitBox <gi...@apache.org>.
dylwylie edited a comment on issue #10246:
URL: https://github.com/apache/druid/issues/10246#issuecomment-696074745
great news - thanks for the update @phakudi
----------------------------------------------------------------
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.
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