Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create external table if not exists customer(customer_id int,name string,address string)row format delimited fields terminated by ',';
- load data inpath /sqoop_import_increment into table customer;
- `
- <workflow-app name="hive_script" xmlns="uri:oozie:workflow:0.5">
- <start to="hive-4327"/>
- <kill name="Kill">
- <message>Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
- </kill>
- <action name="hive-4327" cred="hcat">
- <hive xmlns="uri:oozie:hive-action:0.2">
- <job-tracker>${jobTracker}</job-tracker>
- <name-node>${nameNode}</name-node>
- <job-xml>lib/hive-config.xml</job-xml>
- <script>lib/impala-script.hql</script>
- </hive>
- <ok to="End"/>
- <error to="Kill"/>
- </action>
- <end name="End"/>
- </workflow-app>
- oozie.use.system.libpath=True
- security_enabled=False
- dryrun=False
- jobTracker=localhost:8032
- nameNode=hdfs://quickstart.cloudera:8020
- <?xml version="1.0"?>
- <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
- <configuration>
- <!-- Hive Configuration can either be stored in this file or in the hadoop configuration files -->
- <!-- that are implied by Hadoop setup variables. -->
- <!-- Aside from Hadoop setup variables - this file is provided as a convenience so that Hive -->
- <!-- users do not have to edit hadoop configuration files (that may be managed as a centralized -->
- <!-- resource). -->
- <!-- Hive Execution Parameters -->
- <property>
- <name>javax.jdo.option.ConnectionURL</name>
- <value>jdbc:mysql://127.0.0.1/metastore?createDatabaseIfNotExist=true</value>
- <description>JDBC connect string for a JDBC metastore</description>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionDriverName</name>
- <value>com.mysql.jdbc.Driver</value>
- <description>Driver class name for a JDBC metastore</description>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionUserName</name>
- <value>hive</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionPassword</name>
- <value>cloudera</value>
- </property>
- <property>
- <name>hive.hwi.war.file</name>
- <value>/usr/lib/hive/lib/hive-hwi-0.8.1-cdh4.0.0.jar</value>
- <description>This is the WAR file with the jsp content for Hive Web Interface</description>
- </property>
- <property>
- <name>datanucleus.fixedDatastore</name>
- <value>true</value>
- </property>
- <property>
- <name>datanucleus.autoCreateSchema</name>
- <value>false</value>
- </property>
- <property>
- <name>hive.metastore.uris</name>
- <value>thrift://127.0.0.1:9083</value>
- <description>IP address (or fully-qualified domain name) and port of the metastore host</description>
- </property>
- </configuration>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement