hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-645) A UDF that can export data to JDBC databases.
Date Tue, 18 Aug 2009 02:51:16 GMT

    [ https://issues.apache.org/jira/browse/HIVE-645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12744336#action_12744336
] 

Edward Capriolo commented on HIVE-645:
--------------------------------------

Raghotham,

This does not require limit 1. My test case just uses limit 1 to specify static data. As is
the case with the second query the number of rows selected is returned. You could add another
level of sub queries to count up the number of 0's returned.

So this:
{noformat}
SELECT
dboutput('jdbc:derby:../build/test_dboutput_db','','',
'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)',key,value)
{noformat}

Becomes something like this: (bad syntax but you get the idea)
{noformat}
from (
SELECT
dboutput('jdbc:derby:../build/test_dboutput_db','','',
'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)',key,value) as x
) sum (x) where x=0
{noformat}

On a side note, I always try to release some patches along the way so people know what I am
up to and for suggestions. I spent a lot of time with HIVE-487 reflection and then we went
with the shims. It is a lot of throw away work if I switch from UDF to UDAF at this point
since I am pretty much at the phase where I am crossing i's and dotting t's.

> A UDF that can export data to JDBC databases.
> ---------------------------------------------
>
>                 Key: HIVE-645
>                 URL: https://issues.apache.org/jira/browse/HIVE-645
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Contrib
>            Reporter: Edward Capriolo
>            Assignee: Edward Capriolo
>            Priority: Minor
>         Attachments: hive-645-2.patch, hive-645-3.patch, hive-645-4.patch, hive-645-5.patch,
hive-645.patch
>
>
> A UDF that can export data to JDBC databases.

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


Mime
View raw message