phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob Dole <>
Subject add a snapshotted phoenix table
Date Wed, 11 Mar 2015 21:33:17 GMT
I have taken a hbase snapshot of an existing phoenix table. I then performed a clone_snapshot
and would like to make phoenix aware of the new table.
I tried issueing the same CREATE statement over the cloned table and the command seems to
hang and eventually throws the below exception:
Error:  (state=08000,code=101)
        at org.apache.phoenix.util.ServerUtil.parseServerException(
        at org.apache.phoenix.iterate.BaseResultIterators.getIterators(
        at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(
        at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(
        at org.apache.phoenix.compile.PostDDLCompiler$1.execute(
        at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(
        at org.apache.phoenix.schema.MetaDataClient.createTable(
        at org.apache.phoenix.compile.CreateTableCompiler$2.execute(
        at org.apache.phoenix.jdbc.PhoenixStatement$
        at org.apache.phoenix.jdbc.PhoenixStatement$
        at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(
        at org.apache.phoenix.jdbc.PhoenixStatement.execute(
        at sqlline.SqlLine$Commands.execute(
        at sqlline.SqlLine$Commands.sql(
        at sqlline.SqlLine.dispatch(
        at sqlline.SqlLine.runCommands(
        at sqlline.SqlLine$
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
        at java.lang.reflect.Method.invoke(
        at sqlline.SqlLine$ReflectiveCommandHandler.execute(
        at sqlline.SqlLine.dispatch(
        at sqlline.SqlLine.initArgs(
        at sqlline.SqlLine.begin(
        at sqlline.SqlLine.mainWithInputRedirection(
        at sqlline.SqlLine.main(
Caused by: java.util.concurrent.TimeoutException
        at java.util.concurrent.FutureTask.get(
        at org.apache.phoenix.iterate.BaseResultIterators.getIterators(
        ... 29 more

However, even with the above error, !table in sqlline will show the newly created table and
I can invoke queries against. I tried creating a view and the CREATE VIEW command completed
without errors however I'd rather use tables.
Is there a proper way to make phoenix aware of an existing phoenix table?

View raw message