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 Tue, 25 Aug 2009 01:18:59 GMT

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

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

Edward,

How do I set the logging level? I have "hive.root.logger=DEBUG,DRFA" on hive-log4j.properties.

I followed the following, and I also change the SQL
{{
hive> add jar /usr/share/java//usr/share/java/mysql-connector-java-5.1.5.jar;         
                                                                                         
                   
Added /usr/share/java//usr/share/java/mysql-connector-java-5.1.5.jar to class path

hive> add jar build/contrib/hive_contrib.jar;                                         
                                                                                       
Added build/contrib/hive_contrib.jar to class path

hive> CREATE TEMPORARY FUNCTION dboutput AS 'org.apache.hadoop.hive.contrib.genericudf.example.GenericUDFDBOutput';
                                                          
OK
Time taken: 0.247 seconds

hive> SELECT dboutput('jdbc:mysql://localhost:3306/analytics','root','mxplay','CREATE TABLE
app_info (kkey VARCHAR(255), vvalue VARCHAR(255))') FROM web_logs;        
Total MapReduce jobs = 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_200908201702_0125, Tracking URL = http://verizonmaster:50030/jobdetails.jsp?jobid=job_200908201702_0125
Kill Command = /home/hadoop/hadoop-0.18.3/bin/../bin/hadoop job  -Dmapred.job.tracker=verizonmaster:50121
-kill job_200908201702_0125
2009-08-25 12:52:40,140 map = 0%,  reduce = 0%
2009-08-25 12:52:44,165 map = 50%,  reduce = 50%
2009-08-25 12:52:45,176 map = 100%,  reduce = 100%
Ended Job = job_200908201702_0125
OK
1
1
1
Time taken: 7.275 seconds
}}

> 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