phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ahmed Hussien <aahussi...@gmail.com>
Subject Re: error while selecting
Date Mon, 08 Sep 2014 05:24:11 GMT
OK


/*******************************Statment**********************************************/

CREATE TABLE IF NOT EXISTS "Su"("rowId" char(103) not null primary key,
"Rates"."NbSearchApp" VARCHAR , "Rates"."NbSearchCur" VARCHAR ,
"Rates"."NbSearchApp" VARCHAR );


/*********************************************Error***********************************************/

14/09/08 08:15:51 WARN ipc.CoprocessorRpcChannel: Call failed on IOException
org.apache.hadoop.hbase.DoNotRetryIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: Su: 3
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
    at
org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:95)
    at
org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:79)
    at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:284)
    at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1512)
    at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:87)
    at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:84)
    at
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:114)
    at
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:90)
    at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:90)
    at
org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:51)
    at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$Stub.createTable(MetaDataProtos.java:6715)
    at
org.apache.phoenix.query.ConnectionQueryServicesImpl$4.call(ConnectionQueryServicesImpl.java:1101)
    at
org.apache.phoenix.query.ConnectionQueryServicesImpl$4.call(ConnectionQueryServicesImpl.java:1090)
    at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1527)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException:
org.apache.hadoop.hbase.DoNotRetryIOException: Su: 3
    at
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:77)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:833)
    at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:6581)
    at
org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:5587)
    at
org.apache.hadoop.hbase.regionserver.HRegionServer.execServiceOnRegion(HRegionServer.java:3310)
    at
org.apache.hadoop.hbase.regionserver.HRegionServer.execService(HRegionServer.java:3292)
    at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29501)
    at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2012)
    at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:98)
    at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.consumerLoop(SimpleRpcScheduler.java:168)
    at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.access$000(SimpleRpcScheduler.java:39)
    at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler$1.run(SimpleRpcScheduler.java:111)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 3
    at org.apache.phoenix.schema.PTableImpl.init(PTableImpl.java:284)
    at org.apache.phoenix.schema.PTableImpl.<init>(PTableImpl.java:217)
    at org.apache.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:210)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:657)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:415)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:704)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:782)
    ... 11 more

    at org.apache.hadoop.hbase.ipc.RpcClient.call(RpcClient.java:1450)
    at
org.apache.hadoop.hbase.ipc.RpcClient.callBlockingMethod(RpcClient.java:1654)
    at
org.apache.hadoop.hbase.ipc.RpcClient$BlockingRpcChannelImplementation.callBlockingMethod(RpcClient.java:1712)
    at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.execService(ClientProtos.java:29924)
    at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1508)
    ... 14 more
14/09/08 08:15:51 WARN client.HTable: Error calling coprocessor service
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService for
row \x00\x00Su
java.util.concurrent.ExecutionException:
org.apache.hadoop.hbase.DoNotRetryIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: Su: 3
    at java.util.concurrent.FutureTask.report(FutureTask.java:122)
    at java.util.concurrent.FutureTask.get(FutureTask.java:192)
    at
org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1539)
    at
org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1497)
    at
org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:958)
    at
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1089)
    at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1156)
    at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422)
    at
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
    at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
    at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:919)
    at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
    at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
    at sqlline.SqlLine.dispatch(SqlLine.java:821)
    at sqlline.SqlLine.begin(SqlLine.java:699)
    at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
    at sqlline.SqlLine.main(SqlLine.java:424)
Caused by: org.apache.hadoop.hbase.DoNotRetryIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: Su: 3
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
    at
org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:95)
    at
org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:79)
    at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:284)
    at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1512)
    at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:87)
    at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:84)
    at
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:114)
    at
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:90)
    at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:90)
    at
org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:51)
    at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$Stub.createTable(MetaDataProtos.java:6715)
    at
org.apache.phoenix.query.ConnectionQueryServicesImpl$4.call(ConnectionQueryServicesImpl.java:1101)
    at
org.apache.phoenix.query.ConnectionQueryServicesImpl$4.call(ConnectionQueryServicesImpl.java:1090)
    at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1527)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException:
