{"action":"created","issue":{"url":"https://api.github.com/repos/apache/tajo/issues/631","labels_url":"https://api.github.com/repos/apache/tajo/issues/631/labels{/name}","comments_url":"https://api.github.com/repos/apache/tajo/issues/631/comments","events_url":"https://api.github.com/repos/apache/tajo/issues/631/events","html_url":"https://github.com/apache/tajo/pull/631","id":95356470,"number":631,"title":"TAJO-1685: Query fails when using table data which located on local file system occasionally on fully distributed mode.","user":{"login":"blrunner","id":3724310,"avatar_url":"https://avatars.githubusercontent.com/u/3724310?v=3","gravatar_id":"","url":"https://api.github.com/users/blrunner","html_url":"https://github.com/blrunner","followers_url":"https://api.github.com/users/blrunner/followers","following_url":"https://api.github.com/users/blrunner/following{/other_user}","gists_url":"https://api.github.com/users/blrunner/gists{/gist_id}","starred_url":"https://api.github.com/users/blrunner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blrunner/subscriptions","organizations_url":"https://api.github.com/users/blrunner/orgs","repos_url":"https://api.github.com/users/blrunner/repos","events_url":"https://api.github.com/users/blrunner/events{/privacy}","received_events_url":"https://api.github.com/users/blrunner/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-07-16T05:44:13Z","updated_at":"2015-07-16T23:55:11Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/tajo/pulls/631","html_url":"https://github.com/apache/tajo/pull/631","diff_url":"https://github.com/apache/tajo/pull/631.diff","patch_url":"https://github.com/apache/tajo/pull/631.patch"},"body":"I added a message for avoiding users confusion as follows.\r\n\r\n```\r\ndefault> \\admin -cluster\r\nQuery Master\r\n============\r\n\r\nLive  Dead  Tasks\r\n----- ----- -----\r\n3     0     0    \r\n\r\nLive QueryMasters\r\n=================\r\n\r\nQueryMaster               Port  Query Heap       Status    \r\n------------------------- ----- ----- ---------- ----------\r\ntajo-04:28093 28092 0     16000 MB   RUNNING   \r\ntajo-03:28093 28092 0     16000 MB   RUNNING   \r\ntajo-05:28093 28092 0     16000 MB   RUNNING   \r\n\r\n\r\nWorker\r\n======\r\n\r\nLive  Dead \r\n----- -----\r\n3     0    \r\n\r\nLive Workers\r\n============\r\n\r\nWorker                    Port  Tasks Mem        Disk       Heap         Status    \r\n------------------------- ----- ----- ---------- ---------- ------------ ----------\r\ntajo-04:28091 53960 0     0/1024     0.00/2.00  427/16000 MB RUNNING   \r\ntajo-03:28091 34833 0     0/1024     0.00/2.00  418/16000 MB RUNNING   \r\ntajo-05:28091 40578 0     0/1024     0.00/2.00  412/16000 MB RUNNING   \r\n\r\n\r\nDead Workers\r\n============\r\n\r\nNo Dead Workers\r\n\r\ndefault> \\d table1;\r\n\r\ntable name: default.table1\r\ntable uri: file:/home/tajo/hadoop/data.csv\r\nstore type: text\r\nnumber of rows: unknown\r\nvolume: 60 B\r\nOptions: \r\n\t'text.delimiter'='|'\r\n\r\nschema: \r\nid\tINT4\r\nname\tTEXT\r\nscore\tFLOAT4\r\ntype\tTEXT\r\n\r\n\r\ndefault> select * from table1;\r\nid,  name,  score,  type\r\n-------------------------------\r\n1,  abc,  1.1,  a\r\n2,  def,  2.3,  b\r\n3,  ghi,  3.4,  c\r\n4,  jkl,  4.5,  d\r\n5,  mno,  5.6,  e\r\n(5 rows, 0.029 sec, 60 B selected)\r\n\r\ndefault> select count(*) from table1;\r\nERROR: The table data should be on all hosts to run TajoWorker or be on distributed file system. : file:/home/tajo/hadoop/data.csv\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/apache/tajo/issues/comments/122133119","html_url":"https://github.com/apache/tajo/pull/631#issuecomment-122133119","issue_url":"https://api.github.com/repos/apache/tajo/issues/631","id":122133119,"user":{"login":"jihoonson","id":2322288,"avatar_url":"https://avatars.githubusercontent.com/u/2322288?v=3","gravatar_id":"","url":"https://api.github.com/users/jihoonson","html_url":"https://github.com/jihoonson","followers_url":"https://api.github.com/users/jihoonson/followers","following_url":"https://api.github.com/users/jihoonson/following{/other_user}","gists_url":"https://api.github.com/users/jihoonson/gists{/gist_id}","starred_url":"https://api.github.com/users/jihoonson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jihoonson/subscriptions","organizations_url":"https://api.github.com/users/jihoonson/orgs","repos_url":"https://api.github.com/users/jihoonson/repos","events_url":"https://api.github.com/users/jihoonson/events{/privacy}","received_events_url":"https://api.github.com/users/jihoonson/received_events","type":"User","site_admin":false},"created_at":"2015-07-16T23:55:11Z","updated_at":"2015-07-16T23:55:11Z","body":"Rather than doing that, I think the query should be processed by a single machine, mostly tajo master, if we should support local file system as our storage. "}}