issue_comments

Table actions

2 rows where author_association = "MEMBER", issue = 315381649 and user = 2443309 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

user 1

  • jhamman · 2 ✖

issue 1

  • open_mfdataset can't handle many files · 2 ✖

author_association 1

  • MEMBER · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
382639942 https://github.com/pydata/xarray/issues/2066#issuecomment-382639942 https://api.github.com/repos/pydata/xarray/issues/2066 MDEyOklzc3VlQ29tbWVudDM4MjYzOTk0Mg== jhamman 2443309 2018-04-19T07:35:42Z 2018-04-19T07:35:42Z MEMBER

I'm fine with the solution of a better error message but it may end up being easier said than done. IIRC, there are some OS specific behaviors here and I'm not sure if you'll always get an OSError that so plainly says: Too many open files. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   open_mfdataset can't handle many files 315381649
382319672 https://github.com/pydata/xarray/issues/2066#issuecomment-382319672 https://api.github.com/repos/pydata/xarray/issues/2066 MDEyOklzc3VlQ29tbWVudDM4MjMxOTY3Mg== jhamman 2443309 2018-04-18T09:11:13Z 2018-04-18T09:11:13Z MEMBER

@pgierz - this use case motivated the development of the autoclose feature. Can you give that a try?

Python ensemble = xr.open_mfdataset("/scratch/.../*nc, autoclose=True)

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   open_mfdataset can't handle many files 315381649

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);