[
https://issues.apache.org/jira/browse/HIVE-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13798579#comment-13798579
]
Ken Williams commented on HIVE-1558:
------------------------------------
What advantage does creating a "DUAL" have, over just letting the caller omit
the "FROM..." altogether? In MySQL, one can just do {{SELECT 5+5;}} without a
FROM clause, which has always seemed more natural to me.
> introducing the "dual" table
> ----------------------------
>
> Key: HIVE-1558
> URL: https://issues.apache.org/jira/browse/HIVE-1558
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Ning Zhang
> Assignee: Marcin Kurczych
>
> The "dual" table in MySQL and Oracle is very convenient in testing UDFs or
> constructing rows without reading any other tables.
> If dual is the only data source we could leverage the local mode execution.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
