{"comment":{"url":"https://api.github.com/repos/julianhyde/incubator-calcite/comments/12247789","html_url":"https://github.com/julianhyde/incubator-calcite/commit/26628094de8b2fcdfb9a284d9c3d96539ba3d6ad#commitcomment-12247789","id":12247789,"user":{"login":"vlsi","id":213894,"avatar_url":"https://avatars.githubusercontent.com/u/213894?v=3","gravatar_id":"","url":"https://api.github.com/users/vlsi","html_url":"https://github.com/vlsi","followers_url":"https://api.github.com/users/vlsi/followers","following_url":"https://api.github.com/users/vlsi/following{/other_user}","gists_url":"https://api.github.com/users/vlsi/gists{/gist_id}","starred_url":"https://api.github.com/users/vlsi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vlsi/subscriptions","organizations_url":"https://api.github.com/users/vlsi/orgs","repos_url":"https://api.github.com/users/vlsi/repos","events_url":"https://api.github.com/users/vlsi/events{/privacy}","received_events_url":"https://api.github.com/users/vlsi/received_events","type":"User","site_admin":false},"position":41,"line":4560,"path":"core/src/test/java/org/apache/calcite/test/JdbcTest.java","commit_id":"26628094de8b2fcdfb9a284d9c3d96539ba3d6ad","created_at":"2015-07-20T08:07:54Z","updated_at":"2015-07-20T08:07:54Z","body":"Can you highlight the exact case why do you think this query is important?\r\nWhat if you add 5 independent queries?\r\n\r\nWell, if you happen to include that, please include smaller queries.\r\nIn other words:\r\nq1) just  row_number() over (order by deptno)\r\nq2) just  row_number() over (partition by deptno order by gender desc)\r\n...\r\nq5) just row_number() over () \r\nq6) all the q1-q5 combined\r\n\r\nThis will simplify the root-cause analysis since q1-q5 will have a chance to fail independently.\r\n"}}