phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <>
Subject RE: is there something like dual table in phoenix
Date Thu, 27 Nov 2014 19:07:19 GMT
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.

Deepak Gattala

From: Bulvik, Noam []
Sent: Thursday, November 27, 2014 1:05 PM
Subject: is there something like dual table in phoenix

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

Information in this e-mail and its attachments is confidential and privileged under the TEOCO
confidentiality terms that can be reviewed here<>.

View raw message