[jira] [Commented] (HIVE-1558) introducing the dual table
[ https://issues.apache.org/jira/browse/HIVE-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (HIVE-1558) introducing the dual table
[ https://issues.apache.org/jira/browse/HIVE-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13798581#comment-13798581 ] Ken Williams commented on HIVE-1558: [~jvs] - I think that's mostly a separate issue from this one. {{SELECT * FROM (VALUES ...)}} is related, but not really tied to DUAL. 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)
[jira] [Commented] (HIVE-1558) introducing the dual table
[ https://issues.apache.org/jira/browse/HIVE-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13614159#comment-13614159 ] Maxime LANCIAUX commented on HIVE-1558: --- What do you think about modify Hive.g and add a token for DUAL ? 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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-1558) introducing the dual table
[ https://issues.apache.org/jira/browse/HIVE-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13265575#comment-13265575 ] Edward Capriolo commented on HIVE-1558: --- I created a DualInputFormat that can be used to easily create a dual table. https://github.com/edwardcapriolo/DualInputFormat. 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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira