phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Parveen Jain <parveenj...@live.com>
Subject Phoenix Create table timeout
Date Thu, 28 Jul 2016 08:49:06 GMT
Hi All,

 Just starting out with Phoenix and facing issues regarding time out.First Timeout I am getting
is while creating table in phoenix which for an existing table in Hbase.


My HBase table has almost 100M rows and split across two nodes having two region servers.
One server is octa core and another is 16 core.I am using only default settings of HBase and
some time out settings for phoenix before starting it out. Can Anyone suggest from where I
can start looking into ?


Regards,

Parveen Jain


Following is the error:

 CREATE TABLE "DATA_FOR_PHOENIX1"(pk VARCHAR PRIMARY KEY,"PARSED_DATA_COLUMN1".NAME0 VARCHAR,"PARSED_DATA_COLUMN1".NAME1
VARCHAR,"PARSED_DATA_COLUMN1".NAME2 VARCHAR,"VARCHAR,"PARSED_DATA_COLUMN1".NAME3 VARCHAR,"PARSED_DATA_COLUMN1".NAME4
VARCHAR,"PARSED_DATA_COLUMN1".NAME5 VARCHAR,"PARSED_DATA_COLUMN1".NAME6 VARCHAR) SALT_BUCKETS=16;

Error: Operation timed out (state=TIM01,code=6000)
java.sql.SQLTimeoutException: Operation timed out
        at org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:332)
        at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
        at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:573)
        at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:562)
        at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:516)
        at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50)
        at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97)
        at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117)
        at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64)
        at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39)
        at org.apache.phoenix.compile.PostDDLCompiler$1.execute(PostDDLCompiler.java:228)
        at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2013)
        at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:787)
        at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
        at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:305)
        at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:297)
        at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
        at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:295)
        at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1255)
        at sqlline.Commands.execute(Commands.java:822)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:808)
        at sqlline.SqlLine.begin(SqlLine.java:681)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)


Mime
View raw message