issue_comments

Table actions

2 rows where author_association = "NONE" and user = 11022336 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

  • skorper · 2 ✖

author_association 1

  • NONE · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1290989864 https://github.com/pydata/xarray/issues/7210#issuecomment-1290989864 https://api.github.com/repos/pydata/xarray/issues/7210 IC_kwDOAMm_X85M8vEo skorper 11022336 2022-10-25T18:41:19Z 2022-10-25T18:41:19Z NONE

After further investigation, this issue seems to arise if any if the values in the time variable are masked, not just the first and last values.

It looks like cftime doesn't support nans, which is why this error is occuring.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Unable to convert times to datetime when first and last value are masked 1421718311
822142644 https://github.com/pydata/xarray/issues/5175#issuecomment-822142644 https://api.github.com/repos/pydata/xarray/issues/5175 MDEyOklzc3VlQ29tbWVudDgyMjE0MjY0NA== skorper 11022336 2021-04-19T03:34:38Z 2021-04-19T03:34:38Z NONE

Thanks @kmuehlbauer! That works great for now. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Feature to retrieve the underlying store 860180906

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]);