[Pytables-users] adding extra columns to existing table

2009-04-16 Thread Toby Mathieson
Hi all, I think I am still thinking in terms of relational databases and MySQL... but now I would like to add a column to an existing HDF5 table... I tried something like the following: h5file.setNodeAttr(group,'cancelled',Int32Col(),name='Pdata') where 'group' is a groupNode of the table I want

[Pytables-users] removing data from pytables HDF5 file

2009-04-15 Thread Toby Mathieson
Hi there, I am trying to figure out a simple way to remove data from a HDF5 when it matches certain criteria (analogous to SQL 'delete from table where = %s'. I am probably being stupid, but I cannot find a straightforward way to do this! I couldn't see anyway to do this in the tutorial, except

[Pytables-users] strange error with PyTables

2009-01-19 Thread Toby Mathieson
Hi there, I have a large HDF5file (~19 Gig size) with which I apparently having some data retrieval problems. It's hard to pinpoint exactly what the problem is, but it seems to be with the value in a column which is indexed. When I run the script and explicitly search with the record ID (qcid)

[Pytables-users] moving data from MySQL to a HDF5 using pytables

2009-01-14 Thread Toby Mathieson
Hi there, I am trying to port a single large table (~150 million records) into a single HDF5 file using Pytables. Whilst I am sure this is no problem to store in a HDF5 file, I am wondering if there is any way of getting this data directly from the MySQL file into the HDF5 file without having to