ToLower自定义函数hive

K
Time taken: 0.082 seconds
hive> select  ToLower("DDDDg")  from t_1;
FAILED: SemanticException [Error 10001]: Line 1:31 Table not found 't_1'
hive> select  ToLower("DDDDg")  from t1;
OK
Time taken: 1.589 seconds
hive> select  ToLower(" ")  from t1;
OK
Time taken: 0.06 seconds
hive> select  ToLower(" ")  from dual;
FAILED: SemanticException [Error 10001]: Line 1:27 Table not found 'dual'
hive> desc t1;
OK
id                   string                                  
name                 string                                  
Time taken: 0.085 seconds, Fetched: 2 row(s)
hive> select  ToLower("DDDDg")  from t1;
OK
Time taken: 0.078 seconds
hive> select  ToLower(name)  from t1;
OK
Time taken: 0.063 seconds
hive> add jar /home/wangshumin/hive/ToLower.jar
    > add jar /home/wangshumin/hive/ToLower.jar;
add does not exist
Query returned non-zero code: 1, cause: add does not exist
hive> add jar /home/wangshumin/hive/ToLower.jar;
Added [/home/wangshumin/hive/ToLower.jar] to class path
Added resources: [/home/wangshumin/hive/ToLower.jar]
hive> add jar /home/wangshumin/hive/ToLower.jar;
Added [/home/wangshumin/hive/ToLower.jar] to class path
Added resources: [/home/wangshumin/hive/ToLower.jar]
hive> add jar /home/wangshumin/hive/ToLower.jar;
Added [/home/wangshumin/hive/ToLower.jar] to class path
Added resources: [/home/wangshumin/hive/ToLower.jar]
hive> create temporary  function  ToLoweree as "hive.UDF.ToLower"
    > ;
OK
Time taken: 0.007 seconds
hive> create temporary  function  ToLoweree as "hive.UDF.ToLower";
OK
Time taken: 0.006 seconds
hive> select  ToLoweree(name)  from t1;
OK
Time taken: 0.066 seconds
hive> create temporary function tolowercase as "hive.UDF.ToLower"
    > ;
OK
Time taken: 0.005 seconds
hive> select  ToLoweree("")  from t1;
OK
Time taken: 0.063 seconds
hive> add  jar  /home/wangshumin/hive/ToLower.jar;
Added [/home/wangshumin/hive/ToLower.jar] to class path
Added resources: [/home/wangshumin/hive/ToLower.jar]
hive> create temporary function ToLower as "hive.UDF.ToLower" ;
OK
Time taken: 0.012 seconds
hive> select  ToLower("")  from   t1；
    > ；
    > ;
FAILED: ParseException line 1:30 character '；' not supported here
line 2:0 character '；' not supported here
hive> select  ToLower("")  from   t1;
OK
Time taken: 0.105 seconds
hive> select  ToLower("ddddFFF")  from   t1;
OK
Time taken: 0.071 seconds
hive> add  jar  /home/wangshumin/hive/ToLower1.jar;
Added [/home/wangshumin/hive/ToLower1.jar] to class path
Added resources: [/home/wangshumin/hive/ToLower1.jar]
hive> create temporary function ToLower1 as "hive.UDF.ToLower" ;
OK
Time taken: 0.006 seconds
hive> select * from  t1 ;
OK
Time taken: 0.063 seconds

hive>  insert into t1 (id,name) values ( 2,"joker" );
Query ID = wangshumin_20180320191440_fe1ae827-57f1-4d93-91de-428368b760a9
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1521538874183_0004, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1521538874183_0004/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1521538874183_0004
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2018-03-20 19:15:06,539 Stage-1 map = 0%,  reduce = 0%
2018-03-20 19:15:17,153 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 1.16 sec
MapReduce Total cumulative CPU time: 1 seconds 160 msec
Ended Job = job_1521538874183_0004
Stage-4 is selected by condition resolver.
Stage-3 is filtered out by condition resolver.
Stage-5 is filtered out by condition resolver.
Moving data to: hdfs://centoshostnameKL1:9000/user/hive/warehouse/db1.db/t1/.hive-staging_hive_2018-03-20_19-14-40_197_6479838724087111090-1/-ext-10000
Loading data to table db1.t1
Table db1.t1 stats: [numFiles=1, numRows=3, totalSize=8, rawDataSize=32]
MapReduce Jobs Launched: 
Stage-Stage-1: Map: 1   Cumulative CPU: 1.16 sec   HDFS Read: 3529 HDFS Write: 70 SUCCESS
Total MapReduce CPU Time Spent: 1 seconds 160 msec
OK
Time taken: 38.759 seconds
hive> select * from  t1 ;
OK
2 joker
Time taken: 0.149 seconds, Fetched: 1 row(s)
hive>  insert into t1 (id,name) values ( 1,"joker1" );
Query ID = wangshumin_20180320191537_994c7ae4-80e7-4145-a622-a0de96d7dc19
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1521538874183_0005, Tracking URL = http://centoshostnameKL1:8088/proxy/application_1521538874183_0005/
Kill Command = /home/wangshumin/app/hadoop-2.4.1/bin/hadoop job  -kill job_1521538874183_0005
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2018-03-20 19:15:59,398 Stage-1 map = 0%,  reduce = 0%
2018-03-20 19:16:11,509 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 0.95 sec
MapReduce Total cumulative CPU time: 950 msec
Ended Job = job_1521538874183_0005
Stage-4 is selected by condition resolver.
Stage-3 is filtered out by condition resolver.
Stage-5 is filtered out by condition resolver.
Moving data to: hdfs://centoshostnameKL1:9000/user/hive/warehouse/db1.db/t1/.hive-staging_hive_2018-03-20_19-15-37_079_1424094808828331594-1/-ext-10000
Loading data to table db1.t1
Table db1.t1 stats: [numFiles=2, numRows=4, totalSize=17, rawDataSize=40]
MapReduce Jobs Launched: 
Stage-Stage-1: Map: 1   Cumulative CPU: 0.95 sec   HDFS Read: 3530 HDFS Write: 71 SUCCESS
Total MapReduce CPU Time Spent: 950 msec
OK
Time taken: 36.2 seconds
hive> select * from  t1 ;
OK
2 joker
1 joker1
Time taken: 0.062 seconds, Fetched: 2 row(s)
hive> select  ToLoweree("ddddFFF")  from   t1;
OK
ddddfff
ddddfff
Time taken: 0.082 seconds, Fetched: 2 row(s)
hive> select  ToLoweree(" ")  from   t1;
OK
 
 
Time taken: 0.062 seconds, Fetched: 2 row(s)
hive> select  ToLoweree()  from   t1;
FAILED: SemanticException [Error 10014]: Line 1:8 Wrong arguments 'ToLoweree': No matching method for class hive.UDF.ToLower with (). Possible choices: _FUNC_(string)  
hive> select  ToLoweree(null)  from   t1;
OK
我是王树民，告诉你的函数参数值为空！
我是王树民，告诉你的函数参数值为空！
Time taken: 0.115 seconds, Fetched: 2 row(s)
hive> select  ToLoweree(null)  from   t1;
OK