[ https://issues.apache.org/jira/browse/HIVE-22400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-22400: ------------------------------------------- Fix Version/s: 4.0.0 Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master, thanks [~nareshpr]! > 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 > Fix For: 4.0.0 > > 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)