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

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

     [ https://issues.apache.org/jira/browse/AMBARI-14827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gaurav Nagar updated AMBARI-14827:
----------------------------------
    Attachment: AMBARI-14827.2_branch-2.2.patch

> 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: AMBARI-14827.2_branch-2.2.patch, AMBARI-14827_branch-2.2.patch, 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)