org.apache.phoenix.schema.ReadOnlyTableException: ERROR 505 (42000): Table is read only.

Stack Overflow | Adam Reith | 4 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

    Create view in Apache Phoenix: Error 505

    Stack Overflow | 4 months ago | Adam Reith
    org.apache.phoenix.schema.ReadOnlyTableException: ERROR 505 (42000): Table is read only.

    Root Cause Analysis

    1. org.apache.phoenix.schema.ReadOnlyTableException

      ERROR 505 (42000): Table is read only.

      at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated()
    2. Phoenix Core
      PhoenixStatement.execute
      1. org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:815)
      2. org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1174)
      3. org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1974)
      4. org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:770)
      5. org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
      6. org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:305)
      7. org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:297)
      8. org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
      9. org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:295)
      10. org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1255)
      10 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