java.sql.SQLException: ERROR 201 (22000): Illegal data. ERROR 201 (22000): Illegal data. Expected length of at least 64 bytes, but had 25

Stack Overflow | user2511142 | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    java.sql.SQLException: ERROR 201 (22000): Illegal data. ERROR 201 (22000): Illegal data. Expected length of at least 64 bytes, but had 25

    Stack Overflow | 9 months ago | user2511142
    java.sql.SQLException: ERROR 201 (22000): Illegal data. ERROR 201 (22000): Illegal data. Expected length of at least 64 bytes, but had 25
  2. 0

    [PHOENIX-2161] Can't change timeout - ASF JIRA

    apache.org | 1 year ago
    java.sql.SQLException: Encountered exception in sub plan execution.
  3. 0

    Re: Delete records

    phoenix-user | 1 year ago | James Taylor
    java.sql.SQLException: ERROR 1027 (42Y86): All columns referenced in a WHERE clause must be available in every index for a table with immutable rows. tableName=some_table
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    How to delete from apache phoenix querying by fields not in every index

    Stack Overflow | 10 months ago | Artur Bartnik
    java.sql.SQLException: ERROR 1027 (42Y86): All columns referenced in a WHERE clause must be available in every index for a table with immutable rows. tableName=STATISTICS
  6. 0

    Aggregate and Group By in Apache Phoenix

    Stack Overflow | 2 years ago | Satya
    java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns not in GROUP BY. ELS_NAME

    Root Cause Analysis

    1. java.sql.SQLException

      ERROR 201 (22000): Illegal data. ERROR 201 (22000): Illegal data. Expected length of at least 64 bytes, but had 25

      at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException()
    2. Phoenix Core
      PhoenixStatement.execute
      1. org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:386)
      2. org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
      3. org.apache.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:131)
      4. org.apache.phoenix.util.ServerUtil.parseServerExceptionOrNull(ServerUtil.java:115)
      5. org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:104)
      6. org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:538)
      7. org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:510)
      8. org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
      9. org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
      10. org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44)
      11. org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:680)
      12. org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:305)
      13. org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:297)
      14. org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
      15. org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:295)
      16. org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1255)
      16 frames
    3. sqlline
      SqlLine.main
      1. sqlline.Commands.execute(Commands.java:822)
      2. sqlline.Commands.sql(Commands.java:732)
      3. sqlline.SqlLine.dispatch(SqlLine.java:808)
      4. sqlline.SqlLine.begin(SqlLine.java:681)
      5. sqlline.SqlLine.start(SqlLine.java:398)
      6. sqlline.SqlLine.main(SqlLine.java:292)
      6 frames