[jira] [Created] (AMBARI-14827) HiveViews: Value in cell coming up as null for select query

["Gaurav Nagar (JIRA)" <ji...@apache.org>]

Gaurav Nagar created AMBARI-14827:
-------------------------------------

             Summary: HiveViews: Value in cell coming up as null for select query
                 Key: AMBARI-14827
                 URL: https://issues.apache.org/jira/browse/AMBARI-14827
             Project: Ambari
          Issue Type: Bug
          Components: ambari-views
    Affects Versions: 2.2.1
            Reporter: Gaurav Nagar
            Assignee: Gaurav Nagar
             Fix For: 2.2.2


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. please see the screenshot attached

For incorrect values being inserted, the expected value in the cell was empty and not null. please help take a look.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)