{"action":"opened","issue":{"url":"https://api.github.com/repos/linkedin/pinot/issues/61","labels_url":"https://api.github.com/repos/linkedin/pinot/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/linkedin/pinot/issues/61/comments","events_url":"https://api.github.com/repos/linkedin/pinot/issues/61/events","html_url":"https://github.com/linkedin/pinot/issues/61","id":114332302,"number":61,"title":"Incorrect secondary ordering","user":{"login":"gregspurrier","id":5880,"avatar_url":"https://avatars.githubusercontent.com/u/5880?v=3","gravatar_id":"","url":"https://api.github.com/users/gregspurrier","html_url":"https://github.com/gregspurrier","followers_url":"https://api.github.com/users/gregspurrier/followers","following_url":"https://api.github.com/users/gregspurrier/following{/other_user}","gists_url":"https://api.github.com/users/gregspurrier/gists{/gist_id}","starred_url":"https://api.github.com/users/gregspurrier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gregspurrier/subscriptions","organizations_url":"https://api.github.com/users/gregspurrier/orgs","repos_url":"https://api.github.com/users/gregspurrier/repos","events_url":"https://api.github.com/users/gregspurrier/events{/privacy}","received_events_url":"https://api.github.com/users/gregspurrier/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-10-30T18:52:23Z","updated_at":"2015-10-30T18:52:23Z","closed_at":null,"body":"Using quick-start-offline.sh with the repository as of commit dd3b058bc10d04f61374fd050b467440b756e7f2, a secondary ordering term is not working as expected.\r\n\r\nFor example, `curl -X POST -d '{\"pql\":\"select yearID, playerName from baseballStats order by yearID, playerName\"}' http://localhost:7000/query` yields:\r\n\r\n```json\r\n{\r\n  \"selectionResults\": {\r\n    \"columns\": [\r\n      \"yearID\",\r\n      \"playerName\"\r\n    ],\r\n    \"results\": [\r\n      [\r\n        \"1871\",\r\n        \"Caleb Clark\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Asahel\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Arthur Algernon\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Andrew Jackson\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Alfred L.\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Alfred James\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Albert Goodwill\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Albert G.\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Adrian Constantine\"\r\n      ],\r\n      [\r\n        \"1871\",\r\n        \"Calvin Alexander\"\r\n      ]\r\n    ]\r\n  },\r\n  \"traceInfo\": {},\r\n  \"numDocsScanned\": 97889,\r\n  \"aggregationResults\": [],\r\n  \"timeUsedMs\": 20,\r\n  \"segmentStatistics\": [],\r\n  \"exceptions\": [],\r\n  \"totalDocs\": 97889\r\n}\r\n```\r\n\r\nNotice that the playerName values in the grouping are not in the correct order."}}