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

        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
        Hide
        Ashutosh Chauhan added a comment -

        Committed to trunk. Thanks, Thejas!

        Show
        Ashutosh Chauhan added a comment - Committed to trunk. Thanks, Thejas!
        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
        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 -

        Comments on RB.

        Show
        Ashutosh Chauhan added a comment - Comments on RB.
        Hide
        Thejas M Nair added a comment -
        Show
        Thejas M Nair added a comment - review board link - https://reviews.apache.org/r/10312/
        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.
        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.

          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