search

rpbouman / huey

A UI for DuckDB
MIT License
250 stars 17 forks source link

Error slicing and dicing DATE values. #48

Closed rpbouman closed 9 months ago

rpbouman commented 9 months ago

We have a csv upload with data that looks like this:

LOGDATE,LOGTIME,SERVER,TASK_ID,TYPE,Type of Measurement,MEASUREMENTS,LOAD,ITERATION,ITERATION_CONTINUES,PROOF,RESPONSE_TIME,RESPONSE_TIME_S,ITERATION_DATE,ITERATION_TIME,ServerType,CPU,Server Capacity
11/27/2023,10:10:15 AM,host1,MIO0000098,Forced Logical Read,HL Logical Read,All,20% CPU 10%,1,1,"50,000",6,6,11/27/2023,10:10:09 AM,DB,48 No Boost,DB 48 No Boost
11/27/2023,10:10:58 AM, host1,MIO0000098,Forced Logical Read,HL Logical Read,All,20% CPU 10%,2,2,"50,000",6,6,11/27/2023,10:10:52 AM,DB,48 No Boost,DB 48 No Boost
11/27/2023,10:11:42 AM, host1,MIO0000098,Forced Logical Read,HL Logical Read,All,20% CPU 10%,3,3,"50,000",6,6,11/27/2023,10:11:36 AM,DB,48 No Boost,DB 48 No Boost
11/27/2023,10:12:25 AM, host1,MIO0000098,Forced Logical Read,HL Logical Read,All,20% CPU 10%,4,4,"50,000",6,6,11/27/2023,10:12:19 AM,DB,48 No Boost,DB 48 No Boost
11/27/2023,10:13:08 AM, host1,MIO0000098,Forced Logical Read,HL Logical Read,All,20% CPU 10%,5,5,"50,000",5,5,11/27/2023,10:13:03 AM,DB,48 No Boost,DB 48 No Boost

DuckDB correctly infers a DATE datatype for LOGDATE column. In the resultset, these are returned as JavaScript Date objects. Then, when we try to fetch the cells, the condition on the aggregate query fails to retrieve the tuple values.

rpbouman commented 9 months ago

image