[jira] [Created] (KYLIN-1914) Insight page result grid view will eat whitechars

["hongbin ma (JIRA)" <ji...@apache.org>]

hongbin ma created KYLIN-1914:
---------------------------------

             Summary: Insight page result grid view will eat whitechars
                 Key: KYLIN-1914
                 URL: https://issues.apache.org/jira/browse/KYLIN-1914
             Project: Kylin
          Issue Type: Bug
            Reporter: hongbin ma
            Assignee: Zhong,Jason
            Priority: Minor


for query 

"select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
from v_lineorder
left join dates on lo_orderdate = d_datekey
left join customer on lo_custkey = c_custkey
left join supplier on lo_suppkey = s_suppkey
where (c_city='CHINA    065' or c_city='CHINA    123')
and (s_city='JAPAN    198' or s_city='JAPAN    123') and d_yearmonth like '%1997'
group by c_city, s_city, d_year
order by d_year asc, lo_revenue desc;
"

the c_city value has four white spaces in the middle,
however the result grid will simply display "CHINA 065",trimming three whitespaces.
As analylist will copy values from the grid view as the filter for the next query, it might be a issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)