We're using version 4.12 (on cdh 5.12). I issued the CREATE INDEX statement with phoenix-sqlline with all default parameters.
On Fri, Nov 10, 2017 at 2:21 AM, Sergey Soldatov <sergeysolda...@gmail.com> wrote: > Could you provide the version you are using? Do you have autocommit turned > on and have you changed the following properties: > phoenix.mutate.batchSize > phoenix.mutate.maxSize > phoenix.mutate.maxSizeBytes > > Thanks, > Sergey > > If you are using more recent version, than you may consider to > On Thu, Nov 9, 2017 at 5:41 AM, Marcin Januszkiewicz < > januszkiewicz.mar...@gmail.com> wrote: > >> I was trying to create a global index table but it failed out with: >> >> Error: ERROR 730 (LIM02): MutationState size is bigger than maximum >> allowed number of bytes (state=LIM02,code=730) >> java.sql.SQLException: ERROR 730 (LIM02): MutationState size is bigger >> than maximum allowed number of bytes >> at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newE >> xception(SQLExceptionCode.java:489) >> at org.apache.phoenix.exception.SQLExceptionInfo.buildException >> (SQLExceptionInfo.java:150) >> at org.apache.phoenix.execute.MutationState.throwIfTooBig(Mutat >> ionState.java:359) >> at org.apache.phoenix.execute.MutationState.join(MutationState. >> java:447) >> at org.apache.phoenix.compile.MutatingParallelIteratorFactory$ >> 1.close(MutatingParallelIteratorFactory.java:98) >> at org.apache.phoenix.iterate.RoundRobinResultIterator$RoundRob >> inIterator.close(RoundRobinResultIterator.java:298) >> at org.apache.phoenix.iterate.RoundRobinResultIterator.next(Rou >> ndRobinResultIterator.java:105) >> at org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCo >> mpiler.java:821) >> at org.apache.phoenix.compile.DelegateMutationPlan.execute(Dele >> gateMutationPlan.java:31) >> at org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute( >> PostIndexDDLCompiler.java:117) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateD >> ata(ConnectionQueryServicesImpl.java:3360) >> at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaData >> Client.java:1283) >> at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDat >> aClient.java:1595) >> at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(Cre >> ateIndexCompiler.java:85) >> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState >> ment.java:394) >> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState >> ment.java:377) >> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho >> enixStatement.java:376) >> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho >> enixStatement.java:364) >> at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStat >> ement.java:1738) >> at sqlline.Commands.execute(Commands.java:822) >> at sqlline.Commands.sql(Commands.java:732) >> at sqlline.SqlLine.dispatch(SqlLine.java:813) >> at sqlline.SqlLine.begin(SqlLine.java:686) >> at sqlline.SqlLine.start(SqlLine.java:398) >> at sqlline.SqlLine.main(SqlLine.java:291) >> >> Is there a way to predict what max size will be sufficient, or which >> other knobs to turn? >> >> >> -- >> Pozdrawiam, >> Marcin Januszkiewicz >> > >
