Re: Error at starting Phoenix shell with HBase

[Josh Elser]

You might consider providing more information instead of sending new 
messages without any additional context. What you have provided is not 
sufficient for anyone but a wizard to debug :)


Increase the log4j level. Post your HBase logs somewhere. Post the 
Phoenix client logs somewhere. Please make a larger effort instead of 
just spamming the list.


Chetan Khatri wrote:

Hello Guys,

I am still stuck to start Phoenix with Pseudo Hadoop + Hive + Spark
cluster, can anybody help me please.

Thanks.

On Tue, Jan 17, 2017 at 2:03 AM, Chetan Khatri
mailto:chetan.opensou...@gmail.com>> wrote:

Hello Josh,

Thank you for reply, As you suggested.

1) phoenix-4.8.2-HBase-1.2-server.jar at HBase/lib
*Checked by :* bin/hbase classpath | grep 'phoenix'


*2) Errors*
*
*
*

​
3) Nothing can be found at HBase RegionServer logs*



How can above problem can be resolved ?

Thanks.
​​


On Mon, Jan 16, 2017 at 10:22 PM, Josh Elser mailto:els...@apache.org>> wrote:

Did you check the RegionServers logs I asked in the last message?

Chetan Khatri wrote:

Any updates for the above error guys ?


On Fri, Jan 13, 2017 at 9:35 PM, Josh Elser
mailto:els...@apache.org>
>> wrote:

 (-cc dev@phoenix)

 phoenix-4.8.2-HBase-1.2-server.jar in the top-level
binary tarball
 of Apache Phoenix 4.8.0 is the jar which is meant to be
deployed to
 all HBase's classpath.

 I would check the RegionServer logs -- I'm guessing
that it never
 started correctly or failed. The error message is
saying that
 certain regions in the system were never assigned to a
RegionServer
 which only happens in exceptional cases.

 Chetan Khatri wrote:

 Hello Community,

 I have installed and configured Apache Phoenix on
Single Node
 Ubuntu 16.04
 machine:
 - Hadoop 2.7
 - HBase 1.2.4
 - Phoenix -4.8.2-HBase-1.2

 Copied phoenix-core-4.8.2-HBase-1.2.jar to
hbase/lib and confirmed
 with bin/hbase classpath | grep 'phoenix' and I am
using embedded
 zookeeper, so my hbase-site.xml looks like below:



hbase.rootdir
file:///home/hduser/hbase



 I am able to read / write to HBase from shell and
Apache Spark.

 *Errors while accessing with **sqlline**:*


 1) bin/sqlline.py localhost:2181

 Error:

 1. Command made process hang.
 2.
 Error: ERROR 1102 (XCL02): Cannot get all table
regions.
 (state=XCL02,code=1102)
 java.sql.SQLException: ERROR 1102 (XCL02): Cannot
get all table
 regions.
 at


org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:455)
 at


org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
 at


org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:546)
 at


org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
 at


org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1068)
 at


org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1388)
 at


org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2298)
 at


org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:940)
 at


org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:193)
 at


org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:344)
 at


org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:332)
 at
org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
 at


org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:331)
 at


org

Re: Error at starting Phoenix shell with HBase

[Josh Elser]

Did you check the RegionServers logs I asked in the last message?

Chetan Khatri wrote:

Any updates for the above error guys ?


On Fri, Jan 13, 2017 at 9:35 PM, Josh Elser mailto:els...@apache.org>> wrote:

(-cc dev@phoenix)

phoenix-4.8.2-HBase-1.2-server.jar in the top-level binary tarball
of Apache Phoenix 4.8.0 is the jar which is meant to be deployed to
all HBase's classpath.

I would check the RegionServer logs -- I'm guessing that it never
started correctly or failed. The error message is saying that
certain regions in the system were never assigned to a RegionServer
which only happens in exceptional cases.

Chetan Khatri wrote:

Hello Community,

I have installed and configured Apache Phoenix on Single Node
Ubuntu 16.04
machine:
- Hadoop 2.7
- HBase 1.2.4
- Phoenix -4.8.2-HBase-1.2

Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
with bin/hbase classpath | grep 'phoenix' and I am using embedded
zookeeper, so my hbase-site.xml looks like below:



hbase.rootdir
file:///home/hduser/hbase



I am able to read / write to HBase from shell and Apache Spark.

*Errors while accessing with **sqlline**:*


1) bin/sqlline.py localhost:2181

Error:

