phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob Dole <>
Subject Re: add a snapshotted phoenix table
Date Thu, 12 Mar 2015 07:10:04 GMT
It's pretty tiny, only has 1528725 rows.
That column probably already exists since it's a clone of an existing phoenix table... :(

      From: Tulasi Paradarami <>
 To: "" <>; Bob Dole <>

 Sent: Wednesday, March 11, 2015 9:51 PM
 Subject: Re: add a snapshotted phoenix table
How big is the table? I think, its taking so long to create the table because phoenix creates
a new column "_0" for each row with null values. So, when it failed the upserts were only
partially complete but table is available for querying. Since, view doesnt perform this upsert,
its faster to create & query. 

On Wednesday, March 11, 2015, Bob Dole <> wrote:

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