Re: [Pytables-users] AssertionError while attempting a query on indexed column

[Thadeus B. <tha...@th...>]

Looks similar to https://github.com/PyTables/PyTables/issues/206

--
Thadeus



On Fri, Mar 15, 2013 at 6:58 PM, Dmitry Fedorov <fe...@ec...>wrote:

> Hi,
>
> I'm trying to index a simple uint32 column and search if a value is
> there. Although during the in-kernel query i get an error like this:
>
> Traceback (most recent call last):
>   File "G:\_2\PytablesTestCode\pytableindex.py", line 9, in <module>
>     r = [ row.nrow for row in it ]
>   File "tableExtension.pyx", line 858, in
> tables.tableExtension.Row.__next__ (tables\tableExtension.c:7788)
>   File "tableExtension.pyx", line 879, in
> tables.tableExtension.Row.__next__indexed
> (tables\tableExtension.c:7922)
> AssertionError
>
> The second time I perform the same query I get no errors but also I
> got no results...
>
> I get this on python 2.7, pytables 2.4.0 and 2.3.1 under windows 64 (7
> and 8). I'm using pytables distro from
> <http://www.lfd.uci.edu/~gohlke/pythonlibs/#pytables>
>
> I'm sure I've had code like this running just fine on older pytables
> 2.2.X (with pro) and older python...
>
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<
> Here's table creation code:
>
> import tables
> import numpy as np
> import random
>
> #initalizes column types
> class Columns(tables.IsDescription):
>             imageid   = tables.UInt32Col(pos=1)
>             feature   = tables.Float64Col(pos=2, shape=(30,))
>
> #creates Table
> h5file=tables.openFile('features.h5','a', title='features')
> table = h5file.createTable('/', 'values', Columns, expectedrows=1000000000)
> table.flush()
>
> Columns = table.row
>
> #appends values to table
> for i in xrange(100):
>     Columns['imageid'] = i
>     Columns['feature'] = [np.random.random_sample((30,))]
>     Columns.append()
>
> table.flush()
>
> table.cols.imageid.createCSIndex()
> h5file.close()
>
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<
> Here's table query code:
>
> import time
> import tables
>
> #opens tables
> h5file=tables.openFile('features.h5','a')
> table=h5file.root.values
>
> it = table.where('imageid == 8')
> r = [ row.nrow for row in it ]
>
> print r
>
> -----
> Thank you,
> Dmitry
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Pytables-users mailing list
> Pyt...@li...
> https://lists.sourceforge.net/lists/listinfo/pytables-users
>