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

hive cli null representation in output is inconsistent

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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
        ashutoshc 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
        ashutoshc 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.
        Hide
        thejas Thejas M Nair added a comment -

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

        Show
        thejas Thejas M Nair added a comment - HIVE-3840 .1.patch - Patch for making the null representation consistent. Uses 'NULL' for all datatypes.
        Hide
        thejas Thejas M Nair added a comment -
        Show
        thejas Thejas M Nair added a comment - review board link - https://reviews.apache.org/r/10312/
        Hide
        ashutoshc Ashutosh Chauhan added a comment -

        Comments on RB.

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

        Comments response on RB.

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

        +1 will commit if tests pass.

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

        Committed to trunk. Thanks, Thejas!

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

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development