org.apache.hadoop.hbase.DoNotRetryIOException: Su: 3
    at
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:77)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:833)
    at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:6581)
    at
org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:5587)
    at
org.apache.hadoop.hbase.regionserver.HRegionServer.execServiceOnRegion(HRegionServer.java:3310)
    at
org.apache.hadoop.hbase.regionserver.HRegionServer.execService(HRegionServer.java:3292)
    at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29501)
    at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2012)
    at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:98)
    at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.consumerLoop(SimpleRpcScheduler.java:168)
    at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.access$000(SimpleRpcScheduler.java:39)
    at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler$1.run(SimpleRpcScheduler.java:111)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 3
    at org.apache.phoenix.schema.PTableImpl.init(PTableImpl.java:284)
    at org.apache.phoenix.schema.PTableImpl.<init>(PTableImpl.java:217)
    at org.apache.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:210)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:657)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:415)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:704)
    at
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:782)
    ... 11 more

    at org.apache.hadoop.hbase.ipc.RpcClient.call(RpcClient.java:1450)
    at
org.apache.hadoop.hbase.ipc.RpcClient.callBlockingMethod(RpcClient.java:1654)
    at
org.apache.hadoop.hbase.ipc.RpcClient$BlockingRpcChannelImplementation.callBlockingMethod(RpcClient.java:1712)
    at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.execService(ClientProtos.java:29924)
    at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1508)
    ... 14 more
Error: org.apache.hadoop.hbase.DoNotRetryIOException: Su: 3
(state=08000,code=101)


/**************************   From HBASE SHELL
***********************************/

hbase(main):004:0> describe 'Su'
DESCRIPTION
ENABLED
 'Su', {TABLE_ATTRIBUTES => {coprocessor$1 => '|org.
true
 apache.phoenix.coprocessor.ScanRegionObserver|1|',

 coprocessor$2 =>
'|org.apache.phoenix.coprocessor.U
 ngroupedAggregateRegionObserver|1|',
coprocessor$3
 =>
'|org.apache.phoenix.coprocessor.GroupedAggregat
 eRegionObserver|1|', coprocessor$4 =>
'|org.apache.
 phoenix.coprocessor.ServerCachingEndpointImpl|1|',

 coprocessor$5 =>
'|org.apache.phoenix.hbase.index.I
 ndexer|1073741823|org.apache.hadoop.hbase.index.cod

 ec.class=org.apache.phoenix.index.PhoenixIndexCodec

 ,index.builder=org.apache.phoenix.index.PhoenixInde

 xBuilder'}, {NAME => 'Rates', BLOOMFILTER =>
'ROW',
  VERSIONS => '1', IN_MEMORY => 'false',
KEEP_DELETE
 D_CELLS => 'true', DATA_BLOCK_ENCODING =>
'FAST_DIF
 F', TTL => 'FOREVER', COMPRESSION => 'NONE',
MIN_VE
 RSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE =>
'
 65536', REPLICATION_SCOPE =>
'0'}
1 row(s) in 0.0980 seconds

/*********************************************************/

On Sun, Sep 7, 2014 at 7:34 PM, Nicolas Maillard <nmaillard@hortonworks.com>
wrote:

> Hello Ahmed
>
> Please do share the error log.
> The issue is creating a table with the same column name in the same column
> family and you get an error, however the table and column family are
> created just not the column  name, and it would make more sense to have all
> or nothing.
>
> regards
>
> On Sun, Sep 7, 2014 at 10:40 AM, Ahmed Hussien <aahussien6@gmail.com>
> wrote:
>
> > I tried to create a table with a duplicated column name just for testing
> > something using phoenix,
> > I got an exception which is fine and OK, but on the other hand I went to
> > HBASE and used the command list, and I found the table existing with the
> > family i used.
> >
> > i'm using phoenix 4.
> >
> > The problem is: this could affect the create table if not exist command,
> > because when I tried to fix it I got an exception also.
> > please check this Issue.
> > I can send you the errors if you want.
> > Ahmed
> >
>
> --
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity to
> which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
>



-- 
Thanks and Best Regards
-------
Eng. Ahmed Hussien
+20101273114

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message