/
Kafka-MapR-DB-HBase.py
116 lines (90 loc) · 3.6 KB
/
Kafka-MapR-DB-HBase.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
############################################################
# Spark Python Script Kafka / MapR Streams => HBase
############################################################
from pyspark import SparkContext, SparkConf
from pyspark.streaming import StreamingContext
from pyspark.streaming.kafka import *;
from pyspark_ext import *
import happybase
############################################################
# Initialization / Control
############################################################
appName = "Kafka_MapR-Streams_to_HBase"
config = SparkConf().setAppName(appName)
props = []
props.append(("spark.rememberDuration", "10"))
props.append(("spark.batchDuration", "10"))
props.append(("spark.eventLog.enabled", "true"))
props.append(("spark.streaming.timeout", "30"))
props.append(("spark.ui.enabled", "true"))
config = config.setAll(props)
sc = SparkContext(conf=config)
ssc = StreamingContext(sc, int(config.get("spark.batchDuration")))
############################################################
# Main application execution function
############################################################
def runApplication(ssc, config):
ssc.start()
if config.get("spark.streaming.timeout") == '':
ssc.awaitTermination()
else:
stopped = ssc.awaitTerminationOrTimeout(int(config.get("spark.streaming.timeout")))
if not stopped :
print("Stopping streaming context after timeout...")
ssc.stop(True)
print("Streaming context stopped.")
############################################################
# Output application details
############################################################
print
print( "APPNAME:" + config.get( "spark.app.name" ))
print( "APPID:" + sc.applicationId)
print( "VERSION:" + sc.version)
print
############################################################
# Begin of Mapping Logic
############################################################
# HBase related details
hbase_table = 'clicks'
hconn = happybase.Connection('maprdemo')
ctable = hconn.table(hbase_table)
##
# MapR Streams / Kafka related details
topic = ["/users-stream:clicks"]
k_params = {"key.deserializer" : "org.apache.kafka.common.serialization.StringDeserializer" \
,"value.deserializer" : "org.apache.kafka.common.serialization.StringDeserializer" \
#,"zookeeper.connect" : "maprdemo:5181"
#,"metadata.broker.list" : "this.will.be.ignored:9092"
,"session.timeout.ms" : "45"
,"group.id" : "Kafka_MapR-Streams_to_HBase"}
##
def SaveToHBase(rdd):
print("=====Pull from Stream=====")
if not rdd.isEmpty():
print("=some records=")
for line in rdd.collect():
ctable.put(('click' + line.serial_id), { \
b'clickinfo:studentid': (line.studentid), \
b'clickinfo:url': (line.url), \
b'clickinfo:time': (line.time), \
b'iteminfo:itemtype': (line.itemtype), \
b'iteminfo:quantity': (line.quantity)})
kds = KafkaUtils.createDirectStream(ssc, topic, k_params, fromOffsets=None)
parsed = kds.filter(lambda x: x != None and len(x) > 0 )
parsed = parsed.map(lambda x: x[1])
parsed = parsed.map(lambda rec: rec.split(","))
parsed = parsed.filter(lambda x: x != None and len(x) == 6 )
parsed = parsed.map(lambda data:Row(serial_id=getValue(str,data[0]), \
studentid=getValue(str,data[1]), \
url=getValue(str,data[2]), \
time=getValue(str,data[3]), \
itemtype=getValue(str,data[4]), \
quantity=getValue(str,data[5])))
parsed.foreachRDD(SaveToHBase)
############################################################
# Start application
############################################################
runApplication(ssc, config)
print
print("SUCCESS")
print