{"action":"created","issue":{"url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/28","labels_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/28/comments","events_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/28/events","html_url":"https://github.com/Stratio/cassandra-lucene-index/issues/28","id":98945295,"number":28,"title":"Error while creating index","user":{"login":"jsebrien","id":4710626,"avatar_url":"https://avatars.githubusercontent.com/u/4710626?v=3","gravatar_id":"","url":"https://api.github.com/users/jsebrien","html_url":"https://github.com/jsebrien","followers_url":"https://api.github.com/users/jsebrien/followers","following_url":"https://api.github.com/users/jsebrien/following{/other_user}","gists_url":"https://api.github.com/users/jsebrien/gists{/gist_id}","starred_url":"https://api.github.com/users/jsebrien/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsebrien/subscriptions","organizations_url":"https://api.github.com/users/jsebrien/orgs","repos_url":"https://api.github.com/users/jsebrien/repos","events_url":"https://api.github.com/users/jsebrien/events{/privacy}","received_events_url":"https://api.github.com/users/jsebrien/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-08-04T11:19:23Z","updated_at":"2015-11-03T16:17:41Z","closed_at":"2015-08-04T14:14:40Z","body":"I created this table:\r\n\r\nCREATE TABLE IF NOT EXISTS flat3 (\r\n    id uuid,\r\n    title text,\r\n    description text,\r\n    creationDate timestamp,\r\n    lastModificationDate timestamp,\r\n    lucene TEXT,\r\n    PRIMARY KEY(id)\r\n);\r\n\r\nAnd I would like to create the following index (I'm using the 2.1.8.1 version):\r\n\r\nCREATE CUSTOM INDEX flat3_index ON flat3 (lucene)\r\nUSING 'com.stratio.cassandra.lucene.Index'\r\nWITH OPTIONS = {\r\n    'refresh_seconds' : '10',\r\n    'schema' : '{\r\n        fields : {\r\n            id    : {type : \"uuid\"},\r\n            title  : {type : \"text\"},\r\n            description  : {type : \"text\"},\r\n            lastModificationDate  : {type : \"date\"}\r\n        }\r\n    }'\r\n};\r\n\r\nBut I get the following error:\r\n\r\nErrorMessage code=2300 [Query invalid because of configuration issue] message=\"Error while validating Lucene index options: 'schema' is invalid : No column definition lastModificationDate for mapper lastModificationDate\"\r\n\r\nAny idea?\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/comments/153402601","html_url":"https://github.com/Stratio/cassandra-lucene-index/issues/28#issuecomment-153402601","issue_url":"https://api.github.com/repos/Stratio/cassandra-lucene-index/issues/28","id":153402601,"user":{"login":"minauser","id":13946225,"avatar_url":"https://avatars.githubusercontent.com/u/13946225?v=3","gravatar_id":"","url":"https://api.github.com/users/minauser","html_url":"https://github.com/minauser","followers_url":"https://api.github.com/users/minauser/followers","following_url":"https://api.github.com/users/minauser/following{/other_user}","gists_url":"https://api.github.com/users/minauser/gists{/gist_id}","starred_url":"https://api.github.com/users/minauser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/minauser/subscriptions","organizations_url":"https://api.github.com/users/minauser/orgs","repos_url":"https://api.github.com/users/minauser/repos","events_url":"https://api.github.com/users/minauser/events{/privacy}","received_events_url":"https://api.github.com/users/minauser/received_events","type":"User","site_admin":false},"created_at":"2015-11-03T16:17:41Z","updated_at":"2015-11-03T16:17:41Z","body":"Hi\r\n\r\nI am trying to do a case-insensitive search in stratio/lucene/cassandra.\r\n\r\nTherefore, I created the index as below:\r\n\r\nCREATE CUSTOM INDEX my_index ON my_table (lucene)\r\nUSING 'com.stratio.cassandra.lucene.Index.RowIndex'\r\nWITH OPTIONS = {\r\n'refresh_seconds' : '10',\r\n'schema' : '{\r\nfields : {\r\nid : {type : \"uuid\"},\r\ntitle : {type : \"string\", case_sensitive: false}\r\n}\r\n}'\r\n};\r\n\r\nHowever, if in my test instead of \"TestTitle\", I use \"testTitle\", it returns nothing.\r\n\r\nI really appreciate if I get the information on how I can do a case_insensitive search."}}