Dataset extracted from the Jira ITS of four popular open source ecosystems i.e., the Apache Software Foundation, Spring, JBoss and CodeHaus communities.
I tried opening the data set in a few ways.
First, I used sqlite3 and tried to import the data using DB Browser for SQLite. I did not get any messages, but no data. When running the script I did however get a pop up to enter a passphrase due to encryption.
Secondly, I downloaded MySQL and MySQL Workbench. In the latter I used File > Open SQL Script. When importing the data, I get some generic error. When selecing "Run SQL script", I get a more specific error: "Error executing SQL script.
'>' not supported between instances of 'NoneType' and 'int'".
Not sure if this is something others have come across and been able to resolve?
Maybe relevant: I am on MacOS and the extract.sh script did not work for me, I had to copy and paste the one-liner in that file straight into my terminal for it to work. Maybe something went wrong in this approach?