1. Command made process hang.
2.
Error: ERROR 1102 (XCL02): Cannot get all table regions.
(state=XCL02,code=1102)
java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table
regions.
at

org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:455)
at

org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
at

org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:546)
at

org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
at

org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1068)
at

org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1388)
at

org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2298)
at

org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:940)
at

org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:193)
at

org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:344)
at

org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:332)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at

org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:331)
at

org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1423)
at

org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2352)
at

org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2291)
at

org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
at

org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2291)
at

org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:232)
at

org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:147)
at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
at
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
at sqlline.Commands.connect(Commands.java:1064)
at sqlline.Commands.connect(Commands.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at

sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:803)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:656)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Caused by:
org.apache.hadoop.hbase.client.NoServerForRegionException: No
server address 

Re: Error at starting Phoenix shell with HBase

[Chetan Khatri]

Any updates for the above error guys ?


On Fri, Jan 13, 2017 at 9:35 PM, Josh Elser  wrote:

> (-cc dev@phoenix)
>
> phoenix-4.8.2-HBase-1.2-server.jar in the top-level binary tarball of
> Apache Phoenix 4.8.0 is the jar which is meant to be deployed to all
> HBase's classpath.
>
> I would check the RegionServer logs -- I'm guessing that it never started
> correctly or failed. The error message is saying that certain regions in
> the system were never assigned to a RegionServer which only happens in
> exceptional cases.
>
> Chetan Khatri wrote:
>
>> Hello Community,
>>
>> I have installed and configured Apache Phoenix on Single Node Ubuntu 16.04
>> machine:
>> - Hadoop 2.7
>> - HBase 1.2.4
>> - Phoenix -4.8.2-HBase-1.2
>>
>> Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
>> with bin/hbase classpath | grep 'phoenix' and I am using embedded
>> zookeeper, so my hbase-site.xml looks like below:
>>
>> 
>>   
>>  hbase.rootdir
>>  file:///home/hduser/hbase
>>
>> 
>>
>> I am able to read / write to HBase from shell and Apache Spark.
>>
>> *Errors while accessing with **sqlline**:*
>>
>>
>> 1) bin/sqlline.py localhost:2181
>>
>> Error:
>>
>> 1. Command made process hang.
>> 2.
>> Error: ERROR 1102 (XCL02): Cannot get all table regions.
>> (state=XCL02,code=1102)
>> java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions.
>> at
>> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newE
>> xception(SQLExceptionCode.java:455)
>> at
>> org.apache.phoenix.exception.SQLExceptionInfo.buildException
>> (SQLExceptionInfo.java:145)
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllT
>> ableRegions(ConnectionQueryServicesImpl.java:546)
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl.checkCl
>> ientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureT
>> ableCreated(ConnectionQueryServicesImpl.java:1068)
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl.createT
>> able(ConnectionQueryServicesImpl.java:1388)
>> at
>> org.apache.phoenix.schema.MetaDataClient.createTableInternal
>> (MetaDataClient.java:2298)
>> at
>> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDat
>> aClient.java:940)
>> at
>> org.apache.phoenix.compile.CreateTableCompiler$2.execute(Cre
>> ateTableCompiler.java:193)
>> at
>> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>> ment.java:344)
>> at
>> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>> ment.java:332)
>> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>> at
>> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho
>> enixStatement.java:331)
>> at
>> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(Phoen
>> ixStatement.java:1423)
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.
>> call(ConnectionQueryServicesImpl.java:2352)
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.
>> call(ConnectionQueryServicesImpl.java:2291)
>> at
>> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixC
>> ontextExecutor.java:76)
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(Co
>> nnectionQueryServicesImpl.java:2291)
>> at
>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServ
>> ices(PhoenixDriver.java:232)
>> at
>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnecti
>> on(PhoenixEmbeddedDriver.java:147)
>> at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
>> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
>> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
>> at sqlline.Commands.connect(Commands.java:1064)
>> at sqlline.Commands.connect(Commands.java:996)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>> ssorImpl.java:62)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>> thodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> at
>> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa
>> ndler.java:36)
>> at sqlline.SqlLine.dispatch(SqlLine.java:803)
>> at sqlline.SqlLine.initArgs(SqlLine.java:588)
>> at sqlline.SqlLine.begin(SqlLine.java:656)
>> at sqlline.SqlLine.start(SqlLine.java:398)
>> at sqlline.SqlLine.main(SqlLine.java:292)
>> Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException: No
>> server address listed in hbase:meta for region
>> SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8.
>> containing
>> row
>> at
>> org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.locateRegionInMeta(ConnectionManager.java:1318)
>> at
>> org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.locateRegion(ConnectionManager.java:1181)
>> at
>> org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.relocateRegi

