Hive / HCatalog Forum
I have Employeetable which contains id,name,st and Age columns.
id name st Age
1 Ram NY
2 Raj NJ
3 Ravi CT
4 Anand CA 25
Another “variable” table columns var1,value1,var2,value2
Var1 Value1,var2,value2 Factor
ST NY 0.7
ST NJ 0.2
ST CA Age 25 0.8
I need factor values for each employees based on State/Age/combination of both.
Please provide the query.Thanks!
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world