Major Description
cqd allow_nullable_unique_key_constraint 'on' ;
>>create table t1 (a int, b int, primary key (a,b)) ;
— SQL operation complete.
>>showddl t1 ;
CREATE TABLE TRAFODION.JIRA.T1
(
A INT DEFAULT NULL SERIALIZED
, B INT DEFAULT NULL SERIALIZED
, PRIMARY KEY (A ASC, B ASC)
)
;
— SQL operation complete.
>>insert into t1(a) values (1);
— 1 row(s) inserted.
>>insert into t1(b) values (2) ;
— 1 row(s) inserted.
>>select * from t1 ;
A B
----------- -----------
1 ?
? 2
— 2 row(s) selected.
>>insert into t1(a) values(3) ;
— 1 row(s) inserted.
>>select * from t1 ;
A B
----------- -----------
1 ?
3 ?
? 2
— 3 row(s) selected.
– fails
>>insert into t1 values (null, null) ;
-
-
- ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::checkAndInsertRow returned error HBASE_ACCESS_ERROR(-706). Cause:
org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=35, exceptions:
Tue Feb 02 19:58:34 UTC 2016, org.apache.hadoop.hbase.client.RpcRetryingCaller@4c2e0b96, java.io.IOException: com.google.protobuf.ServiceException: java.lang.NullPointerException
- ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::checkAndInsertRow returned error HBASE_ACCESS_ERROR(-706). Cause:
-