Ivan Weiss created PHOENIX-1864:
-----------------------------------
Summary: Doc bug - first example from CREATE TABLE doc doesn't work
Key: PHOENIX-1864
URL: https://issues.apache.org/jira/browse/PHOENIX-1864
Project: Phoenix
Issue Type: Bug
Reporter: Ivan Weiss
Priority: Minor
tried to execute
CREATE TABLE my_schema.my_table ( id BIGINT not null primary key, date DATE not
null);
got the following error:
rror: ERROR 517 (42895): Invalid not null constraint on non primary key column
columnName=MY_SCHEMA.MY_TABLE.DATE (state=42895,code=517)
java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non
primary key column columnName=MY_SCHEMA.MY_TABLE.DATE
it was explained to me that it's an hbase restriction that you cannot have a
not null constraint on an non primary key column.
There was also a mailing list discussion on this:
http://mail-archives.apache.org/mod_mbox/phoenix-user/201412.mbox/browser
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
