{"action":"created","comment":{"url":"https://api.github.com/repos/cloudera/quince/pulls/comments/41282213","id":41282213,"diff_hunk":"@@ -139,16 +123,26 @@ For Impala, update the partition information with:\n \n ```bash\n impala-shell -q 'refresh datasets.variants_flat_locuspart'\n+impala-shell -q 'compute stats datasets.variants_flat_locuspart'\n impala-shell -q 'show partitions datasets.variants_flat_locuspart'\n ```\n \n+## Deleting data\n+\n+You can remove all the data with the following commands. _Note that the data will be \n+deleted permanently!_\n+\n+```bash\n+hive -e 'drop table datasets.variants_flat_locuspart'\n+hadoop fs -rm -r datasets/variants_flat_locuspart\n+```","path":"README.md","position":113,"original_position":113,"commit_id":"b79e15b9ea41912f3942654f8efc2025b3513845","original_commit_id":"b79e15b9ea41912f3942654f8efc2025b3513845","user":{"login":"tomwhite","id":85085,"avatar_url":"https://avatars.githubusercontent.com/u/85085?v=3","gravatar_id":"","url":"https://api.github.com/users/tomwhite","html_url":"https://github.com/tomwhite","followers_url":"https://api.github.com/users/tomwhite/followers","following_url":"https://api.github.com/users/tomwhite/following{/other_user}","gists_url":"https://api.github.com/users/tomwhite/gists{/gist_id}","starred_url":"https://api.github.com/users/tomwhite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomwhite/subscriptions","organizations_url":"https://api.github.com/users/tomwhite/orgs","repos_url":"https://api.github.com/users/tomwhite/repos","events_url":"https://api.github.com/users/tomwhite/events{/privacy}","received_events_url":"https://api.github.com/users/tomwhite/received_events","type":"User","site_admin":false},"body":"We could add that as well I think. I tried running the following but hit some problems. Opened https://github.com/cloudera/quince/issues/21\r\n\r\n```\r\nhive -e \"truncate table datasets.variants_flat_locuspart partition (sample_group='sample1')\"\r\nhadoop fs -rm -r datasets/variants_flat_locuspart/chr=*/pos=*/sample_group=sample1\r\n```\r\n\r\n","created_at":"2015-10-06T15:47:20Z","updated_at":"2015-10-06T15:47:20Z","html_url":"https://github.com/cloudera/quince/pull/17#discussion_r41282213","pull_request_url":"https://api.github.com/repos/cloudera/quince/pulls/17","_links":{"self":{"href":"https://api.github.com/repos/cloudera/quince/pulls/comments/41282213"},"html":{"href":"https://github.com/cloudera/quince/pull/17#discussion_r41282213"},"pull_request":{"href":"https://api.github.com/repos/cloudera/quince/pulls/17"}}},"pull_request":{"url":"https://api.github.com/repos/cloudera/quince/pulls/17","id":45763824,"html_url":"https://github.com/cloudera/quince/pull/17","diff_url":"https://github.com/cloudera/quince/pull/17.diff","patch_url":"https://github.com/cloudera/quince/pull/17.patch","issue_url":"https://api.github.com/repos/cloudera/quince/issues/17","number":17,"state":"open","locked":false,"title":"Do partitioning and sorting in Crunch","user":{"login":"tomwhite","id":85085,"avatar_url":"https://avatars.githubusercontent.com/u/85085?v=3","gravatar_id":"","url":"https://api.github.com/users/tomwhite","html_url":"https://github.com/tomwhite","followers_url":"https://api.github.com/users/tomwhite/followers","following_url":"https://api.github.com/users/tomwhite/following{/other_user}","gists_url":"https://api.github.com/users/tomwhite/gists{/gist_id}","starred_url":"https://api.github.com/users/tomwhite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomwhite/subscriptions","organizations_url":"https://api.github.com/users/tomwhite/orgs","repos_url":"https://api.github.com/users/tomwhite/repos","events_url":"https://api.github.com/users/tomwhite/events{/privacy}","received_events_url":"https://api.github.com/users/tomwhite/received_events","type":"User","site_admin":false},"body":"This change gives a marked performance increase (e.g. from 28 to 14 minutes on ALL.chr22.phase1_release_v3.20101123.snps_indels_svs.genotypes.vcf).\r\n\r\nIt relies on an extension to Crunch that produces one file per partition of a PTable<String, T>, where the key is the file name. This already exists in Crunch for Avro files, but not for Parquet, so I've added that in https://issues.apache.org/jira/browse/CRUNCH-562. Until this is released in Crunch I've included the files in this PR too.\r\n\r\nThis change also fixes #11 by using Hive commands to create the table and add partitions.","created_at":"2015-09-23T10:28:29Z","updated_at":"2015-10-06T15:47:20Z","closed_at":null,"merged_at":null,"merge_commit_sha":"0e8edb9391492b62f67c3a8d0b8afe5719297742","assignee":{"login":"tomwhite","id":85085,"avatar_url":"https://avatars.githubusercontent.com/u/85085?v=3","gravatar_id":"","url":"https://api.github.com/users/tomwhite","html_url":"https://github.com/tomwhite","followers_url":"https://api.github.com/users/tomwhite/followers","following_url":"https://api.github.com/users/tomwhite/following{/other_user}","gists_url":"https://api.github.com/users/tomwhite/gists{/gist_id}","starred_url":"https://api.github.com/users/tomwhite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomwhite/subscriptions","organizations_url":"https://api.github.com/users/tomwhite/orgs","repos_url":"https://api.github.com/users/tomwhite/repos","events_url":"https://api.github.com/users/tomwhite/events{/privacy}","received_events_url":"https://api.github.com/users/tomwhite/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/cloudera/quince/pulls/17/commits","review_comments_url":"https://api.github.com/repos/cloudera/quince/pulls/17/comments","review_comment_url":"https://api.github.com/repos/cloudera/quince/pulls/comments{/number}","comments_url":"https://api.github.com/repos/cloudera/quince/issues/17/comments","statuses_url":"https://api.github.com/repos/cloudera/quince/statuses/b79e15b9ea41912f3942654f8efc2025b3513845","head":{"label":"cloudera:perf","ref":"perf","sha":"b79e15b9ea41912f3942654f8efc2025b3513845","user":{"login":"cloudera","id":87383,"avatar_url":"https://avatars.githubusercontent.com/u/87383?v=3","gravatar_id":"","url":"https://api.github.com/users/cloudera","html_url":"https://github.com/cloudera","followers_url":"https://api.github.com/users/cloudera/followers","following_url":"https://api.github.com/users/cloudera/following{/other_user}","gists_url":"https://api.github.com/users/cloudera/gists{/gist_id}","starred_url":"https://api.github.com/users/cloudera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cloudera/subscriptions","organizations_url":"https://api.github.com/users/cloudera/orgs","repos_url":"https://api.github.com/users/cloudera/repos","events_url":"https://api.github.com/users/cloudera/events{/privacy}","received_events_url":"https://api.github.com/users/cloudera/received_events","type":"Organization","site_admin":false},"repo":{"id":39590591,"name":"quince","full_name":"cloudera/quince","owner":{"login":"cloudera","id":87383,"avatar_url":"https://avatars.githubusercontent.com/u/87383?v=3","gravatar_id":"","url":"https://api.github.com/users/cloudera","html_url":"https://github.com/cloudera","followers_url":"https://api.github.com/users/cloudera/followers","following_url":"https://api.github.com/users/cloudera/following{/other_user}","gists_url":"https://api.github.com/users/cloudera/gists{/gist_id}","starred_url":"https://api.github.com/users/cloudera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cloudera/subscriptions","organizations_url":"https://api.github.com/users/cloudera/orgs","repos_url":"https://api.github.com/users/cloudera/repos","events_url":"https://api.github.com/users/cloudera/events{/privacy}","received_events_url":"https://api.github.com/users/cloudera/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cloudera/quince","description":"Scalable genomics variant store and analytics","fork":false,"url":"https://api.github.com/repos/cloudera/quince","forks_url":"https://api.github.com/repos/cloudera/quince/forks","keys_url":"https://api.github.com/repos/cloudera/quince/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cloudera/quince/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cloudera/quince/teams","hooks_url":"https://api.github.com/repos/cloudera/quince/hooks","issue_events_url":"https://api.github.com/repos/cloudera/quince/issues/events{/number}","events_url":"https://api.github.com/repos/cloudera/quince/events","assignees_url":"https://api.github.com/repos/cloudera/quince/assignees{/user}","branches_url":"https://api.github.com/repos/cloudera/quince/branches{/branch}","tags_url":"https://api.github.com/repos/cloudera/quince/tags","blobs_url":"https://api.github.com/repos/cloudera/quince/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cloudera/quince/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cloudera/quince/git/refs{/sha}","trees_url":"https://api.github.com/repos/cloudera/quince/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cloudera/quince/statuses/{sha}","languages_url":"https://api.github.com/repos/cloudera/quince/languages","stargazers_url":"https://api.github.com/repos/cloudera/quince/stargazers","contributors_url":"https://api.github.com/repos/cloudera/quince/contributors","subscribers_url":"https://api.github.com/repos/cloudera/quince/subscribers","subscription_url":"https://api.github.com/repos/cloudera/quince/subscription","commits_url":"https://api.github.com/repos/cloudera/quince/commits{/sha}","git_commits_url":"https://api.github.com/repos/cloudera/quince/git/commits{/sha}","comments_url":"https://api.github.com/repos/cloudera/quince/comments{/number}","issue_comment_url":"https://api.github.com/repos/cloudera/quince/issues/comments{/number}","contents_url":"https://api.github.com/repos/cloudera/quince/contents/{+path}","compare_url":"https://api.github.com/repos/cloudera/quince/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cloudera/quince/merges","archive_url":"https://api.github.com/repos/cloudera/quince/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cloudera/quince/downloads","issues_url":"https://api.github.com/repos/cloudera/quince/issues{/number}","pulls_url":"https://api.github.com/repos/cloudera/quince/pulls{/number}","milestones_url":"https://api.github.com/repos/cloudera/quince/milestones{/number}","notifications_url":"https://api.github.com/repos/cloudera/quince/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cloudera/quince/labels{/name}","releases_url":"https://api.github.com/repos/cloudera/quince/releases{/id}","created_at":"2015-07-23T20:26:58Z","updated_at":"2015-09-27T18:04:17Z","pushed_at":"2015-09-27T23:18:50Z","git_url":"git://github.com/cloudera/quince.git","ssh_url":"git@github.com:cloudera/quince.git","clone_url":"https://github.com/cloudera/quince.git","svn_url":"https://github.com/cloudera/quince","homepage":null,"size":330,"stargazers_count":9,"watchers_count":9,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":5,"mirror_url":null,"open_issues_count":10,"forks":5,"open_issues":10,"watchers":9,"default_branch":"master"}},"base":{"label":"cloudera:master","ref":"master","sha":"0fad83efc649be4662b275d51fcb79b9f81d7f17","user":{"login":"cloudera","id":87383,"avatar_url":"https://avatars.githubusercontent.com/u/87383?v=3","gravatar_id":"","url":"https://api.github.com/users/cloudera","html_url":"https://github.com/cloudera","followers_url":"https://api.github.com/users/cloudera/followers","following_url":"https://api.github.com/users/cloudera/following{/other_user}","gists_url":"https://api.github.com/users/cloudera/gists{/gist_id}","starred_url":"https://api.github.com/users/cloudera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cloudera/subscriptions","organizations_url":"https://api.github.com/users/cloudera/orgs","repos_url":"https://api.github.com/users/cloudera/repos","events_url":"https://api.github.com/users/cloudera/events{/privacy}","received_events_url":"https://api.github.com/users/cloudera/received_events","type":"Organization","site_admin":false},"repo":{"id":39590591,"name":"quince","full_name":"cloudera/quince","owner":{"login":"cloudera","id":87383,"avatar_url":"https://avatars.githubusercontent.com/u/87383?v=3","gravatar_id":"","url":"https://api.github.com/users/cloudera","html_url":"https://github.com/cloudera","followers_url":"https://api.github.com/users/cloudera/followers","following_url":"https://api.github.com/users/cloudera/following{/other_user}","gists_url":"https://api.github.com/users/cloudera/gists{/gist_id}","starred_url":"https://api.github.com/users/cloudera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cloudera/subscriptions","organizations_url":"https://api.github.com/users/cloudera/orgs","repos_url":"https://api.github.com/users/cloudera/repos","events_url":"https://api.github.com/users/cloudera/events{/privacy}","received_events_url":"https://api.github.com/users/cloudera/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cloudera/quince","description":"Scalable genomics variant store and analytics","fork":false,"url":"https://api.github.com/repos/cloudera/quince","forks_url":"https://api.github.com/repos/cloudera/quince/forks","keys_url":"https://api.github.com/repos/cloudera/quince/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cloudera/quince/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cloudera/quince/teams","hooks_url":"https://api.github.com/repos/cloudera/quince/hooks","issue_events_url":"https://api.github.com/repos/cloudera/quince/issues/events{/number}","events_url":"https://api.github.com/repos/cloudera/quince/events","assignees_url":"https://api.github.com/repos/cloudera/quince/assignees{/user}","branches_url":"https://api.github.com/repos/cloudera/quince/branches{/branch}","tags_url":"https://api.github.com/repos/cloudera/quince/tags","blobs_url":"https://api.github.com/repos/cloudera/quince/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cloudera/quince/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cloudera/quince/git/refs{/sha}","trees_url":"https://api.github.com/repos/cloudera/quince/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cloudera/quince/statuses/{sha}","languages_url":"https://api.github.com/repos/cloudera/quince/languages","stargazers_url":"https://api.github.com/repos/cloudera/quince/stargazers","contributors_url":"https://api.github.com/repos/cloudera/quince/contributors","subscribers_url":"https://api.github.com/repos/cloudera/quince/subscribers","subscription_url":"https://api.github.com/repos/cloudera/quince/subscription","commits_url":"https://api.github.com/repos/cloudera/quince/commits{/sha}","git_commits_url":"https://api.github.com/repos/cloudera/quince/git/commits{/sha}","comments_url":"https://api.github.com/repos/cloudera/quince/comments{/number}","issue_comment_url":"https://api.github.com/repos/cloudera/quince/issues/comments{/number}","contents_url":"https://api.github.com/repos/cloudera/quince/contents/{+path}","compare_url":"https://api.github.com/repos/cloudera/quince/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cloudera/quince/merges","archive_url":"https://api.github.com/repos/cloudera/quince/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cloudera/quince/downloads","issues_url":"https://api.github.com/repos/cloudera/quince/issues{/number}","pulls_url":"https://api.github.com/repos/cloudera/quince/pulls{/number}","milestones_url":"https://api.github.com/repos/cloudera/quince/milestones{/number}","notifications_url":"https://api.github.com/repos/cloudera/quince/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cloudera/quince/labels{/name}","releases_url":"https://api.github.com/repos/cloudera/quince/releases{/id}","created_at":"2015-07-23T20:26:58Z","updated_at":"2015-09-27T18:04:17Z","pushed_at":"2015-09-27T23:18:50Z","git_url":"git://github.com/cloudera/quince.git","ssh_url":"git@github.com:cloudera/quince.git","clone_url":"https://github.com/cloudera/quince.git","svn_url":"https://github.com/cloudera/quince","homepage":null,"size":330,"stargazers_count":9,"watchers_count":9,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":5,"mirror_url":null,"open_issues_count":10,"forks":5,"open_issues":10,"watchers":9,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/cloudera/quince/pulls/17"},"html":{"href":"https://github.com/cloudera/quince/pull/17"},"issue":{"href":"https://api.github.com/repos/cloudera/quince/issues/17"},"comments":{"href":"https://api.github.com/repos/cloudera/quince/issues/17/comments"},"review_comments":{"href":"https://api.github.com/repos/cloudera/quince/pulls/17/comments"},"review_comment":{"href":"https://api.github.com/repos/cloudera/quince/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/cloudera/quince/pulls/17/commits"},"statuses":{"href":"https://api.github.com/repos/cloudera/quince/statuses/b79e15b9ea41912f3942654f8efc2025b3513845"}}}}