Re: Error at starting Phoenix shell with HBase

[Josh Elser]

(-cc dev@phoenix)

phoenix-4.8.2-HBase-1.2-server.jar in the top-level binary tarball of 
Apache Phoenix 4.8.0 is the jar which is meant to be deployed to all 
HBase's classpath.


I would check the RegionServer logs -- I'm guessing that it never 
started correctly or failed. The error message is saying that certain 
regions in the system were never assigned to a RegionServer which only 
happens in exceptional cases.


Chetan Khatri wrote:

Hello Community,

I have installed and configured Apache Phoenix on Single Node Ubuntu 16.04
machine:
- Hadoop 2.7
- HBase 1.2.4
- Phoenix -4.8.2-HBase-1.2

Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
with bin/hbase classpath | grep 'phoenix' and I am using embedded
zookeeper, so my hbase-site.xml looks like below:


  
 hbase.rootdir
 file:///home/hduser/hbase
   


I am able to read / write to HBase from shell and Apache Spark.

*Errors while accessing with **sqlline**:*

1) bin/sqlline.py localhost:2181

Error:

1. Command made process hang.
2.
Error: ERROR 1102 (XCL02): Cannot get all table regions.
(state=XCL02,code=1102)
java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions.
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:455)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:546)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1068)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1388)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2298)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:940)
at
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:193)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:344)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:332)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:331)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1423)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2352)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2291)
at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2291)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:232)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:147)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
at sqlline.Commands.connect(Commands.java:1064)
at sqlline.Commands.connect(Commands.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:803)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:656)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException: No
server address listed in hbase:meta for region
SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8. containing
row
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1318)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1181)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1152)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1136)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:957)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:531)
... 32 more
sqlline version 1.1.9

Kindly let me know how to fix this error.

Thanks,

Re: Error at starting Phoenix shell with HBase

[Chetan Khatri]

Still I am getting Same Error

Error: ERROR 1102 (XCL02): Cannot get all table regions.
(state=XCL02,code=1102)
java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions.
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:455)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:546)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1068)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1388)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2298)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:940)
at
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:193)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:344)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:332)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:331)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1423)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2352)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2291)
at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2291)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:232)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:147)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
at sqlline.Commands.connect(Commands.java:1064)
at sqlline.Commands.connect(Commands.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:803)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:656)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException: No
server address listed in hbase:meta for region
SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8. containing
row
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1318)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1181)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1152)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1136)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:957)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:531)
... 32 more
sqlline version 1.1.9


On Fri, Jan 13, 2017 at 8:06 PM, Chetan Khatri 
wrote:

> Mark, Thank you for reply. But command takes 20 mins to get response ?
>
> On Fri, Jan 13, 2017 at 7:40 PM, Mark Heppner 
> wrote:
>
>> I think you need to start it with either of these:
>> ./bin/sqlline.py localhost:2181:/hbase
>> ./bin/sqlline.py localhost:2181:/hbase-unsecure
>>
>> On Fri, Jan 13, 2017 at 8:49 AM, Chetan Khatri <
>> chetan.opensou...@gmail.com> wrote:
>>
>>> Hello Community,
>>>
>>> I have installed and configured Apache Phoenix on Single Node Ubuntu
>>> 16.04 machine:
>>> - Hadoop 2.7
>>> - HBase 1.2.4
>>> - Phoenix -4.8.2-HBase-1.2
>>>
>>> Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
>>> with bin/hbase classpath | grep 'phoenix' and I am using embedded
>>> zookeeper, so my hbase-site.xml looks like below:
>>>
>>> 
>>>  
>>> hbase.rootdir
>>> file:///home/hduser/hbase
>>>   
>>> 
>>>
>>> I am able to read / write to HBase from shell and Apache Spark.
>>>
>>> *Errors while accessing with **sqlline**:*
>>>
>>> 1) bin/sqlline.py localhost:2181
>>>

Re: Error at starting Phoenix shell with HBase

[Chetan Khatri]

Mark, Thank you for reply. But command takes 20 mins to get response ?

On Fri, Jan 13, 2017 at 7:40 PM, Mark Heppner 
wrote:

