SELECT without FROM; dropping unnecessary table references
----------------------------------------------------------

                 Key: HIVE-178
                 URL: https://issues.apache.org/jira/browse/HIVE-178
             Project: Hadoop Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: Adam Kramer


SELECT 1+1;

should just return '2', but instead hive fails because no table is listed.

SELECT 1+1 FROM (empty table);

should also just return '2', but instead hive "succeeds" because there is no 
possible output, so it produces no output.

So, currently we have to run 

SELECT 1+1 FROM (actual table with data);

...which runs a whole mapreduce step to ignore all of the data before spitting 
out '2'.

It would be nice to be able to SELECT without specifying a table, and perhaps 
relatedly, to be able to edit the above query (which worked) to not need to 
actually process (actual table with data) given that no data is being pulled 
from it (as we see from the SELECT statement, that table's name or alias does 
not appear).

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to