· 10 years ago · May 26, 2016, 01:00 PM
1create external table if not exists customer(customer_id int,name string,address string)row format delimited fields terminated by ',';
2
3load data inpath /sqoop_import_increment into table customer;
4`
5
6<workflow-app name="hive_script" xmlns="uri:oozie:workflow:0.5">
7 <start to="hive-4327"/>
8 <kill name="Kill">
9 <message>Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
10 </kill>
11 <action name="hive-4327" cred="hcat">
12 <hive xmlns="uri:oozie:hive-action:0.2">
13 <job-tracker>${jobTracker}</job-tracker>
14 <name-node>${nameNode}</name-node>
15 <job-xml>lib/hive-config.xml</job-xml>
16 <script>lib/impala-script.hql</script>
17 </hive>
18 <ok to="End"/>
19 <error to="Kill"/>
20 </action>
21 <end name="End"/>
22</workflow-app>
23
24oozie.use.system.libpath=True
25security_enabled=False
26dryrun=False
27jobTracker=localhost:8032
28nameNode=hdfs://quickstart.cloudera:8020
29
30<?xml version="1.0"?>
31<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
32
33<configuration>
34
35 <!-- Hive Configuration can either be stored in this file or in the hadoop configuration files -->
36 <!-- that are implied by Hadoop setup variables. -->
37 <!-- Aside from Hadoop setup variables - this file is provided as a convenience so that Hive -->
38 <!-- users do not have to edit hadoop configuration files (that may be managed as a centralized -->
39 <!-- resource). -->
40
41 <!-- Hive Execution Parameters -->
42
43 <property>
44 <name>javax.jdo.option.ConnectionURL</name>
45 <value>jdbc:mysql://127.0.0.1/metastore?createDatabaseIfNotExist=true</value>
46 <description>JDBC connect string for a JDBC metastore</description>
47 </property>
48
49 <property>
50 <name>javax.jdo.option.ConnectionDriverName</name>
51 <value>com.mysql.jdbc.Driver</value>
52 <description>Driver class name for a JDBC metastore</description>
53 </property>
54
55 <property>
56 <name>javax.jdo.option.ConnectionUserName</name>
57 <value>hive</value>
58 </property>
59
60 <property>
61 <name>javax.jdo.option.ConnectionPassword</name>
62 <value>cloudera</value>
63 </property>
64
65 <property>
66 <name>hive.hwi.war.file</name>
67 <value>/usr/lib/hive/lib/hive-hwi-0.8.1-cdh4.0.0.jar</value>
68 <description>This is the WAR file with the jsp content for Hive Web Interface</description>
69 </property>
70
71 <property>
72 <name>datanucleus.fixedDatastore</name>
73 <value>true</value>
74 </property>
75
76 <property>
77 <name>datanucleus.autoCreateSchema</name>
78 <value>false</value>
79 </property>
80
81 <property>
82 <name>hive.metastore.uris</name>
83 <value>thrift://127.0.0.1:9083</value>
84 <description>IP address (or fully-qualified domain name) and port of the metastore host</description>
85 </property>
86</configuration>