[
https://issues.apache.org/jira/browse/PHOENIX-1864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas D'Silva resolved PHOENIX-1864.
-------------------------------------
Resolution: Fixed
> 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
> Assignee: Thomas D'Silva
> Priority: Minor
> Labels: newbie
>
> 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)
