Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- hive> SELECT * FROM user_activity_by_user WHERE "2020-04-01" <= dt AND dt < "2020-04-30";
- OK
- 6716 course-v1:UAMx+CERT03+2020_T3 2020-04-02 ACTIVE 2 2020-04-02
- 46 course-v1:yo+A000+2019_T3 2020-04-03 ACTIVE 1612 2020-04-03
- 6716 course-v1:UAM+YC101+2019_YC 2020-04-14 ACTIVE 21 2020-04-14
- 24 course-v1:UAM+YC101+2019_YC 2020-04-15 ACTIVE 8 2020-04-15
- 6727 course-v1:UAM+YC101+2019_YC 2020-04-15 ACTIVE 30 2020-04-15
- 6727 course-v1:UAM+YC101+2019_YC 2020-04-15 ATTEMPTED_PROBLEM 1 2020-04-15
- 6716 course-v1:UAM+YC101+2019_YC 2020-04-15 ACTIVE 40 2020-04-15
- 6728 course-v1:UAM+YC101+2019_YC 2020-04-16 ATTEMPTED_PROBLEM 1 2020-04-16
- 6729 course-v1:UAM+YC101+2019_YC 2020-04-16 ATTEMPTED_PROBLEM 1 2020-04-16
- 6717 course-v1:UAM+YC101+2019_YC 2020-04-16 ACTIVE 3 2020-04-16
- 24 course-v1:UAM+YC101+2019_YC 2020-04-16 ACTIVE 78 2020-04-16
- 6728 course-v1:UAM+YC101+2019_YC 2020-04-16 ACTIVE 24 2020-04-16
- 6729 course-v1:UAM+YC101+2019_YC 2020-04-16 ACTIVE 47 2020-04-16
- 46 course-v1:yo+A000+2019_T3 2020-04-16 ACTIVE 139 2020-04-16
- 6716 course-v1:UAM+YC101+2019_YC 2020-04-16 ACTIVE 328 2020-04-16
- 6716 course-v1:UAMx+CERT01+2020_T1 2020-04-16 ACTIVE 20 2020-04-16
- 6727 course-v1:UAM+YC101+2019_YC 2020-04-16 ACTIVE 32 2020-04-16
- 24 course-v1:UAM+YC101+2019_YC 2020-04-16 ATTEMPTED_PROBLEM 1 2020-04-16
- 6730 course-v1:UAM+YC101+2019_YC 2020-04-17 ATTEMPTED_PROBLEM 2 2020-04-17
- 6730 course-v1:UAM+YC101+2019_YC 2020-04-17 ACTIVE 177 2020-04-17
- 4162 course-v1:UAM+YC101+2019_YC 2020-04-17 ACTIVE 20 2020-04-17
- 7 course-v1:UAM+YC101+2019_YC 2020-04-17 ATTEMPTED_PROBLEM 1 2020-04-17
- 6716 course-v1:UAMx+CERT03+2020_T3 2020-04-17 ACTIVE 2 2020-04-17
- 7 course-v1:UAM+YC101+2019_YC 2020-04-17 ACTIVE 36 2020-04-17
- 4162 course-v1:UAM+YC101+2019_YC 2020-04-17 ATTEMPTED_PROBLEM 1 2020-04-17
- 6731 course-v1:UAM+YC101+2019_YC 2020-04-17 ACTIVE 26 2020-04-17
- 6716 course-v1:UAM+YC101+2019_YC 2020-04-17 ACTIVE 6 2020-04-17
- 6731 course-v1:UAM+YC101+2019_YC 2020-04-17 ATTEMPTED_PROBLEM 2 2020-04-17
- 6716 course-v1:UAM+YC101+2019_YC 2020-04-23 ACTIVE 18 2020-04-23
- 6716 course-v1:UAM+YC101+2019_YC 2020-04-24 ACTIVE 2 2020-04-24
- 6716 course-v1:UAMx+CERT03+2020_T3 2020-04-29 ACTIVE 2 2020-04-29
- Time taken: 0.471 seconds, Fetched: 31 row(s)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement