You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hello guys,
I have a problem.
I want to use
ClickHouse
for membership analysis.I create a table like this:
For example: user_id is
10124145
,lable_name isgender
, and label_value ismale
.But the question is user's label can change, user's label can be
A
at one time andB
at other time.Data is written into table in real time.
How can I change the aggregate column user_id's value in table when a user's label_name changed.
Maybe there are other solutions,can someone help me ?
Thanks!!!!!
Beta Was this translation helpful? Give feedback.
All reactions