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:[email protected]] Sent: Thursday, November 27, 2014 1:05 PM To: [email protected] 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<http://www.teoco.com/email-disclaimer>.
