Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

count_distinct function doesn't exist in mysql #1373

Closed
maver1ck opened this issue Oct 19, 2016 · 4 comments
Closed

count_distinct function doesn't exist in mysql #1373

maver1ck opened this issue Oct 19, 2016 · 4 comments

Comments

@maver1ck
Copy link
Contributor

Hi,
I have following problem. When I'm using SQL Lab and COUNT(DISTINCT) metric Caravel is trying to calculate this metric using count_distinct function.
Unfortunately there is no such a function in MySQL. and I'm getting exception.

"error": "(_mysql_exceptions.OperationalError) (1305, 'FUNCTION test.count_distinct does not exist')
@xrmx
Copy link
Contributor

xrmx commented Nov 2, 2016

Any chance this has been fixed in newer releases?

@carlessebastian
Copy link

Same problem here. Not working with postgres.

@xrmx
Copy link
Contributor

xrmx commented Dec 1, 2016

@carlessebastian i don't think there are many chances that you are getting a mysql operational error on postgres.

@xrmx
Copy link
Contributor

xrmx commented Dec 1, 2016

While at it closing since it has been ~a month without feedback from original poster.

@xrmx xrmx closed this as completed Dec 1, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants