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 <serega.sheypak@gmail.com>:
Thanks, I'll try.
 it's tempale query, it works 100% through JDBC

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


On Sep 1, 2015, at 2:54 PM, Serega Sheypak <serega.sheypak@gmail.com> 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)
)SALT_BUCKETS=30, DATA_BLOCK_ENCODING='SNAPPY',VERSIONS=1, TTL=691200;

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(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


What it could be, what do I do wrong?