[
https://issues.apache.org/jira/browse/AMBARI-14827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15138671#comment-15138671
]
Gaurav Nagar commented on AMBARI-14827:
---------------------------------------
Handled null,empty and null value string in following way:
empty string - ""
null - null
string with value null - "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: 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)
