{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6440","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6440/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6440/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6440/events","html_url":"https://github.com/orientechnologies/orientdb/issues/6440","id":166516187,"number":6440,"title":"Not able to create  SPATIAL ENGINE LUCENE Index","user":{"login":"dhirender-tyagi","id":9677491,"avatar_url":"https://avatars.githubusercontent.com/u/9677491?v=3","gravatar_id":"","url":"https://api.github.com/users/dhirender-tyagi","html_url":"https://github.com/dhirender-tyagi","followers_url":"https://api.github.com/users/dhirender-tyagi/followers","following_url":"https://api.github.com/users/dhirender-tyagi/following{/other_user}","gists_url":"https://api.github.com/users/dhirender-tyagi/gists{/gist_id}","starred_url":"https://api.github.com/users/dhirender-tyagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhirender-tyagi/subscriptions","organizations_url":"https://api.github.com/users/dhirender-tyagi/orgs","repos_url":"https://api.github.com/users/dhirender-tyagi/repos","events_url":"https://api.github.com/users/dhirender-tyagi/events{/privacy}","received_events_url":"https://api.github.com/users/dhirender-tyagi/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/question","name":"question","color":"cc317c"}],"state":"closed","locked":false,"assignee":{"login":"maggiolo00","id":98812,"avatar_url":"https://avatars.githubusercontent.com/u/98812?v=3","gravatar_id":"","url":"https://api.github.com/users/maggiolo00","html_url":"https://github.com/maggiolo00","followers_url":"https://api.github.com/users/maggiolo00/followers","following_url":"https://api.github.com/users/maggiolo00/following{/other_user}","gists_url":"https://api.github.com/users/maggiolo00/gists{/gist_id}","starred_url":"https://api.github.com/users/maggiolo00/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maggiolo00/subscriptions","organizations_url":"https://api.github.com/users/maggiolo00/orgs","repos_url":"https://api.github.com/users/maggiolo00/repos","events_url":"https://api.github.com/users/maggiolo00/events{/privacy}","received_events_url":"https://api.github.com/users/maggiolo00/received_events","type":"User","site_admin":false},"assignees":[{"login":"maggiolo00","id":98812,"avatar_url":"https://avatars.githubusercontent.com/u/98812?v=3","gravatar_id":"","url":"https://api.github.com/users/maggiolo00","html_url":"https://github.com/maggiolo00","followers_url":"https://api.github.com/users/maggiolo00/followers","following_url":"https://api.github.com/users/maggiolo00/following{/other_user}","gists_url":"https://api.github.com/users/maggiolo00/gists{/gist_id}","starred_url":"https://api.github.com/users/maggiolo00/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maggiolo00/subscriptions","organizations_url":"https://api.github.com/users/maggiolo00/orgs","repos_url":"https://api.github.com/users/maggiolo00/repos","events_url":"https://api.github.com/users/maggiolo00/events{/privacy}","received_events_url":"https://api.github.com/users/maggiolo00/received_events","type":"User","site_admin":false}],"milestone":null,"comments":9,"created_at":"2016-07-20T07:38:14Z","updated_at":"2016-07-21T12:49:14Z","closed_at":"2016-07-20T08:30:49Z","body":"I am using orientdb v2.2.3 and java version \"1.8.0_91\"\r\n\r\nI want to create index on longitude and latitude to get nearest locations. So I use this query to create index.\r\n\r\nCREATE INDEX Lead_address.l_lon ON Lead_address(latitude,longitude) SPATIAL ENGINE LUCENE\r\n\r\nBut I got the error:\r\n\r\n'com.orientechnologies.orient.core.index.OIndexException: Index with type SPATIAL and algorithm LUCENE does not exist. DB name=\"XXX\"'"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/234243216","html_url":"https://github.com/orientechnologies/orientdb/issues/6440#issuecomment-234243216","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6440","id":234243216,"user":{"login":"dhirender-tyagi","id":9677491,"avatar_url":"https://avatars.githubusercontent.com/u/9677491?v=3","gravatar_id":"","url":"https://api.github.com/users/dhirender-tyagi","html_url":"https://github.com/dhirender-tyagi","followers_url":"https://api.github.com/users/dhirender-tyagi/followers","following_url":"https://api.github.com/users/dhirender-tyagi/following{/other_user}","gists_url":"https://api.github.com/users/dhirender-tyagi/gists{/gist_id}","starred_url":"https://api.github.com/users/dhirender-tyagi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhirender-tyagi/subscriptions","organizations_url":"https://api.github.com/users/dhirender-tyagi/orgs","repos_url":"https://api.github.com/users/dhirender-tyagi/repos","events_url":"https://api.github.com/users/dhirender-tyagi/events{/privacy}","received_events_url":"https://api.github.com/users/dhirender-tyagi/received_events","type":"User","site_admin":false},"created_at":"2016-07-21T12:49:14Z","updated_at":"2016-07-21T12:49:14Z","body":"Hi @maggiolo00 \r\n\r\nI port data from mysql using ETL. So there data in varchar format. So can you tell me that can I change varchar to Long at ETL process or have to write a script?.."}}
{"actor":{"display_login":"dhirender-tyagi"}}