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

beeline prints null as empty strings

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.13.0
    • HiveServer2
    • None
    • Incompatible change
    • Hide
      This introduces a backward incompatible change.
      Earlier, null was getting printed as an empty string. There was no way to distinguish between an empty string an a null value.
      With this change null values will be printed as NULL.
      To get the old behavior you can set the property nullemptystring to values.
      This can be done via commandline argument : beeline --nullemptystring=true
      Or within the beeline shell
      > !set nullemptystring true
      Show
      This introduces a backward incompatible change. Earlier, null was getting printed as an empty string. There was no way to distinguish between an empty string an a null value. With this change null values will be printed as NULL. To get the old behavior you can set the property nullemptystring to values. This can be done via commandline argument : beeline --nullemptystring=true Or within the beeline shell > !set nullemptystring true

    Description

      beeline is printing nulls as emtpy strings. There was no way to distinguish between an empty string an a null value.
      This is inconsistent with hive cli and other databases, they print null as "NULL" string.

      Attachments

        1. HIVE-4485.1.patch
          9 kB
          Thejas Nair
        2. HIVE-4485.2.patch
          1 kB
          Thejas Nair
        3. HIVE-4485.3.patch
          13 kB
          Thejas Nair
        4. HIVE-4485.4.patch
          14 kB
          Thejas Nair

        Activity

          People

            thejas Thejas Nair
            thejas Thejas Nair
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: