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 <[email protected]>: > Thanks, I'll try. > it's tempale query, it works 100% through JDBC > > 2015-09-01 23:26 GMT+02:00 Michael McAllister <[email protected]>: > >> I think you need a comma between your column definition and your >> constraint definition. >> >> >> On Sep 1, 2015, at 2:54 PM, Serega Sheypak <[email protected]> >> 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? >> >> >> >
