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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.1
• Fix Version/s: 2.2.2
• Component/s: ambari-views
• Assignee: Gaurav Nagar
• Reporter: Gaurav Nagar
• Created: 28/Jan/16 11:38
• Updated: 22/Feb/16 20:14
• Resolved: 22/Feb/16 17:22

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.

Issue Links

• links to: Apache Review Link