I can describe table using sqlline from phoenix, but can't query the table:

select crossid from CROSS_ID_ATTRIBUTES limit 1;

just hungs and when I try to interrupt utility, I see "a kind o exception"

Exception in thread "SIGINT handler" java.lang.RuntimeException:
java.sql.SQLFeatureNotSupportedException


                              at
sqlline.SunSignalHandler.handle(SunSignalHandler.java:43)

  at sun.misc.Signal$1.run(Signal.java:212)

                                                 at
java.lang.Thread.run(Thread.java:745)


                    Caused by: java.sql.SQLFeatureNotSupportedException


                                                                        at
org.apache.phoenix.jdbc.PhoenixStatement.cancel(PhoenixStatement.java:958)

                                                          at
sqlline.DispatchCallback.forceKillSqlQuery(DispatchCallback.java:83)


                                                            at
sqlline.SunSignalHandler.handle(SunSignalHandler.java:38)

2015-09-02 22:09 GMT+02:00 Serega Sheypak <serega.sheypak@gmail.com>:

> Hi, I'm here again. Wrote local unit-tests, all works perfectly. Started
> to run smokes on production and can't reach great success. What this
> exception means?
>
>
> My ddl is:
>
> CREATE TABLE IF NOT EXISTS cross_id_attributes
>
> (
>
>    crossId        VARCHAR   NOT NULL
>
>    CONSTRAINT cross_id_reference_pk  PRIMARY KEY (crossId)
>
> )SALT_BUCKETS=30, DATA_BLOCK_ENCODING='SNAPPY',VERSIONS=1, TTL=691200
>
>
> Here it is:
>
> 0: jdbc:phoenix:node01.a> !tables
>
>
> *+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
>
> *| **               TABLE_CAT                ** | **
> TABLE_SCHEM               ** | **               TABLE_NAME               **
> | **               TABLE_TYPE             ** |*
>
>
> *+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
>
> *| *                                        * | *SYSTEM
>                * | *CATALOG                                 * | *SYSTEM
> TABLE                          * |*
>
> *| *                                        * | *SYSTEM
>                * | *SEQUENCE                                * | *SYSTEM
> TABLE                          * |*
>
> *| *                                        * | *SYSTEM
>                * | *STATS                                   * | *SYSTEM
> TABLE                          * |*
>
> *| *                                        * | *
>                * | *CROSS_ID_ATTRIBUTES                     * | *TABLE
>                              * |*
>
>
> *+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
>
> found this one:
>
> http://stackoverflow.com/questions/4794092/unable-to-access-hbase-table
>
> but I have other "usual" tables (non phoenix) with SNAPPY compression and
> it works w/o problems.
>
> Caused by: org.apache.phoenix.execute.CommitException:
> org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed
> 1 action: No server address listed in hbase:meta for region
> CROSS_ID_ATTRIBUTES,,1441136798698.c707266cf9e332ced8ff05170be489e9.
> containing row \x0012345x: 1 time,
>
> at org.apache.phoenix.execute.MutationState.commit(MutationState.java:451)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:427)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:424)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:424)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:283)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:272)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:270)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:211)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:174)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:179)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_45]
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_45]
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_45]
>
> at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
>
> at
> ninja.params.ControllerMethodInvoker.invoke(ControllerMethodInvoker.java:56)
> ~[ninja-core-5.1.4.jar:na]
>
> ... 27 common frames omitted
>