{"action":"created","issue":{"url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/790","repository_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc","labels_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/790/labels{/name}","comments_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/790/comments","events_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/790/events","html_url":"https://github.com/jprante/elasticsearch-jdbc/issues/790","id":143674530,"number":790,"title":"$metrics.lastexecutionstart is null ","user":{"login":"jackieit","id":3883223,"avatar_url":"https://avatars.githubusercontent.com/u/3883223?v=3","gravatar_id":"","url":"https://api.github.com/users/jackieit","html_url":"https://github.com/jackieit","followers_url":"https://api.github.com/users/jackieit/followers","following_url":"https://api.github.com/users/jackieit/following{/other_user}","gists_url":"https://api.github.com/users/jackieit/gists{/gist_id}","starred_url":"https://api.github.com/users/jackieit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jackieit/subscriptions","organizations_url":"https://api.github.com/users/jackieit/orgs","repos_url":"https://api.github.com/users/jackieit/repos","events_url":"https://api.github.com/users/jackieit/events{/privacy}","received_events_url":"https://api.github.com/users/jackieit/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-03-26T07:41:56Z","updated_at":"2016-05-15T03:15:35Z","closed_at":null,"body":"importer version 2.2.0.1 and elasticSearch Version 2.2.1\r\nHi, I used this json file \r\n \r\n{\r\n\r\n    \"type\" : \"JDBC\",\r\n    \"jdbc\" : {\r\n        \"strategy\" : \"standard\",\r\n        \"locale\" : \"zh_CN\",\r\n        \"timezone\": \"Asia/Shanghai\",\r\n        \"url\" : \"jdbc:mysql://127.0.0.1:3306/pinpai361\",\r\n        \"user\" : \"root\",\r\n        \"password\" : \"\",\r\n        \"sql\" : [\r\n\t\t\t{\r\n        \t\t\"statement\":\"select  *,item_id as _id, from \\\"pp_goods\\\" where \\\"updated_at\\\" > ? \",\r\n                 \"parameter\" : [\"$metrics.lastexecutionstart\"]\r\n\t\t\t}\r\n        ],\r\n        \"index\" : \"goods\",\r\n        \"type\" : \"wfhao\",\r\n        \"elasticsearch\":\r\n        {\r\n                \"cluster\":\"wfhao-app\",\r\n                \"host\":\"127.0.0.1\",\r\n                \"port\":9300\r\n        }\r\n        \r\n    }\r\n}\r\n \r\nbut when i see the log it shows \r\n com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from \"pp_goods\" where \"updated_at\" > null' at line 1\r\njava.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from \"pp_goods\" where \"updated_at\" > null' at line 1\r\n\tat org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.fetch(StandardSource.java:631) ~[elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.fetch(StandardContext.java:188) [elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:163) [elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat org.xbib.tools.JDBCImporter.process(JDBCImporter.java:179) [elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:165) [elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:51) [elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:50) [elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:16) [elasticsearch-jdbc-2.2.0.0-uberjar.jar:?]\r\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_77]\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_77]\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_77]\r\n\tat java.lang.Thread.run(Thread.java:745) [?:1.8.0_77]\r\n\r\nI know I get the $metrics.lastexecutionstart null value "},"comment":{"url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/comments/219263786","html_url":"https://github.com/jprante/elasticsearch-jdbc/issues/790#issuecomment-219263786","issue_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/790","id":219263786,"user":{"login":"dengshilong","id":1704820,"avatar_url":"https://avatars.githubusercontent.com/u/1704820?v=3","gravatar_id":"","url":"https://api.github.com/users/dengshilong","html_url":"https://github.com/dengshilong","followers_url":"https://api.github.com/users/dengshilong/followers","following_url":"https://api.github.com/users/dengshilong/following{/other_user}","gists_url":"https://api.github.com/users/dengshilong/gists{/gist_id}","starred_url":"https://api.github.com/users/dengshilong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dengshilong/subscriptions","organizations_url":"https://api.github.com/users/dengshilong/orgs","repos_url":"https://api.github.com/users/dengshilong/repos","events_url":"https://api.github.com/users/dengshilong/events{/privacy}","received_events_url":"https://api.github.com/users/dengshilong/received_events","type":"User","site_admin":false},"created_at":"2016-05-15T03:15:35Z","updated_at":"2016-05-15T03:15:35Z","body":"* Implementing incremental index can find [here](https://github.com/jprante/elasticsearch-jdbc#how-to-select-incremental-data-from-a-table)\r\n* What do you mean 'what the type of \"updated_at\"?'"}}