issue_comments

Table actions

2 rows where issue = 1307112340 and user = 39069044 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

  • slevang · 2 ✖

issue 1

  • `interp` performance with chunked dimensions · 2 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1188348238 https://github.com/pydata/xarray/issues/6799#issuecomment-1188348238 https://api.github.com/repos/pydata/xarray/issues/6799 IC_kwDOAMm_X85G1MFO slevang 39069044 2022-07-18T21:43:11Z 2022-07-18T21:43:11Z CONTRIBUTOR

The chunking structure on disk is pretty instrumental to my application, which requires fast retrievals of full slices in the time dimension. The loop option in my first post only takes about 10 seconds with ni=1000 which is fine for my use case, so I'll probably go with that for now. It would be interesting to dig deeper though and see if there is a way to handle this better in the interp logic.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   `interp` performance with chunked dimensions 1307112340
1187729258 https://github.com/pydata/xarray/issues/6799#issuecomment-1187729258 https://api.github.com/repos/pydata/xarray/issues/6799 IC_kwDOAMm_X85Gy09q slevang 39069044 2022-07-18T16:44:40Z 2022-07-18T16:44:40Z CONTRIBUTOR

Interpolating on chunked dimensions doesn't work at all prior to #4155. The changes in #4069 are also relevant.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   `interp` performance with chunked dimensions 1307112340

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