phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: is there something like dual table in phoenix
Date Thu, 27 Nov 2014 19:15:39 GMT
See also PHOENIX-922 which would be a more elegant way of selecting a
single row. It'd be great if someone could pick this one up.
Thanks,
James

On Thu, Nov 27, 2014 at 11:11 AM, Bulvik, Noam <Noam.Bulvik@teoco.com> wrote:
> Sure I can ,
>
>
>
> I was looking for more elegant solution
>
>
>
> From: Deepak_Gattala@Dell.com [mailto:Deepak_Gattala@Dell.com]
> Sent: Thursday, November 27, 2014 9:07 PM
> To: user@phoenix.apache.org
> Subject: RE: is there something like dual table in phoenix
>
>
>
> You can always create a table with one column in it and just insert one row.
>
>
>
> And you can use as dual table all day long.
>
>
>
> Thanks
>
> Deepak Gattala
>
>
>
> From: Bulvik, Noam [mailto:Noam.Bulvik@teoco.com]
> Sent: Thursday, November 27, 2014 1:05 PM
> To: user@phoenix.apache.org
> Subject: is there something like dual table in phoenix
>
>
>
> HI,
>
> We are using connection pool and there is a need to have a general SQL to
> test if connection is stil open.
>
> In Oracle there is something like select * from dual;
>
> In Impala you can use select 1 without table name
>
>
>
> What can be used for phenix ? both are not valid
>
>
>
> Regards,
>
> Noam
>
> Information in this e-mail and its attachments is confidential and
> privileged under the TEOCO confidentiality terms that can be reviewed here.

Mime
View raw message