You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Karthik P <ka...@gmail.com> on 2019/05/24 00:05:31 UTC
Phoenix Document Access
Team,
It looks only phoenix committer can do doc update but not contributors. Am
I right?
I see there is incorrect DDL and DML statement in the ARRAY Type page.
https://phoenix.apache.org/array_type.html
I corrected this small change. Can someone please update attached markdown
file in the Phoenix website?
My UserId: kpalanisamy
Thanks,
Karthik
Re: Phoenix Document Access
Posted by Karthik P <ka...@gmail.com>.
Created PHOENIX-5301 <https://issues.apache.org/jira/browse/PHOENIX-5301>.
Thank you, Thomas.
On Fri, May 24, 2019 at 2:18 PM Thomas D'Silva
<td...@salesforce.com.invalid> wrote:
> Can you please file a JIRA for this and attach the markup change there?
>
> On Thu, May 23, 2019 at 5:22 PM Karthik P <ka...@gmail.com>
> wrote:
>
> > fyi, Change is made for this,
> >
> > CREATE TABLE regions (
> > region_name VARCHAR PRIMARY KEY,
> > zips VARCHAR ARRAY[10],
> > CONSTRAINT pk PRIMARY KEY (region_name));
> >
> > Error: ERROR 510 (42889): The table already has a primary key.
> > columnName=REGION_NAME (state=42889,code=510)
> > java.sql.SQLException: ERROR 510 (42889): The table already has a primary
> > key. columnName=REGION_NAME
> >
> > SELECT zip[1] FROM regions WHERE region_name = 'SF Bay Area';
> >
> > SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
> > '94030' OR zip[3] = '94030';
> >
> > SELECT region_name FROM regions WHERE '94030' = ANY(zip);
> > SELECT region_name FROM regions WHERE '94030' = ALL(zip);
> >
> > SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
> > '94030' OR zip[3] = '94030';
> >
> > SELECT region_name FROM regions WHERE zip[1] = '94030' AND zip[2] =
> > '94030' AND zip[3] = '94030';
> >
> > Error: ERROR 504 (42703): Undefined column. columnName=REGIONS.ZIP
> > (state=42703,code=504)
> > org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
> > Undefined column. columnName=REGIONS.ZIP
> >
> > Thanks,
> > Karthik
> >
> >
> > On Thu, May 23, 2019 at 5:05 PM Karthik P <ka...@gmail.com>
> > wrote:
> >
> > > Team,
> > >
> > > It looks only phoenix committer can do doc update but not contributors.
> > > Am I right?
> > >
> > > I see there is incorrect DDL and DML statement in the ARRAY Type page.
> > > https://phoenix.apache.org/array_type.html
> > >
> > > I corrected this small change. Can someone please update attached
> > markdown
> > > file in the Phoenix website?
> > >
> > > My UserId: kpalanisamy
> > >
> > >
> > > Thanks,
> > > Karthik
> > >
> > >
> >
> > --
> > Thank you,
> > *Karthik Palanisamy*
> > Mobile : +1 669 292 7106
> > Skype : karthik.p01
> >
>
--
Thank you,
*Karthik Palanisamy*
Mobile : +1 669 292 7106
Skype : karthik.p01
Re: Phoenix Document Access
Posted by Thomas D'Silva <td...@salesforce.com.INVALID>.
Can you please file a JIRA for this and attach the markup change there?
On Thu, May 23, 2019 at 5:22 PM Karthik P <ka...@gmail.com> wrote:
> fyi, Change is made for this,
>
> CREATE TABLE regions (
> region_name VARCHAR PRIMARY KEY,
> zips VARCHAR ARRAY[10],
> CONSTRAINT pk PRIMARY KEY (region_name));
>
> Error: ERROR 510 (42889): The table already has a primary key.
> columnName=REGION_NAME (state=42889,code=510)
> java.sql.SQLException: ERROR 510 (42889): The table already has a primary
> key. columnName=REGION_NAME
>
> SELECT zip[1] FROM regions WHERE region_name = 'SF Bay Area';
>
> SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
> '94030' OR zip[3] = '94030';
>
> SELECT region_name FROM regions WHERE '94030' = ANY(zip);
> SELECT region_name FROM regions WHERE '94030' = ALL(zip);
>
> SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
> '94030' OR zip[3] = '94030';
>
> SELECT region_name FROM regions WHERE zip[1] = '94030' AND zip[2] =
> '94030' AND zip[3] = '94030';
>
> Error: ERROR 504 (42703): Undefined column. columnName=REGIONS.ZIP
> (state=42703,code=504)
> org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
> Undefined column. columnName=REGIONS.ZIP
>
> Thanks,
> Karthik
>
>
> On Thu, May 23, 2019 at 5:05 PM Karthik P <ka...@gmail.com>
> wrote:
>
> > Team,
> >
> > It looks only phoenix committer can do doc update but not contributors.
> > Am I right?
> >
> > I see there is incorrect DDL and DML statement in the ARRAY Type page.
> > https://phoenix.apache.org/array_type.html
> >
> > I corrected this small change. Can someone please update attached
> markdown
> > file in the Phoenix website?
> >
> > My UserId: kpalanisamy
> >
> >
> > Thanks,
> > Karthik
> >
> >
>
> --
> Thank you,
> *Karthik Palanisamy*
> Mobile : +1 669 292 7106
> Skype : karthik.p01
>
Re: Phoenix Document Access
Posted by Karthik P <ka...@gmail.com>.
fyi, Change is made for this,
CREATE TABLE regions (
region_name VARCHAR PRIMARY KEY,
zips VARCHAR ARRAY[10],
CONSTRAINT pk PRIMARY KEY (region_name));
Error: ERROR 510 (42889): The table already has a primary key.
columnName=REGION_NAME (state=42889,code=510)
java.sql.SQLException: ERROR 510 (42889): The table already has a primary
key. columnName=REGION_NAME
SELECT zip[1] FROM regions WHERE region_name = 'SF Bay Area';
SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
'94030' OR zip[3] = '94030';
SELECT region_name FROM regions WHERE '94030' = ANY(zip);
SELECT region_name FROM regions WHERE '94030' = ALL(zip);
SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] =
'94030' OR zip[3] = '94030';
SELECT region_name FROM regions WHERE zip[1] = '94030' AND zip[2] =
'94030' AND zip[3] = '94030';
Error: ERROR 504 (42703): Undefined column. columnName=REGIONS.ZIP
(state=42703,code=504)
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
Undefined column. columnName=REGIONS.ZIP
Thanks,
Karthik
On Thu, May 23, 2019 at 5:05 PM Karthik P <ka...@gmail.com> wrote:
> Team,
>
> It looks only phoenix committer can do doc update but not contributors.
> Am I right?
>
> I see there is incorrect DDL and DML statement in the ARRAY Type page.
> https://phoenix.apache.org/array_type.html
>
> I corrected this small change. Can someone please update attached markdown
> file in the Phoenix website?
>
> My UserId: kpalanisamy
>
>
> Thanks,
> Karthik
>
>
--
Thank you,
*Karthik Palanisamy*
Mobile : +1 669 292 7106
Skype : karthik.p01