hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luis Ramos (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-645) A UDF that can export data to JDBC databases.
Date Fri, 04 Sep 2009 17:39:57 GMT

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

Luis Ramos commented on HIVE-645:
---------------------------------

Edward,

1) I didn't think you needed mysql on the other nodes, but I installed it and I'm able to
connect from all my nodes to my destination server (mysql -u dbuser -h master -p). Do I need
the jdbc connector jar on hadoop? Or do I need to have hive on my nodes as well?

2) Changed mapred.map.task and mapred.reduce.task to 1 on all my nodes but I have the same
issues.

What I did to compensate for this: I only call dboutput on a hive table that looks exactly
like I want mysql to look, so SELECT * FROM table. Anytime a query needs to map/reduce I get
connection issues (error:2). If I change back to mapred.job.tracker=local it works.

> 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-6.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