You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Matjaž Trtnik <mt...@salviol.com> on 2015/09/16 11:32:18 UTC

Column comments

Hi!

Is there a way to create table in Phoenix with column comments. Something like:


CREATE TABLE IF NOT EXISTS us_population (
        state CHAR(2) NOT NULL <comment ’state code’>,
        city VARCHAR NOT NULL <comment 'city name'>,
        population BIGINT <comment 'population in millions>’
CONSTRAINT my_pk PRIMARY KEY (state, city));

If this is possible will I be able to read comments via ResultSetMetaData?

Regards,
Matjaž

Re: Column comments

Posted by anil gupta <an...@gmail.com>.
As per this doc https://phoenix.apache.org/language/#create_table. It
doesnt looks like its supported.
You can open a enhancement Jira for it. Feel free to provide to patch too.

On Sat, Sep 19, 2015 at 2:27 AM, Matjaž Trtnik <mt...@salviol.com> wrote:

> Noone can help me with this or at least say it's not possible?
>
> ------------------------------
> *From:* Matjaž Trtnik
> *Sent:* Wednesday, September 16, 2015 11:32 AM
> *To:* user@phoenix.apache.org
> *Subject:* Column comments
>
> Hi!
>
> Is there a way to create table in Phoenix with column comments. Something
> like:
>
> CREATE TABLE IF NOT EXISTS us_population (
> 	state CHAR(2) NOT NULL <comment ’state code’>,
> 	city VARCHAR NOT NULL <comment 'city name'>,
> 	population BIGINT <comment 'population in millions>’
> CONSTRAINT my_pk PRIMARY KEY (state, city));
>
>
> If this is possible will I be able to read comments via ResultSetMetaData?
>
> Regards,
> Matjaž
>
>
>


-- 
Thanks & Regards,
Anil Gupta

RE: Column comments

Posted by Matjaž Trtnik <mt...@salviol.com>.
Noone can help me with this or at least say it's not possible?

________________________________
From: Matjaž Trtnik
Sent: Wednesday, September 16, 2015 11:32 AM
To: user@phoenix.apache.org
Subject: Column comments

Hi!

Is there a way to create table in Phoenix with column comments. Something like:


CREATE TABLE IF NOT EXISTS us_population (
        state CHAR(2) NOT NULL <comment 'state code'>,
        city VARCHAR NOT NULL <comment 'city name'>,
        population BIGINT <comment 'population in millions>'
CONSTRAINT my_pk PRIMARY KEY (state, city));

If this is possible will I be able to read comments via ResultSetMetaData?

Regards,
Matjaž