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 | 5 months ago
  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 | 5 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 | 12 months ago
    java.sql.SQLException: Encountered exception in sub plan execution.
  3. 0

    Re: Delete records

    phoenix-user | 10 months 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 | 6 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 | 1 year ago | Satya
    java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns not in GROUP BY. ELS_NAME

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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