Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22400

UDF minute with time returns NULL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1.0
    • Fix Version/s: 4.0.0
    • Component/s: UDF
    • Labels:
      None

      Description

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

        Attachments

        1. HIVE-22400.1.patch
          6 kB
          Naresh P R
        2. HIVE-22400.2.patch
          6 kB
          Naresh P R
        3. HIVE-22400.3.patch
          7 kB
          Naresh P R
        4. HIVE-22400.patch
          6 kB
          Naresh P R

          Activity

            People

            • Assignee:
              nareshpr Naresh P R
              Reporter:
              nikunj.limbaseeya Nikunj
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: