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