Long Lived Bug Prediction
Predict the Bugs in FLOSS
@kaggle.saurabhshahane_long_lived_bug_prediction
Predict the Bugs in FLOSS
@kaggle.saurabhshahane_long_lived_bug_prediction
CREATE TABLE eclipse_bug_report_data (
"bug_id" VARCHAR,
"creation_date" TIMESTAMP,
"component_name" VARCHAR,
"product_name" VARCHAR,
"short_description" VARCHAR,
"long_description" VARCHAR,
"assignee_name" VARCHAR,
"reporter_name" VARCHAR,
"resolution_category" VARCHAR,
"resolution_code" BIGINT,
"status_category" VARCHAR,
"status_code" BIGINT,
"update_date" TIMESTAMP,
"quantity_of_votes" BIGINT,
"quantity_of_comments" BIGINT,
"resolution_date" TIMESTAMP,
"bug_fix_time" BIGINT,
"severity_category" VARCHAR,
"severity_code" BIGINT
);
CREATE TABLE freedesktop_bug_report_data (
"bug_id" VARCHAR,
"creation_date" TIMESTAMP,
"component_name" VARCHAR,
"product_name" VARCHAR,
"short_description" VARCHAR,
"long_description" VARCHAR,
"assignee_name" VARCHAR,
"reporter_name" VARCHAR,
"resolution_category" VARCHAR,
"resolution_code" BIGINT,
"status_category" VARCHAR,
"status_code" BIGINT,
"update_date" TIMESTAMP,
"quantity_of_votes" BIGINT,
"quantity_of_comments" BIGINT,
"resolution_date" TIMESTAMP,
"bug_fix_time" BIGINT,
"severity_category" VARCHAR,
"severity_code" BIGINT
);
CREATE TABLE gcc_bug_report_data (
"bug_id" VARCHAR,
"creation_date" TIMESTAMP,
"component_name" VARCHAR,
"product_name" VARCHAR,
"short_description" VARCHAR,
"long_description" VARCHAR,
"assignee_name" VARCHAR,
"reporter_name" VARCHAR,
"resolution_category" VARCHAR,
"resolution_code" BIGINT,
"status_category" VARCHAR,
"status_code" BIGINT,
"update_date" TIMESTAMP,
"quantity_of_votes" BIGINT,
"quantity_of_comments" BIGINT,
"resolution_date" TIMESTAMP,
"bug_fix_time" BIGINT,
"severity_category" VARCHAR,
"severity_code" BIGINT
);
CREATE TABLE gnome_bug_report_data (
"bug_id" VARCHAR,
"creation_date" TIMESTAMP,
"component_name" VARCHAR,
"product_name" VARCHAR,
"short_description" VARCHAR,
"long_description" VARCHAR,
"assignee_name" VARCHAR,
"reporter_name" VARCHAR,
"resolution_category" VARCHAR,
"resolution_code" BIGINT,
"status_category" VARCHAR,
"status_code" BIGINT,
"update_date" TIMESTAMP,
"quantity_of_votes" BIGINT,
"quantity_of_comments" BIGINT,
"resolution_date" TIMESTAMP,
"bug_fix_time" BIGINT,
"severity_category" VARCHAR,
"severity_code" BIGINT
);
CREATE TABLE mozilla_bug_report_data (
"bug_id" VARCHAR,
"creation_date" TIMESTAMP,
"component_name" VARCHAR,
"product_name" VARCHAR,
"short_description" VARCHAR,
"long_description" VARCHAR,
"assignee_name" VARCHAR,
"reporter_name" VARCHAR,
"resolution_category" VARCHAR,
"resolution_code" BIGINT,
"status_category" VARCHAR,
"status_code" BIGINT,
"update_date" TIMESTAMP,
"quantity_of_votes" BIGINT,
"quantity_of_comments" BIGINT,
"resolution_date" TIMESTAMP,
"bug_fix_time" BIGINT,
"severity_category" VARCHAR,
"severity_code" BIGINT
);
CREATE TABLE winehq_bug_report_data (
"bug_id" VARCHAR,
"creation_date" TIMESTAMP,
"component_name" VARCHAR,
"product_name" VARCHAR,
"short_description" VARCHAR,
"long_description" VARCHAR,
"assignee_name" VARCHAR,
"reporter_name" VARCHAR,
"resolution_category" VARCHAR,
"resolution_code" BIGINT,
"status_category" VARCHAR,
"status_code" BIGINT,
"update_date" TIMESTAMP,
"quantity_of_votes" BIGINT,
"quantity_of_comments" BIGINT,
"resolution_date" TIMESTAMP,
"bug_fix_time" BIGINT,
"severity_category" VARCHAR,
"severity_code" BIGINT
);
Anyone who has the link will be able to view this.