giahy2507/AptMQL-Bench
AptMQL-Bench 📄 Paper: AptMQL-Bench: From Text-to-SQL to Text-to-MQL via Access-Pattern Schema Design and Data-Preserving Migration · arXiv: coming soon AptMQL-Bench is a benchmark for text-to-MQL — the task of translating human-readable requests into executable MongoDB Query Language (MQL) aggregation pipelines. It contains 21 document-oriented databases, 3,181 natural-language requests, and their associated gold MQL queries. Most existing text-to-MQL resources are… See the full description on the dataset page: https://huggingface.co/datasets/giahy2507/AptMQL-Bench.
044
1{"field_name": "_id", "field_description": "The unique identifier for the post", "data_type": "String", "required": true, "value_description": ""}2{"field_name": "acceptedAnswerId", "field_description": "The ID of the accepted answer for this post", "data_type": "String", "required": true, "value_description": ""}3{"field_name": "answerCount", "field_description": "The total number of answers for this post (only for questions)", "data_type": "Number", "required": true, "value_description": ""}4{"field_name": "body", "field_description": "The body content of the post", "data_type": "String", "required": true, "value_description": ""}5{"field_name": "closedDate", "field_description": "The date when the post was closed", "data_type": "Date", "required": true, "value_description": "if ClosedDate is null or empty, it means this post is not well-finished; if CloseDate is not null or empty, it means this post has well-finished."}6{"field_name": "commentCount", "field_description": "The total number of comments on this post", "data_type": "Number", "required": true, "value_description": ""}7{"field_name": "communityOwnedDate", "field_description": "The date when the post became community owned", "data_type": "Date", "required": true, "value_description": ""}8{"field_name": "creationDate", "field_description": "The creation date of the post", "data_type": "Date", "required": true, "value_description": ""}9{"field_name": "favoriteCount", "field_description": "The total number of times this post has been favorited", "data_type": "Number", "required": true, "value_description": "more favorite count refers to more valuable posts."}10{"field_name": "featuredComments", "field_description": "Array of top 5 comments for this post, sorted by score and creation date", "data_type": "Array", "required": true, "value_description": ""}11{"field_name": "featuredComments.commentId", "field_description": "The unique identifier of the featured comment", "data_type": "String", "required": false, "value_description": ""}12{"field_name": "featuredComments.creationDate", "field_description": "The creation date of the featured comment", "data_type": "Date", "required": false, "value_description": ""}13{"field_name": "featuredComments.score", "field_description": "The rating score of the featured comment", "data_type": "Number", "required": false, "value_description": "The score is from 0 to 100. The score more than 60 refers that the comment is a positive comment. The score less than 60 refers that the comment is a negative comment."}14{"field_name": "featuredComments.text", "field_description": "The detailed content of the featured comment", "data_type": "String", "required": false, "value_description": ""}15{"field_name": "featuredComments.userDisplayName", "field_description": "The display name of the user who posted the featured comment", "data_type": "String", "required": false, "value_description": ""}16{"field_name": "featuredComments.userId", "field_description": "The ID of the user who posted the featured comment", "data_type": "String", "required": false, "value_description": ""}17{"field_name": "lastActivityDate", "field_description": "The date of the last activity on this post", "data_type": "Date", "required": true, "value_description": ""}18{"field_name": "lastEditDate", "field_description": "The date when the post was last edited", "data_type": "Date", "required": true, "value_description": ""}19{"field_name": "lastEditorDisplayName", "field_description": "The display name of the user who last edited this post", "data_type": "String", "required": true, "value_description": ""}20{"field_name": "lastEditorUserId", "field_description": "The ID of the user who last edited this post", "data_type": "String", "required": true, "value_description": ""}21{"field_name": "originalScore", "field_description": "The original score value from the posts table before vote computation", "data_type": "Number", "required": true, "value_description": ""}22{"field_name": "ownerDisplayName", "field_description": "The display name of the post owner", "data_type": "String", "required": true, "value_description": ""}23{"field_name": "ownerUserId", "field_description": "The ID of the post owner", "data_type": "String", "required": true, "value_description": ""}24{"field_name": "parentId", "field_description": "The ID of the parent post (for answers and child posts)", "data_type": "String", "required": true, "value_description": "If the parent id is null, the post is the root post. Otherwise, the post is the child post of other post."}25{"field_name": "postTypeId", "field_description": "The ID indicating the type of post", "data_type": "Number", "required": true, "value_description": ""}26{"field_name": "score", "field_description": "The computed score based on weighted votes from the votes table", "data_type": "Number", "required": true, "value_description": ""}27{"field_name": "tags", "field_description": "Array of tags associated with this post", "data_type": "Array", "required": true, "value_description": ""}28{"field_name": "title", "field_description": "The title of the post", "data_type": "String", "required": true, "value_description": ""}29{"field_name": "viewCount", "field_description": "The number of times this post has been viewed", "data_type": "Number", "required": true, "value_description": "Higher view count means the post has higher popularity"}30