> I think you need to start it with either of these:
> ./bin/sqlline.py localhost:2181:/hbase
> ./bin/sqlline.py localhost:2181:/hbase-unsecure
>
> On Fri, Jan 13, 2017 at 8:49 AM, Chetan Khatri <
> chetan.opensou...@gmail.com> wrote:
>
>> Hello Community,
>>
>> I have installed and configured Apache Phoenix on Single Node Ubuntu
>> 16.04 machine:
>> - Hadoop 2.7
>> - HBase 1.2.4
>> - Phoenix -4.8.2-HBase-1.2
>>
>> Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
>> with bin/hbase classpath | grep 'phoenix' and I am using embedded
>> zookeeper, so my hbase-site.xml looks like below:
>>
>> 
>>  
>> hbase.rootdir
>> file:///home/hduser/hbase
>>   
>> 
>>
>> I am able to read / write to HBase from shell and Apache Spark.
>>
>> *Errors while accessing with **sqlline**:*
>>
>> 1) bin/sqlline.py localhost:2181
>>
>> Error:
>>
>> 1. Command made process hang.
>> 2.
>> Error: ERROR 1102 (XCL02): Cannot get all table regions.
>> (state=XCL02,code=1102)
>> java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions.
>> at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newE
>> xception(SQLExceptionCode.java:455)
>> at org.apache.phoenix.exception.SQLExceptionInfo.buildException
>> (SQLExceptionInfo.java:145)
>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllT
>> ableRegions(ConnectionQueryServicesImpl.java:546)
>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.checkCl
>> ientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureT
>> ableCreated(ConnectionQueryServicesImpl.java:1068)
>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.createT
>> able(ConnectionQueryServicesImpl.java:1388)
>> at org.apache.phoenix.schema.MetaDataClient.createTableInternal
>> (MetaDataClient.java:2298)
>> at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDat
>> aClient.java:940)
>> at org.apache.phoenix.compile.CreateTableCompiler$2.execute(Cre
>> ateTableCompiler.java:193)
>> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>> ment.java:344)
>> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>> ment.java:332)
>> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho
>> enixStatement.java:331)
>> at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(Phoen
>> ixStatement.java:1423)
>> at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.
>> call(ConnectionQueryServicesImpl.java:2352)
>> at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.
>> call(ConnectionQueryServicesImpl.java:2291)
>> at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixC
>> ontextExecutor.java:76)
>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(Co
>> nnectionQueryServicesImpl.java:2291)
>> at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServ
>> ices(PhoenixDriver.java:232)
>> at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnecti
>> on(PhoenixEmbeddedDriver.java:147)
>> at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
>> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
>> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
>> at sqlline.Commands.connect(Commands.java:1064)
>> at sqlline.Commands.connect(Commands.java:996)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>> ssorImpl.java:62)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>> thodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa
>> ndler.java:36)
>> at sqlline.SqlLine.dispatch(SqlLine.java:803)
>> at sqlline.SqlLine.initArgs(SqlLine.java:588)
>> at sqlline.SqlLine.begin(SqlLine.java:656)
>> at sqlline.SqlLine.start(SqlLine.java:398)
>> at sqlline.SqlLine.main(SqlLine.java:292)
>> Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException: No
>> server address listed in hbase:meta for region
>> SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8.
>> containing row
>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.locateRegionInMeta(ConnectionManager.java:1318)
>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.locateRegion(ConnectionManager.java:1181)
>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.relocateRegion(ConnectionManager.java:1152)
>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.relocateRegion(ConnectionManager.java:1136)
>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>> Implementation.getRegionLocation(Con

Re: Error at starting Phoenix shell with HBase

[Mark Heppner]

I think you need to start it with either of these:
./bin/sqlline.py localhost:2181:/hbase
./bin/sqlline.py localhost:2181:/hbase-unsecure

On Fri, Jan 13, 2017 at 8:49 AM, Chetan Khatri 
wrote:

> Hello Community,
>
> I have installed and configured Apache Phoenix on Single Node Ubuntu 16.04
> machine:
> - Hadoop 2.7
> - HBase 1.2.4
> - Phoenix -4.8.2-HBase-1.2
>
> Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
> with bin/hbase classpath | grep 'phoenix' and I am using embedded
> zookeeper, so my hbase-site.xml looks like below:
>
> 
>  
> hbase.rootdir
> file:///home/hduser/hbase
>   
> 
>
> I am able to read / write to HBase from shell and Apache Spark.
>
> *Errors while accessing with **sqlline**:*
>
> 1) bin/sqlline.py localhost:2181
>
> Error:
>
> 1. Command made process hang.
> 2.
> Error: ERROR 1102 (XCL02): Cannot get all table regions.
> (state=XCL02,code=1102)
> java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions.
> at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.
> newException(SQLExceptionCode.java:455)
> at org.apache.phoenix.exception.SQLExceptionInfo.buildException(
> SQLExceptionInfo.java:145)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.
> getAllTableRegions(ConnectionQueryServicesImpl.java:546)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.
> checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.
> ensureTableCreated(ConnectionQueryServicesImpl.java:1068)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(
> ConnectionQueryServicesImpl.java:1388)
> at org.apache.phoenix.schema.MetaDataClient.createTableInternal(
> MetaDataClient.java:2298)
> at org.apache.phoenix.schema.MetaDataClient.createTable(
> MetaDataClient.java:940)
> at org.apache.phoenix.compile.CreateTableCompiler$2.execute(
> CreateTableCompiler.java:193)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(
> PhoenixStatement.java:344)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(
> PhoenixStatement.java:332)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(
> PhoenixStatement.java:331)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(
> PhoenixStatement.java:1423)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(
> ConnectionQueryServicesImpl.java:2352)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(
> ConnectionQueryServicesImpl.java:2291)
> at org.apache.phoenix.util.PhoenixContextExecutor.call(
> PhoenixContextExecutor.java:76)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(
> ConnectionQueryServicesImpl.java:2291)
> at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(
> PhoenixDriver.java:232)
> at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(
> PhoenixEmbeddedDriver.java:147)
> at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
> at sqlline.Commands.connect(Commands.java:1064)
> at sqlline.Commands.connect(Commands.java:996)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:
> 36)
> at sqlline.SqlLine.dispatch(SqlLine.java:803)
> at sqlline.SqlLine.initArgs(SqlLine.java:588)
> at sqlline.SqlLine.begin(SqlLine.java:656)
> at sqlline.SqlLine.start(SqlLine.java:398)
> at sqlline.SqlLine.main(SqlLine.java:292)
> Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException: No
> server address listed in hbase:meta for region
> SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8.
> containing row
> at org.apache.hadoop.hbase.client.ConnectionManager$
> HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1318)
> at org.apache.hadoop.hbase.client.ConnectionManager$
> HConnectionImplementation.locateRegion(ConnectionManager.java:1181)
> at org.apache.hadoop.hbase.client.ConnectionManager$
> HConnectionImplementation.relocateRegion(ConnectionManager.java:1152)
> at org.apache.hadoop.hbase.client.ConnectionManager$
> HConnectionImplementation.relocateRegion(ConnectionManager.java:1136)
> at org.apache.hadoop.hbase.client.ConnectionManager$
> HConnectionImplementation.getRegionLocation(ConnectionManager.java:957)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.
> getAllTableRegions(ConnectionQueryServicesImpl.java:531)
> ... 32 more
> sqlline version 1.1.9
>
> Kindly let me know how to fix this error.
>
> Thanks,
>
>
>


