HDPCD-Java-复习笔记(21)- lab
来源:互联网 发布:中国电信网络传真 编辑:程序博客网 时间:2024/06/05 12:44
Java lab booklet
Lab: Writing a Hive User Defined Function (UDF)
importstocks.hive
CREATE TABLE stocks (xchange STRING,
symbol STRING,
priceDate STRING,
open FLOAT,
high FLOAT,
low FLOAT,
close FLOAT,
volume INT,
adjClose FLOAT)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ',';
LOAD DATA LOCAL INPATH '/root/java/labs/data/stock_prices/NYSE_daily_prices_A.csv' OVERWRITE INTO TABLE stocks;
MoneyFlow.java
package hiveudfs;import org.apache.hadoop.hive.ql.exec.UDF;import org.apache.hadoop.hive.serde2.io.DoubleWritable;public class MoneyFlow extends UDF { private DoubleWritable result = new DoubleWritable(); public DoubleWritable evaluate(double high, double low, double close, int volume) { double typicalPrice = (high + low + close) / 3; double moneyFlow = typicalPrice * volume; result.set(moneyFlow); return result; }}
moneyflow.hive
ADD JAR hiveudfs.jar;
CREATE TEMPORARY FUNCTION moneyflow AS 'hiveudfs.MoneyFlow';
SELECT symbol, priceDate, moneyflow(high, low, close, volume) FROM stocks LIMIT 10000;
阅读全文
0 0
- HDPCD-Java-复习笔记(21)- lab
- HDPCD-Java-复习笔记(3)-lab
- HDPCD-Java-复习笔记(7)- lab
- HDPCD-Java-复习笔记(8)- lab
- HDPCD-Java-复习笔记(9)-lab
- HDPCD-Java-复习笔记(10)-lab
- HDPCD-Java-复习笔记(13)- lab
- HDPCD-Java-复习笔记(14)- lab
- HDPCD-Java-复习笔记(22)- lab
- HDPCD-Java-复习笔记(23)- lab
- HDPCD-Java-复习笔记(1)
- HDPCD-Java-复习笔记(2)
- HDPCD-Java-复习笔记(4)
- HDPCD-Java-复习笔记(5)
- HDPCD-Java-复习笔记(6)
- HDPCD-Java-复习笔记(11)
- HDPCD-Java-复习笔记(12)
- HDPCD-Java-复习笔记(15)
- 利用可变列数组实现乘法口诀打印。
- hibernate持久化对象的状态
- 安卓简单发送短信案例-qq盗号案例
- 虚拟机类加载机制
- 面向对象的设计原则
- HDPCD-Java-复习笔记(21)- lab
- 一个32岁入门的70后程序员给我的启示
- 趣图丨真·程序员的日常
- Java赋值问题,如下
- maven实现按需打包指定接口
- 宏定义
- Ansible入门基础
- 软考嵌入式系统设计师2011年上午试题总结
- AngularJS实现对用户信息的增删改查