[
https://issues.apache.org/jira/browse/AMBARI-14827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gaurav Nagar updated AMBARI-14827:
----------------------------------
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.
was:
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.
> 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
>
> Attachments: Screen Shot 2016-01-27 at 2.26.23 PM.png
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
