[pytables-users] PyTables comparing tuples of two columns with set entries??unsupported expr type:<class 'generator'>

[s***@googlemail.com]

Hello!

I have a table of about 3 mio entries and have to search it in the way:

query = """((column1, column2) == (entry[x],entry[y]) for entry[x,y] in
{0})""".format(my_set_of_tuples)

in table.where(query).

It says:
raise TypeError("unsupported expression type: %s" % type(ex))

TypeError: unsupported expression type: <class 'generator'>

By iterating it takes about 3 hours to get it's values!
also I might first need the count of it...
And by regular expression and iterating each set of tuples the table anew
is very inefficient, too.
Putting all together as a long query boots my system in seg fault... (the
searched tuple count is about 1 mio.)

Does anyone may help me? I have to solve it by PyTables expressions.

Thank you very much!
yours