eland icon indicating copy to clipboard operation
eland copied to clipboard

`eland.DataFrame.query` doesn't handle `datetime64` column

Open michaelhyatt opened this issue 3 years ago • 0 comments

I am trying to query the DataFrame based on the @timestamp column, but it doesn't seem to work. Am I using the wrong syntax?

My df:

df.dtypes
---
@timestamp                            datetime64[ns]
kubernetes.pod.cpu.usage.limit.pct           float64
kubernetes.pod.cpu.usage.nanocores             int64
kubernetes.pod.cpu.usage.node.pct            float64
kubernetes.pod.name                           object
metricset.name                                object
metricset.period                               int64
dtype: object

My query:

df.query('"@timestamp" > "2021-02-03"')
---
[/usr/local/lib/python3.7/dist-packages/pandas/core/computation/common.py](https://localhost:8080/#) in result_type_many(*arrays_and_dtypes)
     21     """
     22     try:
---> 23         return np.result_type(*arrays_and_dtypes)
     24     except ValueError:
     25         # we have > NPY_MAXARGS terms in our expression

<__array_function__ internals> in result_type(*args, **kwargs)

TypeError: data type '@timestamp' not understood

michaelhyatt avatar Feb 07 '22 22:02 michaelhyatt