-- 
Mark Heppner

Error at starting Phoenix shell with HBase

[Chetan Khatri]

Hello Community,

I have installed and configured Apache Phoenix on Single Node Ubuntu 16.04
machine:
- Hadoop 2.7
- HBase 1.2.4
- Phoenix -4.8.2-HBase-1.2

Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
with bin/hbase classpath | grep 'phoenix' and I am using embedded
zookeeper, so my hbase-site.xml looks like below:


 
hbase.rootdir
file:///home/hduser/hbase
  


I am able to read / write to HBase from shell and Apache Spark.

*Errors while accessing with **sqlline**:*

1) bin/sqlline.py localhost:2181

Error:

1. Command made process hang.
2.
Error: ERROR 1102 (XCL02): Cannot get all table regions.
(state=XCL02,code=1102)
java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions.
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:455)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:546)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1068)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1388)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2298)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:940)
at
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:193)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:344)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:332)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:331)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1423)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2352)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2291)
at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2291)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:232)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:147)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
at sqlline.Commands.connect(Commands.java:1064)
at sqlline.Commands.connect(Commands.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:803)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:656)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: org.apache.hadoop.hbase.client.NoServerForRegionException: No
server address listed in hbase:meta for region
SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8. containing
row
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1318)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1181)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1152)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1136)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:957)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:531)
... 32 more
sqlline version 1.1.9

Kindly let me know how to fix this error.

Thanks,