[
https://issues.apache.org/jira/browse/KYLIN-1914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shao Feng Shi reassigned KYLIN-1914:
------------------------------------
Component/s: Web
Assignee: (was: Jason Zhong)
Labels: newbie (was: )
> 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
> Components: Web
> Reporter: Hongbin Ma
> Priority: Minor
> Labels: newbie
>
> 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
(v8.3.4#803005)
