[
https://issues.apache.org/jira/browse/HIVE-22400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17015233#comment-17015233
]
Jesus Camacho Rodriguez commented on HIVE-22400:
------------------------------------------------
+1
> 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
> Assignee: Naresh P R
> Priority: Minor
> Attachments: HIVE-22400.1.patch, HIVE-22400.2.patch,
> HIVE-22400.3.patch, HIVE-22400.patch
>
>
> [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/_h...@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)
