List of views created on Phoenix tables

["Bavineni, Bharata" <Bh...@epsilon.com>]

Can we get the list of views created on a Phoenix table?

Thanks,
Bharathi.

________________________________

This e-mail and files transmitted with it are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you are not one of the named recipient(s) or otherwise have reason to believe that you received this message in error, please immediately notify sender by e-mail, and destroy the original message. Thank You.

Re: List of views created on Phoenix tables

[Salou Guillaume <g....@gmail.com>]

Hi James,

BTW my name is Guillaume ;)

In facts, when connected as generic (tenant = null) you do not see Views
created by a "single tenant connection". But you can find them by showing
data in catalog (which contains all columns and also ones of tenant binded
tables).

Using SQuirell you can see views even in a generic connection.

Thanks

Guillaume

2015-12-16 18:30 GMT+01:00 James Taylor <ja...@apache.org>:

> Hi Salou,
> Thanks for the info. When you say "it doesn't work in multi-tenant mode",
> do you mean if you connect through a tenant-specific connection, it doesn't
> show you the correct tables? Not sure if that's a sqlline or phoenix issue,
> but would you mind filing a JIRA with some more specifics?
> Thanks,
> James
>
> On Wed, Dec 16, 2015 at 2:36 AM, Salou Guillaume <g....@gmail.com>
> wrote:
>
>> Hi,
>>
>> As to see tables, use the command to see views : !tables
>> But it doesn't work in multi-tenant mode.
>>
>> Best regards,
>>
>> 2015-12-06 6:06 GMT+01:00 Bavineni, Bharata <Bharata.Bavineni@epsilon.com
>> >:
>>
>>> Can we get the list of views created on a Phoenix table?
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Bharathi.
>>>
>>> ------------------------------
>>>
>>> This e-mail and files transmitted with it are confidential, and are
>>> intended solely for the use of the individual or entity to whom this e-mail
>>> is addressed. If you are not the intended recipient, or the employee or
>>> agent responsible to deliver it to the intended recipient, you are hereby
>>> notified that any dissemination, distribution or copying of this
>>> communication is strictly prohibited. If you are not one of the named
>>> recipient(s) or otherwise have reason to believe that you received this
>>> message in error, please immediately notify sender by e-mail, and destroy
>>> the original message. Thank You.
>>>
>>
>>
>

Re: List of views created on Phoenix tables

[James Taylor <ja...@apache.org>]

Hi Salou,
Thanks for the info. When you say "it doesn't work in multi-tenant mode",
do you mean if you connect through a tenant-specific connection, it doesn't
show you the correct tables? Not sure if that's a sqlline or phoenix issue,
but would you mind filing a JIRA with some more specifics?
Thanks,
James

On Wed, Dec 16, 2015 at 2:36 AM, Salou Guillaume <g....@gmail.com> wrote:

> Hi,
>
> As to see tables, use the command to see views : !tables
> But it doesn't work in multi-tenant mode.
>
> Best regards,
>
> 2015-12-06 6:06 GMT+01:00 Bavineni, Bharata <Bh...@epsilon.com>
> :
>
>> Can we get the list of views created on a Phoenix table?
>>
>>
>>
>> Thanks,
>>
>> Bharathi.
>>
>> ------------------------------
>>
>> This e-mail and files transmitted with it are confidential, and are
>> intended solely for the use of the individual or entity to whom this e-mail
>> is addressed. If you are not the intended recipient, or the employee or
>> agent responsible to deliver it to the intended recipient, you are hereby
>> notified that any dissemination, distribution or copying of this
>> communication is strictly prohibited. If you are not one of the named
>> recipient(s) or otherwise have reason to believe that you received this
>> message in error, please immediately notify sender by e-mail, and destroy
>> the original message. Thank You.
>>
>
>

Re: List of views created on Phoenix tables

[Salou Guillaume <g....@gmail.com>]

Hi,

As to see tables, use the command to see views : !tables
But it doesn't work in multi-tenant mode.

Best regards,

2015-12-06 6:06 GMT+01:00 Bavineni, Bharata <Bh...@epsilon.com>:

> Can we get the list of views created on a Phoenix table?
>
>
>
> Thanks,
>
> Bharathi.
>
> ------------------------------
>
> This e-mail and files transmitted with it are confidential, and are
> intended solely for the use of the individual or entity to whom this e-mail
> is addressed. If you are not the intended recipient, or the employee or
> agent responsible to deliver it to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you are not one of the named
> recipient(s) or otherwise have reason to believe that you received this
> message in error, please immediately notify sender by e-mail, and destroy
> the original message. Thank You.
>