issue_comments

Table actions

1 row where author_association = "CONTRIBUTOR", issue = 906175200 and user = 20629530 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

  • aulemahal · 1 ✖

issue 1

  • `dt.to_pytimedelta` to allow arithmetic with cftime objects · 1 ✖

author_association 1

  • CONTRIBUTOR · 1 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
853900455 https://github.com/pydata/xarray/pull/5402#issuecomment-853900455 https://api.github.com/repos/pydata/xarray/issues/5402 MDEyOklzc3VlQ29tbWVudDg1MzkwMDQ1NQ== aulemahal 20629530 2021-06-03T14:11:16Z 2021-06-03T14:11:16Z CONTRIBUTOR

Agreed that this is limited and there's need for a more general solution!

However, this problem is quite tricky... The best I see is what I think you suggested in the other thread : special workaround with re-casting when the operation involves "<m8[ns]" and "O" (and that the "O" is cftime datetimes). That clears the instability problem of my solution. It loads a value, so dask-compat is not optimal, but that's already what dt does.

The encoding problem remains, but I made some tests and I realized numpy automatically casts timedeltas to the smallest unit, but accepts operations between timedeltas of different units. Could we accept timedelta64 arrays with another units than "ns"? Then, there could be a check when converting python timedeltas : if nanosecond information exist : go with [ns], if not, go with [ms]. This bumps the limit from 292 years to 292471. And, with this relaxation of the dtype strictness, would allow a user to use even coarser frequencies if need be.

Throwing ideas. There might be other issues that I did not see!

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   `dt.to_pytimedelta` to allow arithmetic with cftime objects 906175200

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