{"action":"created","issue":{"url":"https://api.github.com/repos/prestodb/presto/issues/5681","repository_url":"https://api.github.com/repos/prestodb/presto","labels_url":"https://api.github.com/repos/prestodb/presto/issues/5681/labels{/name}","comments_url":"https://api.github.com/repos/prestodb/presto/issues/5681/comments","events_url":"https://api.github.com/repos/prestodb/presto/issues/5681/events","html_url":"https://github.com/prestodb/presto/issues/5681","id":165906874,"number":5681,"title":"alert partition location , Partition location does not exist","user":{"login":"yorkart","id":1518356,"avatar_url":"https://avatars.githubusercontent.com/u/1518356?v=3","gravatar_id":"","url":"https://api.github.com/users/yorkart","html_url":"https://github.com/yorkart","followers_url":"https://api.github.com/users/yorkart/followers","following_url":"https://api.github.com/users/yorkart/following{/other_user}","gists_url":"https://api.github.com/users/yorkart/gists{/gist_id}","starred_url":"https://api.github.com/users/yorkart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yorkart/subscriptions","organizations_url":"https://api.github.com/users/yorkart/orgs","repos_url":"https://api.github.com/users/yorkart/repos","events_url":"https://api.github.com/users/yorkart/events{/privacy}","received_events_url":"https://api.github.com/users/yorkart/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-16T03:56:39Z","updated_at":"2016-07-16T05:01:52Z","closed_at":null,"body":"hive table : `extral table`\r\ntable localtion : `/db/log/systemlog/`\r\nadd partition every day : `alert table systemlog add if not exists partition(dt='20160716',hour='00',minute='00'`\r\n\r\nnow, I want to modify partition\r\nfrom original location: `/db/log/systemlog/dt=20160716/hour=00/minute=00`\r\nto target location :   `/db1/log/systemlog/dt=20160716/hour=00/minute=00`\r\n\r\n1. `alter table systemlog partition (dt='20160716', hour='00', minute='00') set location '/db1/log/system/dt=20160716/hour=00/minute=00';`\r\n2. delete `/db/log/systemlog/dt=20160716/hour=00/minute=00`\r\n\r\nexecute sql  in hive is ok \r\n`select * from systemlog where dt='20160000' and hour='00' and minute='00'`\r\n\r\nbut  get error in presto\r\n`Query 20160716_033335_00023_nvfm4 failed: Partition location does not exist: /db1/log/systemlog/dt=20160716/hour=00/minute=00`\r\n"},"comment":{"url":"https://api.github.com/repos/prestodb/presto/issues/comments/233108514","html_url":"https://github.com/prestodb/presto/issues/5681#issuecomment-233108514","issue_url":"https://api.github.com/repos/prestodb/presto/issues/5681","id":233108514,"user":{"login":"yorkart","id":1518356,"avatar_url":"https://avatars.githubusercontent.com/u/1518356?v=3","gravatar_id":"","url":"https://api.github.com/users/yorkart","html_url":"https://github.com/yorkart","followers_url":"https://api.github.com/users/yorkart/followers","following_url":"https://api.github.com/users/yorkart/following{/other_user}","gists_url":"https://api.github.com/users/yorkart/gists{/gist_id}","starred_url":"https://api.github.com/users/yorkart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yorkart/subscriptions","organizations_url":"https://api.github.com/users/yorkart/orgs","repos_url":"https://api.github.com/users/yorkart/repos","events_url":"https://api.github.com/users/yorkart/events{/privacy}","received_events_url":"https://api.github.com/users/yorkart/received_events","type":"User","site_admin":false},"created_at":"2016-07-16T05:01:52Z","updated_at":"2016-07-16T05:01:52Z","body":"use  uri  is ok  \r\n`hdfs://hacluster//db1/log/systemlog/dt=20160716/hour=00/minute=00`"}}
{"actor":{"display_login":"yorkart"}}