issue_comments

Table actions

2 rows where author_association = "MEMBER", issue = 275033174 and user = 4160723 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

  • benbovy · 2 ✖

issue 1

  • IPython auto-completion triggers data loading · 2 ✖

author_association 1

  • MEMBER · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
345411827 https://github.com/pydata/xarray/issues/1727#issuecomment-345411827 https://api.github.com/repos/pydata/xarray/issues/1727 MDEyOklzc3VlQ29tbWVudDM0NTQxMTgyNw== benbovy 4160723 2017-11-18T02:26:15Z 2017-11-18T02:26:15Z MEMBER

I've been investigating a bit, and actually in the example above the data may be loaded + duplicated!

in Dataset._item_sources (this line), the item {d: self[d] for d in self.dims} computes the DataArray, ds['x'], which has the same (huge) size than myvar.

Still don't know exactly why the data of myvar is loaded (maybe something indeed related to the use in IPython 6.x of a more advanced completion system based on jedi).

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   IPython auto-completion triggers data loading 275033174
345408160 https://github.com/pydata/xarray/issues/1727#issuecomment-345408160 https://api.github.com/repos/pydata/xarray/issues/1727 MDEyOklzc3VlQ29tbWVudDM0NTQwODE2MA== benbovy 4160723 2017-11-18T01:37:08Z 2017-11-18T01:37:08Z MEMBER

Sorry my example above was wrong. In the example below myvar is not a coordinate, but it still triggers data loading when pressing tab generally (not only trying to auto-complete myvar).

``` In [1]: import xarray as xr

In [2]: ds = xr.open_dataset('test.nc')

In [3]: ds Out[3]: <xarray.Dataset> Dimensions: (x: 1000000000) Dimensions without coordinates: x Data variables: myvar (x) float64 ...

In [4]: ds['myvar'] Out[4]: <xarray.DataArray 'myvar' (x: 1000000000)> [1000000000 values with dtype=float64] Dimensions without coordinates: x

In [5]: ds['myvar'].variable._in_memory Out[5]: False

In [6]: ds.anything # pressed [Tab] and then [Enter]

AttributeError Traceback (most recent call last) <ipython-input-6-5e7144cb0cd3> in <module>() ----> 1 ds.anything

~/GitRepos/xarray_dev/xarray/core/common.py in getattr(self, name) 174 return source[name] 175 raise AttributeError("%r object has no attribute %r" % --> 176 (type(self).name, name)) 177 178 def setattr(self, name, value):

AttributeError: 'Dataset' object has no attribute 'anything'

In [7]: ds['myvar'].variable._in_memory Out[7]: True ```

Unless I miss something obvious (it's late), this is weird.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   IPython auto-completion triggers data loading 275033174

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