No, problem is other: DATA_BLOCK_ENCODING='SNAPPY' doesn't for for some reason.
1. I can't execute such DDL from sqlline
2. I can execute it via JDBC, but I can't query on insert into this table...

2015-09-01 23:35 GMT+02:00 Serega Sheypak <>:
Thanks, I'll try.
 it's tempale query, it works 100% through JDBC

2015-09-01 23:26 GMT+02:00 Michael McAllister <>:
I think you need a comma between your column definition and your constraint definition.

On Sep 1, 2015, at 2:54 PM, Serega Sheypak <> wrote:

Hi, I wrote itegration test that uses HBasetesting utility and phoenix. Test creates table and inserts data. It works fine.
I'm trying to run

CREATE TABLE IF NOT EXISTS cross_id_attributes
   crossId        VARCHAR   NOT NULL
   CONSTRAINT cross_id_reference_pk  PRIMARY KEY (crossId)

agains production cluster using sqlline and it hungs. When I try to abort it, I see some exception in console:

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

                                                                                                         at sqlline.SunSignalHandler.handle(

  at sun.misc.Signal$


                                                                                                Caused by: java.sql.SQLFeatureNotSupportedException

What it could be, what do I do wrong?