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