impala: create function fuzzyMatch(string,string) returns double location '/user/hive/udf/common_project-1.0-SNAPSHOT.jar' symbol='utils.FuzzyMatch';
create function getDistance(double,double,double,double) returns double location '/user/hive/udf/common_project-1.0-SNAPSHOT.jar' symbol='utils.Distance';
hive: add jar /data/common_project-1.0-SNAPSHOT.jar create temporary function fuzzyMatch as 'utils.FuzzyMatch';
create temporary function getDistance as 'utils.Distance';
create function getDistance as 'utils.Distance' using jar 'hdfs:///user/hive/udf/common_project-1.0-SNAPSHOT.jar'; ? create function fuzzyMatch as 'utils.FuzzyMatch' using jar 'hdfs:///user/hive/udf/common_project-1.0-SNAPSHOT.jar'; ?
sqoop导入: sqoop import --connect jdbc:mysql://192.168.16.126:3306/sinohealth_test ?--username hefeng --password hefeng%123 --table student --fields-terminated-by '\t' ?--hive-import ?--hive-overwrite ?--hive-database sinohealth_test --hive-table student ?--null-string '\\N' ?--null-non-string '\\N'?
sqoop导出: sqoop export --connect jdbc:mysql://192.168.52.23:3306/test ?--username hefeng --password hefeng%123 --table student --fields-terminated-by '\t' ? ?--hcatalog-database sinohealth_test --hcatalog-table student ?
impala命令登陆: impala-shell -i hadoop04:21000 -u hive -l --auth_creds_ok_in_clear?
impala-shell -i hadoop04:21000 -u data_tool_hadoop -l --auth_creds_ok_in_clear?
 1.本站遵循行业规范，任何转载的稿件都会明确标注作者和来源；2.本站的原创文章，会注明原创字样,如未注明都非原创，如有侵权请联系删除！；3.作者投稿可能会经我们编辑修改或补充；4.本站不提供任何储存功能只提供收集或者投稿人的网盘链接。 |
标签： #impalahive自定义函数 #impalacreate #function #string #returns #double #location
