[jira] [Assigned] (PHOENIX-1864) Doc bug - first example from CREATE TABLE doc doesn't work

["Thomas D'Silva (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas D'Silva reassigned PHOENIX-1864:
---------------------------------------

    Assignee: Thomas D'Silva

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