i am trying to use `valuein` and `distinctcounthl...
# troubleshooting
p
i am trying to use
valuein
and
distinctcounthll
from looker to query pinot data via trino. i get this error
Copy code
Query failed (#20220622_071712_00006_mi58r): line 4:24: Function 'valuein' not registered
I was able to get away from the error by querying like
Copy code
SELECT * FROM pinot.default."SELECT VALUEIN(myfield, 'abc', 'def') AS group_by_field, count(*) FROM mytable GROUP BY group_by_field"
d
Yeah, I had some errors like that when I was trying to use Trino, seems like it can only understand functions defined in Trino itself.
1