[
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)