· 7 years ago · Sep 18, 2018, 03:30 PM
1Approach/Algorithm to choose in this Big Data
2CREATE EXTERNAL TABLE IF NOT EXISTS Table1
3(
4UID BIGINT,
5ITEMS_PURCHASED ARRAY<STRUCT<PRODUCT_ID: BIGINT,TIMESTAMPS:STRING>>
6)
7
81015826235 [{"product_id":220003038067,"timestamps":"1340321132000"},{"product_id":300003861266,"timestamps":"1340271857000"},{"product_id":140002997245,"timestamps":"1339694926000"},{"product_id":200002448035,"timestamps":"1339172659000"},{"product_id":260003553381,"timestamps":"1339072514000"}]
9
10CREATE EXTERNAL TABLE IF NOT EXISTS Table2
11(
12ITEM_ID BIGINT,
13CREATED_TIME STRING,
14BUYER_ID BIGINT
15)
16
17220003038067 2012-06-21 1015826235
18300003861266 2012-06-21 1015826235
19140002997245 2012-06-14 1015826235
20200002448035 2012-06-08 1015826235
21260003553381 2012-06-07 1015826235