{"action":"created","issue":{"url":"https://api.github.com/repos/crate/crate/issues/2337","labels_url":"https://api.github.com/repos/crate/crate/issues/2337/labels{/name}","comments_url":"https://api.github.com/repos/crate/crate/issues/2337/comments","events_url":"https://api.github.com/repos/crate/crate/issues/2337/events","html_url":"https://github.com/crate/crate/issues/2337","id":96156217,"number":2337,"title":"Problem with column names","user":{"login":"joergrech","id":1006443,"avatar_url":"https://avatars.githubusercontent.com/u/1006443?v=3","gravatar_id":"","url":"https://api.github.com/users/joergrech","html_url":"https://github.com/joergrech","followers_url":"https://api.github.com/users/joergrech/followers","following_url":"https://api.github.com/users/joergrech/following{/other_user}","gists_url":"https://api.github.com/users/joergrech/gists{/gist_id}","starred_url":"https://api.github.com/users/joergrech/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joergrech/subscriptions","organizations_url":"https://api.github.com/users/joergrech/orgs","repos_url":"https://api.github.com/users/joergrech/repos","events_url":"https://api.github.com/users/joergrech/events{/privacy}","received_events_url":"https://api.github.com/users/joergrech/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-07-20T20:47:50Z","updated_at":"2015-07-24T13:42:30Z","closed_at":"2015-07-24T13:42:30Z","body":"I try to select data in Crate using the Java client (in groovy) and get the following error. Note that the Exception mentioned a changed column name \"_scraperun\" with a small \"r\".\r\n\r\nquery: SELECT * FROM profile WHERE _scrapeRun=5 LIMIT 2\r\n\r\nCaught: SQLActionException{errorCode=4043, status=NOT_FOUND, stackTrace='io.crate.exceptions.ColumnUnknownException: Column _scraperun unknown\r\n\tat io.crate.analyze.relations.FullQualifedNameFieldProvider.resolveField(FullQualifedNameFieldProvider.java:125)\r\n\tat io.crate.analyze.relations.FullQualifedNameFieldProvider.resolveField(FullQualifedNameFieldProvider.java:51)\r\n\tat io.crate.analyze.expressions.ExpressionAnalyzer$InnerExpressionAnalyzer.visitQualifiedNameReference(ExpressionAnalyzer.java:736)\r\n\tat io.crate.analyze.expressions.ExpressionAnalyzer$InnerExpressionAnalyzer.visitQualifiedNameReference(ExpressionAnalyzer.java:392)\r\n\tat io.crate.sql.tree.QualifiedNameReference.accept(QualifiedNameReference.java:49)\r\n\tat io.crate.sql.tree.AstVisitor.process(AstVisitor.java:31)\r\n\tat io.crate.analyze.expressions.ExpressionAnalyzer$InnerExpressionAnalyzer.visitComparisonExpression(ExpressionAnalyzer.java:589)\r\n\tat io.crate.analyze.expressions.ExpressionAnalyzer$InnerExpressionAnalyzer.visitComparisonExpression(ExpressionAnalyzer.java:392)\r\n\tat io.crate.sql.tree.ComparisonExpression.accept(ComparisonExpression.java:108)\r\n\tat io.crate.sql.tree.AstVisitor.process(AstVisitor.java:31)\r\n\tat io.crate.analyze.expressions.ExpressionAnalyzer.convert(ExpressionAnalyzer.java:135)\r\n\tat io.crate.analyze.relations.RelationAnalyzer.analyzeWhere(RelationAnalyzer.java:248)\r\n\tat io.crate.analyze.relations.RelationAnalyzer.visitQuerySpecification(RelationAnalyzer.java:87)\r\n\tat io.crate.analyze.relations.RelationAnalyzer.visitQuerySpecification(RelationAnalyzer.java:47)\r\n\tat io.crate.sql.tree.QuerySpecification.accept(QuerySpecification.java:116)\r\n\tat io.crate.sql.tree.AstVisitor.process(AstVisitor.java:31)\r\n\tat io.crate.analyze.relations.RelationAnalyzer.analyze(RelationAnalyzer.java:61)\r\n\tat io.crate.analyze.relations.RelationAnalyzer.analyze(RelationAnalyzer.java:65)\r\n\tat io.crate.analyze.SelectStatementAnalyzer.visitQuery(SelectStatementAnalyzer.java:44)\r\n\tat io.crate.analyze.SelectStatementAnalyzer.visitQuery(SelectStatementAnalyzer.java:31)\r\n\tat io.crate.sql.tree.Query.accept(Query.java:89)\r\n\tat io.crate.sql.tree.AstVisitor.process(AstVisitor.java:31)\r\n\tat io.crate.analyze.Analyzer$AnalyzerDispatcher.visitQuery(Analyzer.java:100)\r\n\tat io.crate.analyze.Analyzer$AnalyzerDispatcher.visitQuery(Analyzer.java:43)\r\n\tat io.crate.sql.tree.Query.accept(Query.java:89)\r\n\tat io.crate.sql.tree.AstVisitor.process(AstVisitor.java:31)\r\n\tat io.crate.analyze.Analyzer.analyze(Analyzer.java:37)\r\n\tat io.crate.action.sql.TransportSQLAction.getAnalysis(TransportSQLAction.java:73)\r\n\tat io.crate.action.sql.TransportSQLAction.getAnalysis(TransportSQLAction.java:53)\r\n\tat io.crate.action.sql.TransportBaseSQLAction.doExecute(TransportBaseSQLAction.java:185)\r\n\tat io.crate.action.sql.TransportBaseSQLAction.doExecute(TransportBaseSQLAction.java:74)\r\n\tat org.elasticsearch.action.support.TransportAction.execute(TransportAction.java:75)\r\n\tat io.crate.action.sql.TransportSQLAction$TransportHandler.messageReceived(TransportSQLAction.java:136)\r\n\tat io.crate.action.sql.TransportSQLAction$TransportHandler.messageReceived(TransportSQLAction.java:124)\r\n\tat org.elasticsearch.transport.netty.MessageChannelHandler.handleRequest(MessageChannelHandler.java:217)\r\n\tat org.elasticsearch.transport.netty.MessageChannelHandler.messageReceived(MessageChannelHandler.java:111)\r\n\tat org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)\r\n\tat org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\n\tat org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)\r\n\tat org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)\r\n\tat org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462)\r\n\tat org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443)\r\n\tat org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303)\r\n\tat org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)\r\n\tat org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\n\tat org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)\r\n\tat org.elasticsearch.common.netty.OpenChannelsHandler.handleUpstream(OpenChannelsHandler.java:96)\r\n\tat org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\n\tat org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)\r\n\tat org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)\r\n\tat org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)\r\n\tat org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)\r\n\tat org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:108)\r\n\tat org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:318)\r\n\tat org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:89)\r\n\tat org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)\r\n\tat org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)\r\n\tat org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\n'}\r\n\r\nBtw. how can I change the column name? The following SQL does not work:\r\n\r\nALTER TABLE profile RENAME COLUMN \"_scrapeRun\" TO \"_scraperun\";\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/24669901-problem-with-column-names?utm_campaign=plugin&utm_content=tracker%2F505659&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F505659&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/crate/crate/issues/comments/124524865","html_url":"https://github.com/crate/crate/issues/2337#issuecomment-124524865","issue_url":"https://api.github.com/repos/crate/crate/issues/2337","id":124524865,"user":{"login":"dobe","id":48020,"avatar_url":"https://avatars.githubusercontent.com/u/48020?v=3","gravatar_id":"","url":"https://api.github.com/users/dobe","html_url":"https://github.com/dobe","followers_url":"https://api.github.com/users/dobe/followers","following_url":"https://api.github.com/users/dobe/following{/other_user}","gists_url":"https://api.github.com/users/dobe/gists{/gist_id}","starred_url":"https://api.github.com/users/dobe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dobe/subscriptions","organizations_url":"https://api.github.com/users/dobe/orgs","repos_url":"https://api.github.com/users/dobe/repos","events_url":"https://api.github.com/users/dobe/events{/privacy}","received_events_url":"https://api.github.com/users/dobe/received_events","type":"User","site_admin":false},"created_at":"2015-07-24T13:42:30Z","updated_at":"2015-07-24T13:42:30Z","body":"i am closing this issue, since it seems to be related to quoting. we can re-open if that is not the case"}}