issue_comments

Table actions

1 row where issue = 1421718311 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 · 1 ✖

issue 1

  • Unable to convert times to datetime when first and last value are masked · 1 ✖

author_association 1

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

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