Hive
  1. Hive
  2. HIVE-3840

hive cli null representation in output is inconsistent

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: None
    • Labels:
      None
    1. HIVE-3840.1.patch
      22 kB
      Thejas M Nair

      Issue Links

        Activity

        Ashutosh Chauhan created issue -
        Hide
        Ashutosh Chauhan added a comment -

        Currently, hive cli behavior is following:

        • It prints null valued primitive types (except binary) as NULL
        • Null binary column is printed as null
        • All null complex types are printed as null
        • All null primitive types within non-null complex types are printed as null

        This hive cli behavior is inconsistent with itself. MySQL prints NULL for all column type and we should do the same in all cases.

        Show
        Ashutosh Chauhan added a comment - Currently, hive cli behavior is following: It prints null valued primitive types (except binary) as NULL Null binary column is printed as null All null complex types are printed as null All null primitive types within non-null complex types are printed as null This hive cli behavior is inconsistent with itself. MySQL prints NULL for all column type and we should do the same in all cases.
        Thejas M Nair made changes -
        Field Original Value New Value
        Link This issue is duplicated by HIVE-4287 [ HIVE-4287 ]
        Hide
        Thejas M Nair added a comment -

        HIVE-3840.1.patch - Patch for making the null representation consistent. Uses 'NULL' for all datatypes.

        Show
        Thejas M Nair added a comment - HIVE-3840 .1.patch - Patch for making the null representation consistent. Uses 'NULL' for all datatypes.
        Thejas M Nair made changes -
        Attachment HIVE-3840.1.patch [ 12577253 ]
        Thejas M Nair made changes -
        Summary Printing NULL valued columns for different types in Hive cli hive cli null representation in output is inconsistent
        Thejas M Nair made changes -
        Assignee Thejas M Nair [ thejas ]
        Hide
        Thejas M Nair added a comment -
        Show
        Thejas M Nair added a comment - review board link - https://reviews.apache.org/r/10312/
        Thejas M Nair made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Hide
        Ashutosh Chauhan added a comment -

        Comments on RB.

        Show
        Ashutosh Chauhan added a comment - Comments on RB.
        Hide
        Thejas M Nair added a comment -

        Comments response on RB.

        Show
        Thejas M Nair added a comment - Comments response on RB.
        Hide
        Ashutosh Chauhan added a comment -

        +1 will commit if tests pass.

        Show
        Ashutosh Chauhan added a comment - +1 will commit if tests pass.
        Hide
        Ashutosh Chauhan added a comment -

        Committed to trunk. Thanks, Thejas!

        Show
        Ashutosh Chauhan added a comment - Committed to trunk. Thanks, Thejas!
        Ashutosh Chauhan made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Fix Version/s 0.11.0 [ 12323587 ]
        Resolution Fixed [ 1 ]
        Hide
        Hudson added a comment -

        Integrated in Hive-trunk-h0.21 #2049 (See https://builds.apache.org/job/Hive-trunk-h0.21/2049/)
        HIVE-3840 : hive cli null representation in output is inconsistent (Thejas Nair via Ashutosh Chauhan) (Revision 1465261)

        Result = ABORTED
        hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1465261
        Files :

        • /hive/trunk/ql/src/test/results/clientpositive/avro_nullable_fields.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/input17.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/input5.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/udf_percentile.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out
        • /hive/trunk/ql/src/test/results/clientpositive/udtf_stack.q.out
        • /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/DelimitedJSONSerDe.java
        • /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java
        Show
        Hudson added a comment - Integrated in Hive-trunk-h0.21 #2049 (See https://builds.apache.org/job/Hive-trunk-h0.21/2049/ ) HIVE-3840 : hive cli null representation in output is inconsistent (Thejas Nair via Ashutosh Chauhan) (Revision 1465261) Result = ABORTED hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1465261 Files : /hive/trunk/ql/src/test/results/clientpositive/avro_nullable_fields.q.out /hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out /hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out /hive/trunk/ql/src/test/results/clientpositive/input17.q.out /hive/trunk/ql/src/test/results/clientpositive/input5.q.out /hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out /hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out /hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out /hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out /hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out /hive/trunk/ql/src/test/results/clientpositive/udf_percentile.q.out /hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out /hive/trunk/ql/src/test/results/clientpositive/udtf_stack.q.out /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/DelimitedJSONSerDe.java /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java
        Owen O'Malley made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Patch Available Patch Available
        98d 19h 55m 1 Thejas M Nair 05/Apr/13 19:32
        Patch Available Patch Available Resolved Resolved
        20h 53m 1 Ashutosh Chauhan 06/Apr/13 16:26
        Resolved Resolved Closed Closed
        40d 5h 44m 1 Owen O'Malley 16/May/13 22:10

          People

          • Assignee:
            Thejas M Nair
            Reporter:
            Ashutosh Chauhan
          • Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development