Hive query - Join or Subquery -
i'm looking performant query. have got 2 tables:
productviews(timecol timestamp, user_id string, product_id int, location_city string)
productactions(timecol timestamp, user_id string, product_id int, location_city string, action string)
action example shopping-cart insert.
i need run query grouped location_city or product_id:
select *, count(productviews), count(productactions), count(distinct user_id) xxx group xxx
has idea?
Comments
Post a Comment