[jira] [Resolved] (PHOENIX-1721) Add DUAL table or alike functionality

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-1721.
-----------------------------------
    Resolution: Won't Fix

Not necessary as the FROM clause is now optional.

> 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)