Hey! I can’t seems to increase number of shards (from your docs)
SQLActionException: 400 Bad Request 4000 SQLParseException: Invalid property “number_of_shards” passed to [ALTER | CREATE] TABLE statement
at io.crate.exceptions.SQLExceptions.esToCrateException(SQLExceptions.java:183)
at io.crate.exceptions.SQLExceptions.createSQLActionException(SQLExceptions.java:124)
at io.crate.action.sql.Session.bind(Session.java:304)
at io.crate.rest.action.SqlHttpHandler.executeSimpleRequest(SqlHttpHandler.java:253)
at io.crate.rest.action.SqlHttpHandler.handleSQLRequest(SqlHttpHandler.java:214)
at io.crate.rest.action.SqlHttpHandler.channelRead0(SqlHttpHandler.java:119)
at io.crate.rest.action.SqlHttpHandler.channelRead0(SqlHttpHandler.java:84)
at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
at org.elasticsearch.http.netty4.pipelining.HttpPipeliningHandler.channelRead(HttpPipeliningHandler.java:68)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
Overall error:
Error!
SQLActionException[SQLParseException: Invalid property “number_of_shards” passed to [ALTER | CREATE] TABLE statement]
SQL: Alter table TABLENAME (number_of_shards =5);
Version:
3.1.5