issue_comments

Table actions

1 row where issue = 396063731 and user = 1217238 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

  • shoyer · 1 ✖

issue 1

  • "Timestamp subtraction must have the same timezones or no timezones" when saving a NetCDF · 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
451681899 https://github.com/pydata/xarray/issues/2649#issuecomment-451681899 https://api.github.com/repos/pydata/xarray/issues/2649 MDEyOklzc3VlQ29tbWVudDQ1MTY4MTg5OQ== shoyer 1217238 2019-01-05T18:59:23Z 2019-01-05T18:59:23Z MEMBER

For reference, the issue here appears to be that the time variable's units attribute specifies a timezone: int64 time(time) ; time:standard_name = forecast_reference_time ; time:long_name = initial time of forecast ; time:units = seconds since 1970-01-01T00:00:00+00:00 ; time:calendar = proleptic_gregorian ;

And here is the relevant description from CF conventions:

The reference time string (appearing after the identifier since) may include date alone; date and time; or date, time, and time zone. ...

Note: if the time zone is omitted the default is UTC, and if both time and time zone are omitted the default is 00:00:00 UTC.

Given that xarray uses timezone agnostic np.datetime64 and cftime.datetime objects, it does seem like the best course of action here is to decode dates to UTC and then remove the timezone.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   "Timestamp subtraction must have the same timezones or no timezones" when saving a NetCDF 396063731

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