Re: [Pytables-users] Indexed & .createIndex() runtime

[kevin l. <lke...@ya...>]

--- Francesc Altet <fa...@ca...> wrote:

> Hi Kevin,
> 
> Can you provide more info? An excerpt of your
> indexation code, pytables
> version, hdf5 version...
> 
> Cheers,
> 
> A Dimecres 12 Gener 2005 09:18, kevin lester va
> escriure:
> > Hi Fransesc,
> > 
> > I'm not able to index my tables.cols either
> > declaritively or after. I am incurring a runtime
> > error:  
> > 
> > File "hdf5Extension.pyx", line 1831, in
> > hdf5Extension.Table._read_field_name
> > RuntimeError: Problems reading table column.
> > 
> > My table.nrows are +-150,000 and (fyi) am
> attempting
> > this on WinXP w/1G ram. 
> > 
> > Do you have any suggestions? 
> > 
> > Thank you very much,
> > Kevin
> > 
> > 
> > 		
> > __________________________________ 
> > Do you Yahoo!? 
> > Yahoo! Mail - now with 250MB free storage. Learn
> more.
> > http://info.mail.yahoo.com/mail_250
> > 
> > 
> >
>
I'm having problems with the zlib,lzo,ucl compression
libraries being available to pyTables. I planted the
.dlls in the /WINDOWS/SYSTEM folder and have
PYTHONPATH directed there as mentioned in the
installation instructions.
I included the code below for the declaritve. The
.createIndex() version was just as was shown in 6.22
of the tutorial 

>>> indexrows = table.cols.var1.createIndex() <<<

I'm using pyTables 0.9.1 and HDF5 patched version you
provided the link for in a previous Q from me.

ftp://ftp.ncsa.uiuc.edu/HDF/HDF5/current/patches/bin/WinXP-patch.tar.gz

Thank you Francesc,
Kevin
########################################################

import es01_04_05 as es
from tables import *
from numarray import *
dat = es.dat

date = 'd01_04_05'
idxdate = 'd050104'
length = (len(dat))+20

class ES(IsDescription):
    H       = Int8Col(indexed=1)
    M       = Int8Col(indexed=1)
    S       = Int8Col(indexed=1)
    BS      = Int16Col(indexed=1)
    BP      = Float32Col(indexed=1)
    AP      = Float32Col(indexed=1)
    AS      = Int16Col(indexed=1)
    L       = Float32Col(indexed=1)
    V       = Int16Col(indexed=1)
    A       = Int8Col(indexed=1)
    UD      = BoolCol(indexed=1)
    TV      = Int64Col(indexed=1)
    DT      = Float32Col(indexed=1)
    HI      = Float32Col(indexed=1)
    LO      = Float32Col(indexed=1)
    
file  =
openFile("/MY_SCRIPTS/DataFiles/ES_DATA.h5",mode="w",title="ES_DATA_FILE")
root  = file.root

group1   = file.createGroup("/",'d050104','d01_04_05')
table1 = file.createTable(group1,'raw',ES,"RAW",
expectedrows=length)

# ATTRIBUTES---------
g1  = file.root.d050104
g1._v_attrs.date      = date
g1._v_attrs.idxdate   = idxdate

t1  = file.root.d050104.raw
t1.attrs.date      = date
t1.attrs.idxdate   = idxdate

eS = table1.row

for i in xrange(len(dat)):
    eS['H']     = dat[i][13]
    eS['M']     = dat[i][14]
    eS['S']     = int(dat[i][15])
    eS['BS']    = dat[i][0]
    eS['BP']    = dat[i][1]
    eS['AP']    = dat[i][2]
    eS['AS']    = dat[i][3]
    eS['L']     = dat[i][4]
    eS['V']     = dat[i][5]
    eS['UD']    = dat[i][12]    
    eS['A']     = dat[i][11]
    eS['TV']    = dat[i][8]
    eS['DT']    = dat[i][16]
    eS['HI']    = dat[i][6]
    eS['LO']    = dat[i][7]
    eS.append()
table1.flush()
  
file.close()

-------------------------------------------------------
> > The SF.Net email is sponsored by: Beat the
> post-holiday blues
> > Get a FREE limited edition SourceForge.net t-shirt
> from ThinkGeek.
> > It's fun and FREE -- well,
> almost....http://www.thinkgeek.com/sfshirt
> > _______________________________________________
> > Pytables-users mailing list
> > Pyt...@li...
> >
>
https://lists.sourceforge.net/lists/listinfo/pytables-users
> > 
> 
> -- 
> Francesc Altet     >qo<   http://www.carabos.com/
> Cárabos Coop. V.   V  V   Enjoy Data
>                     ""
> 
> 



		
__________________________________ 
Do you Yahoo!? 
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com