[ 
https://issues.apache.org/jira/browse/HIVE-12540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032866#comment-15032866
 ] 

Weizhong commented on HIVE-12540:
---------------------------------

create failed is cause by class not found
{noformat}
2015-11-30 21:16:20,663 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
parse.ParseDriver (ParseDriver.java:parse(185)) - Parsing command: create 
function udfTest as 'hive.udf.UDFArrayNotE'
2015-11-30 21:16:20,663 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
parse.ParseDriver (ParseDriver.java:parse(209)) - Parse Completed
2015-11-30 21:16:20,664 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG method=parse 
start=1448889380662 end=1448889380664 duration=2 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,664 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG 
method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,665 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
metastore.HiveMetaStore (HiveMetaStore.java:logInfo(744)) - 1: get_database: 
default
2015-11-30 21:16:20,665 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(369)) - ugi=root     
ip=unknown-ip-addr      cmd=get_database: default       
2015-11-30 21:16:20,675 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
parse.FunctionSemanticAnalyzer 
(FunctionSemanticAnalyzer.java:analyzeInternal(66)) - analyze done
2015-11-30 21:16:20,676 INFO  [HiveServer2-Handler-Pool: Thread-30]: ql.Driver 
(Driver.java:compile(436)) - Semantic Analysis Completed
2015-11-30 21:16:20,676 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG 
method=semanticAnalyze start=1448889380664 end=1448889380676 duration=12 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,676 INFO  [HiveServer2-Handler-Pool: Thread-30]: ql.Driver 
(Driver.java:getSchema(240)) - Returning Hive schema: Schema(fieldSchemas:null, 
properties:null)
2015-11-30 21:16:20,677 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG method=compile 
start=1448889380661 end=1448889380677 duration=16 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,680 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG method=Driver.run 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,680 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG 
method=TimeToSubmit from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,680 INFO  [HiveServer2-Background-Pool: Thread-61]: 
ql.Driver (Driver.java:checkConcurrency(160)) - Concurrency mode is disabled, 
not creating a lock manager
2015-11-30 21:16:20,680 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG 
method=Driver.execute from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,681 INFO  [HiveServer2-Background-Pool: Thread-61]: 
ql.Driver (Driver.java:execute(1325)) - Starting 
command(queryId=root_20151130211620_28d28a3b-28e2-4677-a702-c7953553929d): 
create function udfTest as 'hive.udf.UDFArrayNotE'
2015-11-30 21:16:20,681 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG 
method=TimeToSubmit start=1448889380680 end=1448889380681 duration=1 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,681 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG method=runTasks 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,681 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG 
method=task.FUNCTION.Stage-0 from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,682 INFO  [HiveServer2-Background-Pool: Thread-61]: 
ql.Driver (Driver.java:launchTask(1648)) - Starting task [Stage-0:FUNC] in 
serial mode
2015-11-30 21:16:20,684 ERROR [HiveServer2-Background-Pool: Thread-61]: 
exec.FunctionRegistry (Registry.java:registerToSessionRegistry(468)) - Unable 
to load UDF class: java.lang.ClassNotFoundException: hive.udf.UDFArrayNotE
2015-11-30 21:16:20,684 ERROR [HiveServer2-Background-Pool: Thread-61]: 
exec.Task (SessionState.java:printError(957)) - Failed to register 
default.udftest using class hive.udf.UDFArrayNotE
2015-11-30 21:16:20,685 ERROR [HiveServer2-Background-Pool: Thread-61]: 
ql.Driver (SessionState.java:printError(957)) - FAILED: Execution Error, return 
code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask
2015-11-30 21:16:20,686 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG 
method=Driver.execute start=1448889380680 end=1448889380686 duration=6 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,686 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG 
method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,686 INFO  [HiveServer2-Background-Pool: Thread-61]: 
log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG 
method=releaseLocks start=1448889380686 end=1448889380686 duration=0 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,686 ERROR [HiveServer2-Background-Pool: Thread-61]: 
operation.Operation (SQLOperation.java:run(209)) - Error running hive query: 
org.apache.hive.service.cli.HiveSQLException: Error while processing statement: 
FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.FunctionTask
        at 
org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:315)
        at 
org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:156)
        at 
org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:71)
        at 
org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:206)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:422)
        at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
        at 
org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:218)
        at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
2015-11-30 21:16:20,691 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG 
method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:20,692 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG 
method=releaseLocks start=1448889380691 end=1448889380692 duration=1 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:23,350 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG method=compile 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:23,352 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG method=parse 
from=org.apache.hadoop.hive.ql.Driver>
2015-11-30 21:16:23,352 INFO  [HiveServer2-Handler-Pool: Thread-30]: 
parse.ParseDriver (ParseDriver.java:parse(185)) - Parsing command: show 
functions

{noformat}

> Create function failed, but show functions display it
> -----------------------------------------------------
>
>                 Key: HIVE-12540
>                 URL: https://issues.apache.org/jira/browse/HIVE-12540
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 1.2.0, 1.2.1
>            Reporter: Weizhong
>            Priority: Minor
>
> {noformat}
> 0: jdbc:hive2://vm119:10000> create function udfTest as 
> 'hive.udf.UDFArrayNotE';
> ERROR : Failed to register default.udftest using class hive.udf.UDFArrayNotE
> Error: Error while processing statement: FAILED: Execution Error, return code 
> 1 from org.apache.hadoop.hive.ql.exec.FunctionTask (state=08S01,code=1)
> 0: jdbc:hive2://vm119:10000> show functions;
> +-------------------------+--+
> |        tab_name         |
> +-------------------------+--+
> | ...                     |
> | default.udftest         |
> | ...                     |
> +-------------------------+--+
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to