Hi, I am using h5pyd Table class and read_where() method to retrieve specific data from my dataset. I think there is an issue when there is a number in the column name.
My dataset has two identical columns, one named “column_A” and the other “column_1”.
When running some query against column_A, everything works fine. But when I do the same test for column_1, I get the following error:
Traceback (most recent call last):
File "C:\Users\TheoPLANTEFOL\Desktop\scripts\LOT3\4_hsds_queries.py", line 38, in <module>
results = table.read_where(condition) # note : include_index does not work
File "C:\Users\TheoPLANTEFOL\Desktop\scripts\win-venv\Lib\site-packages\h5pyd\_hl\table.py", line 204, in read_where
rsp = self.GET(req, params=params)
File "C:\Users\TheoPLANTEFOL\Desktop\scripts\win-venv\Lib\site-packages\h5pyd\_hl\base.py", line 973, in GET
rsp = self.id._http_conn.GET(req, params=params, headers=headers, format=format, use_cache=use_cache)
File "C:\Users\TheoPLANTEFOL\Desktop\scripts\win-venv\Lib\site-packages\h5pyd\_hl\httpconn.py", line 522, in GET
body = json.loads(rsp.text)
File "C:\Program Files\Python313\Lib\json\__init__.py", line 346, in loads
return _default_decoder.decode(s)
~~~~~~~~~~~~~~~~~~~~~~~^^^
File "C:\Program Files\Python313\Lib\json\decoder.py", line 345, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python313\Lib\json\decoder.py", line 363, in raw_decode
raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
This is my code:
import h5pyd
with h5pyd.File("hdf5://home/tests/dataset.h5", "r") as file:
table = file.get("table")
results_A = table.read_where(condition="column_A < 20") # works
results_1 = table.read_where(condition="colunm_1 < 20") # does not work