Ivan
Ivan
Any tip on how to easily reproduce a long timed query to develop/test this?
In my case, running it as `sudo` did not fix it. It was only fixed by creating the locales manually which can be cumbersome, I created a simple Python script...
CrateDB supports many aggregate functions, https://cratedb.com/docs/crate/reference/en/5.6/general/builtins/aggregation.html#aggregation Is there any that you are missing from Crate?
Right ```sql SELECT abs(127::NUMERIC); > 127 SELECT abs(128::NUMERIC); > SQLParseException[Cannot cast `128` of type `numeric` to type `byte`] SELECT ceil(128::NUMERIC); > SQLParseException[Cannot cast `128` of type `numeric` to type `byte`]...
Confirmed: `abs` `ceil` `ceiling` `exp` `floor` `round` `sqrt`
This is pretty much also the case with `variance`, the formula varies depending on sample vs population. crate: `select variance(a) from unnest([1, 2, 3, 4, 5]) as a; -> 2`...
I think we should move this away from crash and create a separate repo to have the development of antlr4 -> targets. I see two uses cases for the antlr4...
> > I see two uses cases for the antlr4 targets: > > Python: For crash and cloud team > > Javascript: Local admin UI without any backend. > >...
cc @proddata