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 2021/04/06 19:25:52 UTC
[GitHub] [druid] Imran2687 opened a new issue #11072: Query regarding ingestion rules
Imran2687 opened a new issue #11072:
URL: https://github.com/apache/druid/issues/11072
### Affected Version
The Druid version where the problem was encountered.
Druid-0.20.1
### Description
Hi,
I am trying to use Druid . I have one question. Suppose there are fields as below
Amount userName transactionId
Now i want to ingest data based on sum of amount group by user, but i want store all transaction id as well like . T1,T2,T3... after aggregation. Is it possible to do it in druid?
--
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] FrankChen021 commented on issue #11072: Query regarding ingestion rules
Posted by GitBox <gi...@apache.org>.
FrankChen021 commented on issue #11072:
URL: https://github.com/apache/druid/issues/11072#issuecomment-815416910
@Imran2687 what's your motivation that the transaction ids should be combined together for one user?
--
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] suneet-s commented on issue #11072: Query regarding ingestion rules
Posted by GitBox <gi...@apache.org>.
suneet-s commented on issue #11072:
URL: https://github.com/apache/druid/issues/11072#issuecomment-814997872
This would be a nice feature request - to be able to aggregate a string dimension by combining them. I don't believe Druid has this functionality today on either ingestion or query 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.
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] Imran2687 commented on issue #11072: Query regarding ingestion rules
Posted by GitBox <gi...@apache.org>.
Imran2687 commented on issue #11072:
URL: https://github.com/apache/druid/issues/11072#issuecomment-815486906
@FrankChen021 : Suppose there are use case where you compute profit and loss of the user. So what i do is i calculate sum of all credits and sum of all debits and find profit and loss. Using rollup it becomes easier we just rollup on the basis of dimension username and transaction Type(credit/debit) , metrics is sum of amount and it works. but doing this we should not consider transaction id as its unique and if we consider it it will be not rolled up. But suppose if we find that the profit and loss is not correct and if we have feature like this to store transaction id(as a concat string or arrays) we can look upon it and calculate easily.This can help us to check correctness.
--
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] FrankChen021 commented on issue #11072: Query regarding ingestion rules
Posted by GitBox <gi...@apache.org>.
FrankChen021 commented on issue #11072:
URL: https://github.com/apache/druid/issues/11072#issuecomment-814994076
If you want to keep transaction id, rollup should be disabled during ingestion. And sum of amount could be got by SQL as
```
SELECT SUM(Amount), userName FROM you_data_source GROUP BY userName
```
--
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] Imran2687 commented on issue #11072: Query regarding ingestion rules
Posted by GitBox <gi...@apache.org>.
Imran2687 commented on issue #11072:
URL: https://github.com/apache/druid/issues/11072#issuecomment-815099421
Thanks @FrankChen021 and @suneet-s , I was going through some query related to this. I believe this feature is still not implemented. @FrankChen021 yes whatever you said i could have done that, i wanted to explore if druid provide such option it can be used by us.
--
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