queries.txt 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. # Licensed to Cloudera, Inc. under one
  2. # or more contributor license agreements. See the NOTICE file
  3. # distributed with this work for additional information
  4. # regarding copyright ownership. Cloudera, Inc. licenses this file
  5. # to you under the Apache License, Version 2.0 (the
  6. # "License"); you may not use this file except in compliance
  7. # with the License. You may obtain a copy of the License at
  8. #
  9. # http://www.apache.org/licenses/LICENSE-2.0
  10. #
  11. # Unless required by applicable law or agreed to in writing, software
  12. # distributed under the License is distributed on an "AS IS" BASIS,
  13. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. # See the License for the specific language governing permissions and
  15. # limitations under the License.
  16. fetchone|SELECT COUNT(*) FROM "AUTH_USER"
  17. fetchone|SELECT COUNT(*) FROM "USERADMIN_USERPROFILE" WHERE "USERADMIN_USERPROFILE"."LAST_ACTIVITY" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss')
  18. fetchone|SELECT COUNT(*) FROM "AUTH_USER"
  19. fetchone|SELECT COUNT(*) FROM "USERADMIN_USERPROFILE" WHERE "USERADMIN_USERPROFILE"."LAST_ACTIVITY" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss')
  20. fetchone|SELECT COUNT(*) FROM "AUTH_USER"
  21. fetchone|SELECT COUNT(*) FROM "USERADMIN_USERPROFILE" WHERE "USERADMIN_USERPROFILE"."LAST_ACTIVITY" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss')
  22. fetchone|SELECT COUNT(*) FROM "AUTH_USER"
  23. fetchone|SELECT COUNT(*) FROM "USERADMIN_USERPROFILE" WHERE "USERADMIN_USERPROFILE"."LAST_ACTIVITY" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss')
  24. fetchmany|SELECT "AXES_ACCESSATTEMPT"."ID", "AXES_ACCESSATTEMPT"."USER_AGENT", "AXES_ACCESSATTEMPT"."IP_ADDRESS", "AXES_ACCESSATTEMPT"."USERNAME", "AXES_ACCESSATTEMPT"."TRUSTED", "AXES_ACCESSATTEMPT"."HTTP_ACCEPT", "AXES_ACCESSATTEMPT"."PATH_INFO", "AXES_ACCESSATTEMPT"."ATTEMPT_TIME", "AXES_ACCESSATTEMPT"."GET_DATA", "AXES_ACCESSATTEMPT"."POST_DATA", "AXES_ACCESSATTEMPT"."FAILURES_SINCE_START" FROM "AXES_ACCESSATTEMPT" WHERE ("AXES_ACCESSATTEMPT"."USERNAME" IS NULL AND "AXES_ACCESSATTEMPT"."IP_ADDRESS" = '172.18.18.72' AND "AXES_ACCESSATTEMPT"."TRUSTED" = 1 ) ORDER BY "AXES_ACCESSATTEMPT"."ATTEMPT_TIME" DESC
  25. fetchmany|SELECT "AUTH_USER"."ID", "AUTH_USER"."PASSWORD", "AUTH_USER"."LAST_LOGIN", "AUTH_USER"."IS_SUPERUSER", "AUTH_USER"."USERNAME", "AUTH_USER"."FIRST_NAME", "AUTH_USER"."LAST_NAME", "AUTH_USER"."EMAIL", "AUTH_USER"."IS_STAFF", "AUTH_USER"."IS_ACTIVE", "AUTH_USER"."DATE_JOINED" FROM "AUTH_USER" WHERE "AUTH_USER"."USERNAME" IS NULL
  26. fetchmany|SELECT "AXES_ACCESSATTEMPT"."ID", "AXES_ACCESSATTEMPT"."USER_AGENT", "AXES_ACCESSATTEMPT"."IP_ADDRESS", "AXES_ACCESSATTEMPT"."USERNAME", "AXES_ACCESSATTEMPT"."TRUSTED", "AXES_ACCESSATTEMPT"."HTTP_ACCEPT", "AXES_ACCESSATTEMPT"."PATH_INFO", "AXES_ACCESSATTEMPT"."ATTEMPT_TIME", "AXES_ACCESSATTEMPT"."GET_DATA", "AXES_ACCESSATTEMPT"."POST_DATA", "AXES_ACCESSATTEMPT"."FAILURES_SINCE_START" FROM "AXES_ACCESSATTEMPT" WHERE ("AXES_ACCESSATTEMPT"."IP_ADDRESS" = '172.18.18.72' AND "AXES_ACCESSATTEMPT"."TRUSTED" = 0 ) ORDER BY "AXES_ACCESSATTEMPT"."ATTEMPT_TIME" DESC
  27. fetchone|SELECT COUNT(*) FROM "AUTH_USER"
  28. fetchmany|SELECT "DESKTOP_SETTINGS"."ID", "DESKTOP_SETTINGS"."COLLECT_USAGE", "DESKTOP_SETTINGS"."TOURS_AND_TUTORIALS" FROM "DESKTOP_SETTINGS" WHERE "DESKTOP_SETTINGS"."ID" = 1
  29. fetchmany|SELECT "DESKTOP_SETTINGS"."ID", "DESKTOP_SETTINGS"."COLLECT_USAGE", "DESKTOP_SETTINGS"."TOURS_AND_TUTORIALS" FROM "DESKTOP_SETTINGS" WHERE "DESKTOP_SETTINGS"."ID" = 1
  30. fetchone|SELECT * FROM (SELECT ROWNUM AS "_RN", "_SUB".* FROM (SELECT (1) AS "A" FROM "DJANGO_SESSION" WHERE "DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' ) "_SUB" WHERE ROWNUM <= 1) WHERE "_RN" > 0
  31. none|UPDATE "DJANGO_SESSION" SET "SESSION_DATA" = 'Y2VjOWIyZDE2NjBkN2Y3NjVhN2Q2YmNiZTU2ZWY5M2ZmODUxZDNlNjp7InRlc3Rjb29raWUiOiJ3b3JrZWQifQ==', "EXPIRE_DATE" = to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') WHERE "DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la'
  32. none|INSERT INTO "DJANGO_SESSION" ("SESSION_KEY", "SESSION_DATA", "EXPIRE_DATE") SELECT 'piuyi8amnknxlzk3k6zp4k50seov07la', 'Y2VjOWIyZDE2NjBkN2Y3NjVhN2Q2YmNiZTU2ZWY5M2ZmODUxZDNlNjp7InRlc3Rjb29raWUiOiJ3b3JrZWQifQ==', to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') FROM DUAL
  33. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  34. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  35. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  36. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  37. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  38. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  39. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  40. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  41. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  42. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  43. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  44. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  45. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  46. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  47. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  48. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  49. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  50. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  51. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  52. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  53. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  54. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  55. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  56. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  57. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  58. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  59. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  60. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  61. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  62. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  63. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  64. fetchmany|SELECT "DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", "DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION" WHERE ("DJANGO_SESSION"."SESSION_KEY" = 'piuyi8amnknxlzk3k6zp4k50seov07la' AND "DJANGO_SESSION"."EXPIRE_DATE" > to_date('2016/Nov/18 05:31:42', 'yyyy/mon/dd hh24:mi:ss') )
  65. fetchmany|SELECT * FROM AUTH_USER