API tools faq
paste
Guest User

Untitled

a guest
Nov 14th, 2018
140
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.46 KB | None | 0 0
raw download clone embed print report
  1. hive> select * from enterprise_enrollment;
  2. OK
  3. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 11 1 course-v1:edX+Open_DemoX+edx_demo_course2 2016-03-22 20:56:09.320098 verified 1 0 NULL harry 1 All about acceptance testing! 2016-06-01 00:00:00 2016-09-01 00:00:00 self_paced Self Paced 3 5 2015-02-12 23:14:35 test@example.com test_user edX+Open_DemoX US NULL Aviato OTTO_VER_25_PCT_OFF NULL 0.4 200.0 192.0 NULL 2016-09-08
  4. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 11 1 course-v1:edX+Testing102x+1T2017 2016-03-22 21:08:08.43287 credit 0 0 NULL harry 1 All about acceptance testing Part 3! 2016-12-01 00:00:00 2017-02-01 00:00:00 instructor_paced 9 2 5 2015-02-12 23:14:35 test@example.com test_user edX+Testing102 US 2015-09-09 Aviato OTTO_VER_25_PCT_OFF NULL 0.64 100.0 56.0 NULL 2016-09-08
  5. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 11 1 edX/Open_DemoX/edx_demo_course 2014-06-27 16:02:38 verified 1 Pass 1 2017-05-09 16:27:34.690065 harry 1 All about acceptance testing! 2016-09-01 00:00:00 2016-12-01 00:00:00 instructor_paced 13 2 4 2015-02-12 23:14:35 test@example.com test_user edX+Open_DemoX US NULL Pied Piper Discount PJS4LCU435W6KGBS NULL 0.81 300.0 156.0 NULL 2016-09-08
  6. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 12 2 course-v1:edX+Open_DemoX+edx_demo_course2 2016-03-22 20:59:12.281696 verified 1 0 NULL ron 1 All about acceptance testing! 2016-06-01 00:00:00 2016-09-01 00:00:00 self_paced Self Paced 3 5 2015-02-12 23:14:35 test2@example.com test_user2 edX+Open_DemoX US NULL ENT - Email domain restricted QAFWBFZ26GYYYIJS NULL 0.0 200.0 10.0 NULL 2016-09-08
  7. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 12 2 course-v1:edX+Testing102x+1T2017 2016-03-22 21:04:08.211237 no-id-professional 1 Pass 1 2017-05-09 16:27:33.526363 ron 1 All about acceptance testing Part 3! 2016-12-01 00:00:00 2017-02-01 00:00:00 instructor_paced 9 2 5 2015-02-12 23:14:35 test2@example.com test_user2 edX+Testing102 US 2015-09-09 ENT - Discount CQHVBDLY35WSJRZ4 NULL 0.98 100.0 60.0 NULL 2016-09-08
  8. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 15 4 course-v1:edX+Open_DemoX+edx_demo_course2 2016-03-22 20:56:09.320098 verified 1 0 NULL ginny 1 All about acceptance testing! 2016-06-01 00:00:00 2016-09-01 00:00:00 self_paced Self Paced 3 5 2015-02-12 23:14:35 test5@example.com test_user5 edX+Open_DemoX US NULL NULL NULL Absolute, 100 (#7) 0.5 200.0 20.0 NULL 2016-09-08
  9. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 15 4 course-v1:edX+Testing102x+1T2017 2016-03-22 21:08:08.43287 credit 1 0 NULL ginny 1 All about acceptance testing Part 3! 2016-12-01 00:00:00 2017-02-01 00:00:00 instructor_paced 9 2 5 2015-02-12 23:14:35 test5@example.com test_user5 edX+Testing102 US NULL NULL NULL Percentage, 100 (#8) 0.74 100.0 60.0 NULL 2016-09-08
  10. 0381d3cb033846d48a5cb1475b589d7f Enterprise 1 15 4 edX/Open_DemoX/edx_demo_course 2014-06-27 16:02:38 verified 1 Pass 1 2017-05-09 16:27:34.690065 ginny 1 All about acceptance testing! 2016-09-01 00:00:00 2016-12-01 00:00:00 instructor_paced 13 2 4 2015-02-12 23:14:35 test5@example.com test_user5 edX+Open_DemoX US NULL NULL NULL Percentage, 100 (#6) 0.85 300.0 56.0 NULL 2016-09-08
  11. 03fc6c3a33d84580842576922275ca6f 2nd Enterprise 13 3 course-v1:edX+Open_DemoX+edx_demo_course2 2016-03-22 21:02:09.195616 no-id-professional 1 0 NULL hermione 1 All about acceptance testing! 2016-06-01 00:00:00 2016-09-01 00:00:00 self_paced Self Paced 3 5 2015-02-12 23:14:35 test3@example.com test_user3 edX+Open_DemoX US 2015-09-09 ENT - No restrictions ZSJHRVLCNTT6XFCJ NULL 0.03 100.0 20.0 NULL 2016-09-08
  12.  
  13. hive> desc enterprise_enrollment;
  14. OK
  15. enterprise_id string
  16. enterprise_name string
  17. lms_user_id int
  18. enterprise_user_id int
  19. course_id string
  20. enrollment_created_timestamp timestamp
  21. user_current_enrollment_mode string
  22. consent_granted tinyint
  23. letter_grade string
  24. has_passed tinyint
  25. passed_timestamp timestamp
  26. enterprise_sso_uid string
  27. enterprise_site_id int
  28. course_title string
  29. course_start timestamp
  30. course_end timestamp
  31. course_pacing_type string
  32. course_duration_weeks string
  33. course_min_effort int
  34. course_max_effort int
  35. user_account_creation_timestamp timestamp
  36. user_email string
  37. user_username string
  38. course_key string
  39. user_country_code string
  40. last_activity_date string
  41. coupon_name string
  42. coupon_code string
  43. offer string
  44. current_grade float
  45. course_price float
  46. discount_price float
  47. unenrollment_timestamp string
  48. dt string
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!