You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Nikunj (Jira)" <ji...@apache.org> on 2019/10/24 13:44:00 UTC
[jira] [Created] (HIVE-22400) UDF minute with time returns NULL
Nikunj created HIVE-22400:
-----------------------------
Summary: UDF minute with time returns NULL
Key: HIVE-22400
URL: https://issues.apache.org/jira/browse/HIVE-22400
Project: Hive
Issue Type: Bug
Components: UDF
Affects Versions: 3.1.0
Reporter: Nikunj
[impadmin@impetus-g031 ~]$ beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.0.0-78/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.0.0-78/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://impetus-dsrv11.impetus.co.in:2181,ct-n0066.impetus.co.in:2181,ct-n0092.impetus.co.in:2181/default;principal=hive/_HOST@IMPETUS.CO.IN;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
19/10/24 19:03:42 [main]: INFO jdbc.HiveConnection: Connected to ct-n0092.impetus.co.in:10000
Connected to: Apache Hive (version 3.1.0.3.1.0.0-78)
Driver: Hive JDBC (version 3.1.0.3.1.0.0-78)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.0.3.1.0.0-78 by Apache Hive
0: jdbc:hive2://impetus-dsrv11.impetus.co.in:> select minute('12:58:59');
INFO : Compiling command(queryId=hive_20191024190401_bc517191-bd20-4f5a-b5f5-44f762c2d395): select minute('12:58:59')
INFO : Semantic Analysis Completed (retrial = false)
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0, type:int, comment:null)], properties:null)
INFO : Completed compiling command(queryId=hive_20191024190401_bc517191-bd20-4f5a-b5f5-44f762c2d395); Time taken: 0.427 seconds
INFO : Executing command(queryId=hive_20191024190401_bc517191-bd20-4f5a-b5f5-44f762c2d395): select minute('12:58:59')
INFO : Completed executing command(queryId=hive_20191024190401_bc517191-bd20-4f5a-b5f5-44f762c2d395); Time taken: 0.003 seconds
INFO : OK
+-------+
| _c0 |
+-------+
| NULL |
+-------+
1 row selected (0.739 seconds)
0: jdbc:hive2://impetus-dsrv11.impetus.co.in:>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)