{"action":"created","issue":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/70","labels_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/70/labels{/name}","comments_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/70/comments","events_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/70/events","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/70","id":93956670,"number":70,"title":"Aggregation for \"group by\" has something wrong when the group by field is Chinese characters","user":{"login":"dengkane","id":1072816,"avatar_url":"https://avatars.githubusercontent.com/u/1072816?v=3","gravatar_id":"","url":"https://api.github.com/users/dengkane","html_url":"https://github.com/dengkane","followers_url":"https://api.github.com/users/dengkane/followers","following_url":"https://api.github.com/users/dengkane/following{/other_user}","gists_url":"https://api.github.com/users/dengkane/gists{/gist_id}","starred_url":"https://api.github.com/users/dengkane/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dengkane/subscriptions","organizations_url":"https://api.github.com/users/dengkane/orgs","repos_url":"https://api.github.com/users/dengkane/repos","events_url":"https://api.github.com/users/dengkane/events{/privacy}","received_events_url":"https://api.github.com/users/dengkane/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-09T05:09:01Z","updated_at":"2015-07-09T13:51:10Z","closed_at":null,"body":"E.g. have an index and the columns are member_name and city, and the city column is Chinese character, such as '北京','上海',etc.\r\n\r\nselect count(*) from indexName group by city\r\n\r\nwill return \r\n\r\n北    2\r\n京    2\r\n上    5\r\n海    5\r\n\r\nI want this result\r\n\r\n北京    2\r\n上海    5\r\n\r\nHow can I get the result I want?\r\n\r\nThank you."},"comment":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/comments/119975719","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/70#issuecomment-119975719","issue_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/70","id":119975719,"user":{"login":"omershelef","id":9518816,"avatar_url":"https://avatars.githubusercontent.com/u/9518816?v=3","gravatar_id":"","url":"https://api.github.com/users/omershelef","html_url":"https://github.com/omershelef","followers_url":"https://api.github.com/users/omershelef/followers","following_url":"https://api.github.com/users/omershelef/following{/other_user}","gists_url":"https://api.github.com/users/omershelef/gists{/gist_id}","starred_url":"https://api.github.com/users/omershelef/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/omershelef/subscriptions","organizations_url":"https://api.github.com/users/omershelef/orgs","repos_url":"https://api.github.com/users/omershelef/repos","events_url":"https://api.github.com/users/omershelef/events{/privacy}","received_events_url":"https://api.github.com/users/omershelef/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T13:51:10Z","updated_at":"2015-07-09T13:51:10Z","body":"Is it possible that the standard analyzer tokenize chinese by characte? If this is the case, you must group by field which is not analyzed. The group by works by terms aggregation. "}}