Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-14827

HiveViews: Value in cell coming up as null for select query

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.2.1
    • 2.2.2
    • ambari-views
    • None

    Description

      Executed the queries in hive view editor in the following order:
      set hive.execution.engine=tez;
      create table testtable61 (PersonID int, NameForSearch varchar(255), Name2 varchar(255));
      set hive.execution.engine=tez;
      create table testtable62 (PersonID int, NameForSearch varchar(255), Name2 varchar(255));
      set hive.execution.engine=tez;
      INSERT INTO TABLE testtable61 values('name','name0','secondname0');
      set hive.execution.engine=tez;
      INSERT INTO TABLE testtable61 values(1,'name1','secondname1');
      set hive.execution.engine=tez;
      INSERT INTO TABLE testtable61 values(2,'name2','secondname2');
      set hive.execution.engine=tez;
      SELECT * FROM testtable61;
      returns the three rows but the value 1 in columns1 shows as null. screenshot attached

      For incorrect values being inserted, the expected value in the cell was empty and not null.

      Attachments

        1. Screen Shot 2016-01-27 at 2.26.23 PM.png
          143 kB
          Gaurav Nagar
        2. AMBARI-14827.2_branch-2.2.patch
          1 kB
          Gaurav Nagar
        3. AMBARI-14827_branch-2.2.patch
          1 kB
          Gaurav Nagar

        Issue Links

          Activity

            People

              gnagar Gaurav Nagar
              gnagar Gaurav Nagar
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: