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.