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)
