If you are looking for as in-built like Oracle. You don't have it. From: Bulvik, Noam [mailto:[email protected]] Sent: Thursday, November 27, 2014 1:12 PM To: [email protected] Subject: RE: is there something like dual table in phoenix
Sure I can , I was looking for more elegant solution From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Thursday, November 27, 2014 9:07 PM To: [email protected]<mailto:[email protected]> 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:[email protected]] Sent: Thursday, November 27, 2014 1:05 PM To: [email protected]<mailto:[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>.
