{"action":"created","issue":{"url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/24","labels_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/24/comments","events_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/24/events","html_url":"https://github.com/Stratio/cassandra-lucene-index/issues/24","id":98207367,"number":24,"title":"Lucene Index does not return correct data","user":{"login":"bgrimaud","id":13572808,"avatar_url":"https://avatars.githubusercontent.com/u/13572808?v=3","gravatar_id":"","url":"https://api.github.com/users/bgrimaud","html_url":"https://github.com/bgrimaud","followers_url":"https://api.github.com/users/bgrimaud/followers","following_url":"https://api.github.com/users/bgrimaud/following{/other_user}","gists_url":"https://api.github.com/users/bgrimaud/gists{/gist_id}","starred_url":"https://api.github.com/users/bgrimaud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgrimaud/subscriptions","organizations_url":"https://api.github.com/users/bgrimaud/orgs","repos_url":"https://api.github.com/users/bgrimaud/repos","events_url":"https://api.github.com/users/bgrimaud/events{/privacy}","received_events_url":"https://api.github.com/users/bgrimaud/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":15,"created_at":"2015-07-30T16:12:05Z","updated_at":"2015-08-10T09:50:47Z","closed_at":null,"body":"We have a problem with the consistency of the lucene index.\r\nOur context :\r\n\r\n//Create table with the schema bellow\r\n CREATE TABLE keyspace_1.table_1 (\r\n\tfield_1 text,\r\n\tfield_2 int,\r\n\tfield_3 timestamp,\r\n\tfield_4 text,\r\n\tfield_5 text,\r\n\tfield_6 text,\r\n\tfield_7 text,\r\n\tfield_8 text,\r\n\tfield_9 text,\r\n\tfield_10 text,\r\n\tfield_11 text,\r\n\tfield_12 text,\r\n\tfield_13 int,\r\n\tfield_14 text,\r\n\tfield_15 int,\r\n\tfield_16 int,\r\n\tfield_17 text,\r\n\tfield_18 MAP<text, text>,\r\n\tfield_19 text,\r\n\tfield_20 text,\r\n\tfield_21 text,\r\n\tfield_22 int,\r\n\tfield_23 int,\r\n\tfield_24 int,\r\n\tfield_25 text,\r\n\tfield_26 text,\r\n\tfield_27 text,\r\n\tfield_28 text,\r\n\tfield_29 text,\r\n\tPRIMARY KEY (field_1, field_2, field_3)\r\n);\r\n\r\n//Load data on the table (approximativly 100Go of data)\r\n\r\n// Create index\r\nalter table keypace_1.table_1 add indextx text ;\r\n\r\nCREATE CUSTOM INDEX table_index ON keypace_1.table_1 (indextx) USING 'com.stratio.cassandra.lucene.Index' WITH OPTIONS = { 'refresh_seconds' : '1', 'schema' : '{ fields : { field_6 : {type : \"string\", sorted: \"false\"}, field_3 : {type : \"date\", pattern : \"yyyy-MM-dd\"} } }' };\r\n\r\n// The lucene index does not return the correct data\r\n\r\nselect field_1, field_6, field_3 from keypace_1.table_1 WHERE indextx='{filter :{type:\"contains\", field:\"field_6\", values:[\"DC\"]}}';\r\nselect field_1, field_6, field_3 from keypace_1.table_1 WHERE indextx='{filter :{type:\"match\", field:\"field_6\", value:\"DC\"}}';\r\n\r\nWe use Cassandra 2.1.7 with plugin Stratio 2.1.7.1\r\nJDK 1.7.0_45\r\n\r\nThanks,"},"comment":{"url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/comments/129386442","html_url":"https://github.com/Stratio/cassandra-lucene-index/issues/24#issuecomment-129386442","issue_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/24","id":129386442,"user":{"login":"bgrimaud","id":13572808,"avatar_url":"https://avatars.githubusercontent.com/u/13572808?v=3","gravatar_id":"","url":"https://api.github.com/users/bgrimaud","html_url":"https://github.com/bgrimaud","followers_url":"https://api.github.com/users/bgrimaud/followers","following_url":"https://api.github.com/users/bgrimaud/following{/other_user}","gists_url":"https://api.github.com/users/bgrimaud/gists{/gist_id}","starred_url":"https://api.github.com/users/bgrimaud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgrimaud/subscriptions","organizations_url":"https://api.github.com/users/bgrimaud/orgs","repos_url":"https://api.github.com/users/bgrimaud/repos","events_url":"https://api.github.com/users/bgrimaud/events{/privacy}","received_events_url":"https://api.github.com/users/bgrimaud/received_events","type":"User","site_admin":false},"created_at":"2015-08-10T09:50:47Z","updated_at":"2015-08-10T09:50:47Z","body":"It's a good idea. i just create a regular cassandra index over code_evt and perform the query below and i have the same problem :\r\n\r\nselect * from vision_dev.evt WHERE code_evt='DC';\r\n\r\nSo, I think there is another problem."}}