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

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

Hi, thank you for this patch, this is what I was trying to do. I'm trying to 
run a sample Query but get errors:

Output:
SELECT dboutput('jdbc://localhost:3306/analytics','root','kdjf','INSERT INTO 
status_count (date,status,count) VALUES (?,?,?)',day,httpstatus,count(1)) FROM 
web_logs GROUP BY day, httpstatus;
Total MapReduce jobs = 1
Number of reduce tasks not specified. Estimated from input data size: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapred.reduce.tasks=<number>
Starting Job = job_200908201702_0066, Tracking URL = 
http://verizonmaster:50030/jobdetails.jsp?jobid=job_200908201702_0066
Kill Command = /home/hadoop/hadoop-0.18.3/bin/../bin/hadoop job  
-Dmapred.job.tracker=verizonmaster:50121 -kill job_200908201702_0066
2009-08-21 09:20:33,914 map = 0%,  reduce = 0%
2009-08-21 09:20:36,933 map = 50%,  reduce = 50%
2009-08-21 09:20:39,953 map = 100%,  reduce = 100%
Ended Job = job_200908201702_0066 with errors
FAILED: Execution Error, return code 2 from 
org.apache.hadoop.hive.ql.exec.ExecDriver

Any Ideas? Thank You.

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

Reply via email to