[
https://issues.apache.org/jira/browse/PHOENIX-1721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Serhiy Bilousov updated PHOENIX-1721:
-------------------------------------
Description:
The DUAL table is a special one-row, one-column table present by default in
Oracle and other database installations. In Oracle, the table has a single
VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for use
in selecting a pseudo column such as SYSDATE or USER.
In MS SQL you can do just do
"SELECT getdate() or SELECT 'x' AS DUMMY " without FROM
Something like that would be very helpful to really bring back SQL to noSQL.
was:
The DUAL table is a special one-row, one-column table present by default in
Oracle and other database installations. In Oracle, the table has a single
VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for use
in selecting a pseudo column such as SYSDATE or USER.
In MS SQL you can do just do
"SELEC getdate() or SELECT 'x' AS DUMMY " without FROM
Something like that would be very helpful to really bring back SQL to noSQL.
> Add DUAL table or alike functionality
> -------------------------------------
>
> Key: PHOENIX-1721
> URL: https://issues.apache.org/jira/browse/PHOENIX-1721
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Serhiy Bilousov
> Priority: Critical
>
> The DUAL table is a special one-row, one-column table present by default in
> Oracle and other database installations. In Oracle, the table has a single
> VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for
> use in selecting a pseudo column such as SYSDATE or USER.
> In MS SQL you can do just do
> "SELECT getdate() or SELECT 'x' AS DUMMY " without FROM
> Something like that would be very helpful to really bring back SQL to noSQL.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
