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.bul...@teoco.com> wrote: > Sure I can , > > > > I was looking for more elegant solution > > > > From: deepak_gatt...@dell.com [mailto:deepak_gatt...@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.bul...@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.