Number of shards cannot be increased


#1

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


#3

Support for changing the number_of_shards was introduced by CrateDB version 3.2.0, see https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/3.2.0.html.