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.