Hi
I would be grateful for any tips on how to "prepare" the data so they can
be exported to a Postgesql Database using sqoop.
As an example:
Provided some files of events. (user events, product events,
productActivity events)
[file0001]
event:user propertes:{name:"john" ...}
event:product properties:{ref:123,color:"blue",...
event:productActivity properties:{user:"john", product:"ref", action:"buy"}
.....
How does one come up with the primary keys and the user_product join table
ready to be exported?
On other words.
function(Input:eventfile) => output:[productFile, userFile,
user_productFile with auto generated primary keys ]
what goes into function?
I hope this makes sense!
Thank you in advance for any help
-matt
|