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

beeline prints null as empty strings

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: HiveServer2
    • Labels:
      None
    • Hadoop Flags:
      Incompatible change
    • Release Note:
      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 M Nair
        2. HIVE-4485.2.patch
          1 kB
          Thejas M Nair
        3. HIVE-4485.3.patch
          13 kB
          Thejas M Nair
        4. HIVE-4485.4.patch
          14 kB
          Thejas M Nair

          Activity

            People

            • Assignee:
              thejas Thejas M Nair
              Reporter:
              thejas Thejas M Nair
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: