search

metriql / metriql

The metrics layer for your data. Join us at https://metriql.com/slack
https://metriql.com
Apache License 2.0
298 stars 25 forks source link

Support LOWER/UPPER #53

Closed AndreasTA-AW closed 2 years ago

AndreasTA-AW commented 2 years ago

Currently it seems LOWER and UPPER is not implemented. BI Tools really on this functionality at least in the WHERE clauses.

buremba commented 2 years ago

Thanks!

AndreasTA-AW commented 2 years ago

Still getting 

kotlin.NotImplementedError: An operation is not implemented.
at io.trino.sql.SqlToSegmentation.processWhereExpression(SqlToSegmentation.kt:454)
FROM SELECT 
  "ta_1"."some_boolean" "ca_1", 
  count("ta_1"."total_orders") "ca_2"
FROM "metriql"."public"."model_proj_model" "ta_1"
WHERE LOWER("ta_1"."some_string_col") = 'it'
GROUP BY "ta_1"."some_boolean"
LIMIT 5000

I guess it's the LOWER it's still complaining about.