Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

[Tableau] - add support for GROUP BY X #520

Closed
kuba-- opened this issue Oct 31, 2018 · 1 comment
Closed

[Tableau] - add support for GROUP BY X #520

kuba-- opened this issue Oct 31, 2018 · 1 comment
Assignees
Labels
feature hacktoberfest Ready to pick for Hacktoberfest

Comments

@kuba--
Copy link
Contributor

kuba-- commented Oct 31, 2018

Tableau spreadsheet sends following requests:

SELECT SUBSTRING(`commits`.`commit_hash`, 1, 1024) AS `commit_hash`
FROM `commits`
  INNER JOIN `files` ON (SUBSTRING(`commits`.`repository_id`, 1, 1024) = SUBSTRING(`files`.`repository_id`, 1, 1024))
  INNER JOIN `repositories` ON (`commits`.`repository_id` = SUBSTRING(`repositories`.`repository_id`, 1, 1024))
GROUP BY 1

what gets an unknown error:

MySQL][ODBC 5.3(w) Driver][mysqld-5.5.10-Vitess]unknown error: GroupBy aggregate expression 'SUBSTRING(commits.commit_hash, 1, 1024) as commit_hash' doesn't appear in the grouping columns

SELECT SUBSTRING(`commits`.`commit_hash`, 1, 1024) AS `commit_hash`
FROM `commits`
  INNER JOIN `files` ON (SUBSTRING(`commits`.`repository_id`, 1, 1024) = SUBSTRING(`files`.`repository_id`, 1, 1024))
  INNER JOIN `repositories` ON (`commits`.`repository_id` = SUBSTRING(`repositories`.`repository_id`, 1, 1024))
GROUP BY 1
@kuba--
Copy link
Contributor Author

kuba-- commented Nov 1, 2018

Depends on issue:
#524

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
feature hacktoberfest Ready to pick for Hacktoberfest
Projects
None yet
Development

No branches or pull requests

1 participant