{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/presto/issues/2554","labels_url":"https://api.github.com/repos/facebook/presto/issues/2554/labels{/name}","comments_url":"https://api.github.com/repos/facebook/presto/issues/2554/comments","events_url":"https://api.github.com/repos/facebook/presto/issues/2554/events","html_url":"https://github.com/facebook/presto/issues/2554","id":62611248,"number":2554,"title":"Field reference operator only works on qualified name references with a single level","user":{"login":"BoatingClouds","id":8321363,"avatar_url":"https://avatars.githubusercontent.com/u/8321363?v=3","gravatar_id":"","url":"https://api.github.com/users/BoatingClouds","html_url":"https://github.com/BoatingClouds","followers_url":"https://api.github.com/users/BoatingClouds/followers","following_url":"https://api.github.com/users/BoatingClouds/following{/other_user}","gists_url":"https://api.github.com/users/BoatingClouds/gists{/gist_id}","starred_url":"https://api.github.com/users/BoatingClouds/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BoatingClouds/subscriptions","organizations_url":"https://api.github.com/users/BoatingClouds/orgs","repos_url":"https://api.github.com/users/BoatingClouds/repos","events_url":"https://api.github.com/users/BoatingClouds/events{/privacy}","received_events_url":"https://api.github.com/users/BoatingClouds/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"haozhun","id":2020503,"avatar_url":"https://avatars.githubusercontent.com/u/2020503?v=3","gravatar_id":"","url":"https://api.github.com/users/haozhun","html_url":"https://github.com/haozhun","followers_url":"https://api.github.com/users/haozhun/followers","following_url":"https://api.github.com/users/haozhun/following{/other_user}","gists_url":"https://api.github.com/users/haozhun/gists{/gist_id}","starred_url":"https://api.github.com/users/haozhun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/haozhun/subscriptions","organizations_url":"https://api.github.com/users/haozhun/orgs","repos_url":"https://api.github.com/users/haozhun/repos","events_url":"https://api.github.com/users/haozhun/events{/privacy}","received_events_url":"https://api.github.com/users/haozhun/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-03-18T07:17:16Z","updated_at":"2015-03-25T23:22:07Z","closed_at":null,"body":"1. Desc table schema.\r\npresto:test_db> desc test_orc_table;\r\n   Column    |                                                                       Type                                                                        | Null | Partitio\r\n-------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------+---------\r\n uid         | varchar                                                                                                                                           | true | false\r\n information | ROW(Optional[name] varchar, Optional[gender] varchar, Optional[education] ROW(Optional[primary_school] varchar, Optional[middle_school] varchar)) | true | false\r\n(2 rows)\r\n\r\n\r\n\r\n2. Query Success.\r\npresto:test_db> select uid, information from test_orc_table limit 3;\r\n   uid   |                                                        information\r\n---------+----------------------------------------------------------------------------------------------------------------------------\r\n 100 | {name=Jack, gender=Male, education={primary_school=xx1, middle_school=xx2}}\r\n 101 | {name=Lisa, gender=Female, education={primary_school=xx1, middle_school=xx2}}\r\n 102 | {name=Todd, gender=Male, education={primary_school=xx1, middle_school=xx2}}\r\n(5 rows)\r\n\r\n\r\n3. Query Success.\r\npresto:test_db> select uid, information.name from test_orc_table limit 3;\r\n   uid   |                   name\r\n---------+------------------------------------------\r\n 100 | Jack\r\n 101 | Lisa\r\n 102 | Todd\r\n(3 rows)\r\n\r\n\r\n\r\n4. Query Failed.\r\npresto:test_db> select uid, information.education.primary_school from test_orc_table limit 3;\r\nQuery 20140218_071429_00114_cqskj failed: Column 'information.education.primary_school' cannot be resolved\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/facebook/presto/issues/comments/86250678","html_url":"https://github.com/facebook/presto/issues/2554#issuecomment-86250678","issue_url":"https://api.github.com/repos/facebook/presto/issues/2554","id":86250678,"user":{"login":"cberner","id":842688,"avatar_url":"https://avatars.githubusercontent.com/u/842688?v=3","gravatar_id":"","url":"https://api.github.com/users/cberner","html_url":"https://github.com/cberner","followers_url":"https://api.github.com/users/cberner/followers","following_url":"https://api.github.com/users/cberner/following{/other_user}","gists_url":"https://api.github.com/users/cberner/gists{/gist_id}","starred_url":"https://api.github.com/users/cberner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cberner/subscriptions","organizations_url":"https://api.github.com/users/cberner/orgs","repos_url":"https://api.github.com/users/cberner/repos","events_url":"https://api.github.com/users/cberner/events{/privacy}","received_events_url":"https://api.github.com/users/cberner/received_events","type":"User","site_admin":false},"created_at":"2015-03-25T23:22:07Z","updated_at":"2015-03-25T23:22:07Z","body":"@haozhun this low priority, but will give you a bunch of exposure to the parser and analyzer. When you've finished with your other tasks lets discuss with @martint the best way to fix this"}}