#metabrainz

/

      • suvid[m]
        Oh yea I'll check for that as well
      • Thanks for reminding
      • Though it should be responsive by default but I'll still check for it
      • Hi lucifer monkey
      • I have updated the PR with the screenshots on desktop and mobile view as well
      • I had one more query
      • I created the branch `importer-UI` from the branch `main-importer` but I had created the PR #3317 that merges to main instead of `main-importer`
      • Now when I go to edit option in the PR, I don't see the option to set `main-importer` as the branch it merges to from the list of branches
      • suvid[m] uploaded an image: (87KiB) < https://matrix.chatbrainz.org/_matrix/media/v3/download/matrix.org/WCMdvOpHQRwzqscYTDMRjYUN/image.png >
      • lucifer[m]
        suvid: yes you can't do that because `main-importer` is a branch on your github fork not the metabrainz repo.
      • suvid[m]
        lucifer[m]: oh
      • sol first `main-importer` will have to be merged to main and then only `importer-UI` would be merged right?
      • lucifer[m]
        yes.
      • holycow23[m] has quit
      • holycow23[m] joined the channel
      • holycow23[m]
        Hey lucifer is the entire DB present on wolf?
      • lucifer[m]
        MB or LB?
      • holycow23[m]
        MB
      • lucifer[m]
        yup it us
      • * yup it is
      • holycow23[m] sent a code block: https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/CPEJqgOKURPdafYrYraIWXUH
      • holycow23[m]
      • * ```>>> spark.sql("select count(*) from listens l, recording_artist ra where l.recording_mbid = ra.recording_mbid").show()... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/...>)
      • Shouldn't the 2 be equal?
      • lucifer[m]
        no, because in this query filter for listens which have a matching recording mbid in recording artist table. that filters out listens which don't have a recording mbid.
      • holycow23[m]
        yeah but shouldn't all the listens have a mbid?
      • i mean if not all atleast like the most of it
      • right now roughly 10% of the listens have a matching mbid
      • lucifer[m]
        no, all listens have a msid but not all listens have a mbid.
      • ah that is probably because your spark wolf setup only has the sample dumps.
      • again, MB db on wolf is not the same as your spark setup on wolf.
      • MB db has the full dataset, your spark setup only sample.
      • holycow23[m]
        so the discrepancy is fine right
      • lucifer[m]
        yes
      • holycow23[m]
        is there a possibility to get the entire db or like some more content cause the results are too small to test and verify