[jira] [Created] (ZEPPELIN-3980) Zeppelin v0.8 incorrectly displays a '+' character in the result when querying a stored string in Hive DB

["Mohammed Arif (JIRA)" <ji...@apache.org>]

Mohammed Arif created ZEPPELIN-3980:
---------------------------------------

             Summary: Zeppelin v0.8 incorrectly displays a '+' character in the result when querying a stored string in Hive DB
                 Key: ZEPPELIN-3980
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-3980
             Project: Zeppelin
          Issue Type: Bug
          Components: front-end
    Affects Versions: 0.8.0
         Environment: %hive
SELECT row_id, 
x_home_mobile_ph    , concat('+',x_home_mobile_ph) as transf1, 
work_ph_num         , concat('+',work_ph_num) as transf2, 
cell_ph_num         , concat('+',cell_ph_num) as transf3, 
fax_ph_num          , concat('+',fax_ph_num) as transf4, 
x_home_fax_num      , concat('+',x_home_fax_num) as transf5, 
home_ph_num         , concat('+',home_ph_num) as transf6
FROM prod_XXXXXXXXX
where 
(
x_home_mobile_ph IS NOT NULL OR work_ph_num IS NOT NULL OR  cell_ph_num IS NOT NULL OR  fax_ph_num IS NOT NULL OR  x_home_fax_num IS NOT NULL OR  home_ph_num IS NOT NULL 
) limit 7
;
            Reporter: Mohammed Arif
         Attachments: ZeppelinV0_7.jpg, ZeppelinV0_8.jpg

While querying a table for phone numbers in Zeppelin v0.8 we see that the output displayed on hive interpreter is slightly different from the original content, when a plus (+) sign is concatenated in the query. The resultant displays two plus (+) signs leading to incorrect data output in CSV files.

If the plus (+) sign is not concatenated then the results displayed is just the phone numbers and nothing else.

 

Tried the same query in Zeppelin v0.7.3 but it displays results accurately. I am attaching the screenshots for Zeppelin v0.7.3 and v0.8 for reference, {color:#333333}Can someone help with any configuration changes which would help us resolve this issue?{color}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)