{"action":"opened","issue":{"url":"https://api.github.com/repos/Huawei-Spark/SparkSQL-on-HBase/issues/17","labels_url":"https://api.github.com/repos/Huawei-Spark/SparkSQL-on-HBase/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/Huawei-Spark/SparkSQL-on-HBase/issues/17/comments","events_url":"https://api.github.com/repos/Huawei-Spark/SparkSQL-on-HBase/issues/17/events","html_url":"https://github.com/Huawei-Spark/SparkSQL-on-HBase/issues/17","id":94891231,"number":17,"title":"when set spark.sql.hbase.customfilter parameters false,result is error","user":{"login":"hoffmann99","id":13297637,"avatar_url":"https://avatars.githubusercontent.com/u/13297637?v=3","gravatar_id":"","url":"https://api.github.com/users/hoffmann99","html_url":"https://github.com/hoffmann99","followers_url":"https://api.github.com/users/hoffmann99/followers","following_url":"https://api.github.com/users/hoffmann99/following{/other_user}","gists_url":"https://api.github.com/users/hoffmann99/gists{/gist_id}","starred_url":"https://api.github.com/users/hoffmann99/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hoffmann99/subscriptions","organizations_url":"https://api.github.com/users/hoffmann99/orgs","repos_url":"https://api.github.com/users/hoffmann99/repos","events_url":"https://api.github.com/users/hoffmann99/events{/privacy}","received_events_url":"https://api.github.com/users/hoffmann99/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-14T08:13:08Z","updated_at":"2015-07-14T08:13:08Z","closed_at":null,"body":"[Hbase table]\r\nrowNum    int\r\nid          int\r\nname       string\r\ntimes       int\r\n\r\n[SQL]\r\nCREATE TABLE spark_times(rowNum int, id int, name string, times int, PRIMARY KEY (rowNum)) MAPPED BY (hbase_times, COLS=[id=cf.id, name=cf.name, times=cf.times]);\r\n\r\n[DATA]\r\n[1,xiaoming,16,id_1,teacherW]\r\n[2,xiaoming,16,id_2,teacherW]\r\n[3,xiaoming,16,id_3,teacherW]\r\n[4,xiaoming,16,id_4,teacherW]\r\n[5,xiaoming,16,id_5,teacherW]\r\n[6,xiaoming,16,id_6,teacherW]\r\n[7,xiaoming,16,id_7,teacherW]\r\n[8,xiaoming,16,id_8,teacherW]\r\n[9,xiaoming,16,id_9,teacherW]\r\n[10,xiaoming,16,id_10,teacherW]\r\n[11,xiaoming,16,id_11,teacherW]\r\n[12,xiaoming,16,id_12,teacherW]\r\n[13,xiaoming,16,id_13,teacherW]\r\n[14,xiaoming,16,id_14,teacherW]\r\n[15,xiaoming,16,id_15,teacherW]\r\n[16,xiaoming,16,id_16,teacherW]\r\n[17,xiaoming,16,id_17,teacherW]\r\n[18,xiaoming,16,id_18,teacherW]\r\n[19,xiaoming,16,id_19,teacherW]\r\n[1001,lihua,20,A1000,null]\r\n[1002,lihua,20,A1000,null]\r\n...\r\nCONF:\r\nset spark.sql.hbase.coprocessor=false;\r\nset spark.sql.hbase.customfilter=false;\r\n[SQL]\r\nselect school_identification from spark_people where school_director is null;\r\n\r\n[result] \r\n[id_1]\r\n[id_2]\r\n[id_3]\r\n[id_4]\r\n[id_5]\r\n[id_6]\r\n[id_7]\r\n[id_8]\r\n[id_9]\r\n...\r\n\r\nset spark.sql.hbase.coprocessor=true;\r\nset spark.sql.hbase.customfilter=true;\r\n[SQL]\r\nselect school_identification from spark_people where school_director is null;\r\n\r\n[result]\r\n[A1000]\r\n[A1000]\r\n\r\n"}}