Re: Tables can have schema name but indexes cannot

2016-08-12 Thread John Leach
oenix.apache.org <mailto:user@phoenix.apache.org>" > <user@phoenix.apache.org <mailto:user@phoenix.apache.org>> > Date: Friday, August 12, 2016 at 10:56 AM > To: user <user@phoenix.apache.org <mailto:user@phoenix.apache.org>> > Subject: Re: Tables can have s

Re: Tables can have schema name but indexes cannot

2016-08-12 Thread Michael McAllister
ot; <user@phoenix.apache.org> Date: Friday, August 12, 2016 at 10:56 AM To: user <user@phoenix.apache.org> Subject: Re: Tables can have schema name but indexes cannot Hi Michael, SQL dictates that an index must be in the same schema as the table it's indexing. Thanks, James On Fri, Aug

Re: Tables can have schema name but indexes cannot

2016-08-12 Thread James Taylor
Hi Michael, SQL dictates that an index must be in the same schema as the table it's indexing. Thanks, James On Fri, Aug 12, 2016 at 8:50 AM, Michael McAllister < mmcallis...@homeaway.com> wrote: > Hi > > > > Is there any reason we can specify the schema name for a table, but not an > index. I