[jira] [Created] (KYLIN-2890) Integrate find security bugs plugin

2017-09-21 Thread Ted Yu (JIRA)
Ted Yu created KYLIN-2890:
-

 Summary: Integrate find security bugs plugin
 Key: KYLIN-2890
 URL: https://issues.apache.org/jira/browse/KYLIN-2890
 Project: Kylin
  Issue Type: Improvement
Reporter: Ted Yu


We should see if the [Find Security Bugs|http://find-sec-bugs.github.io/] 
plugin for FindBugs works.





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Commented] (KYLIN-2841) LIMIT is buggy with subquery

2017-09-21 Thread zhengdong (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16174573#comment-16174573
 ] 

zhengdong commented on KYLIN-2841:
--

Hi kangkaisen, thanks for your comment.
The patch try to fix this issue by ignoring the limit clause after outer 
aggregation. 
However, {{context.afterAggregate}} should always be {{true}} for 
{{OLAPLimitRel}} if a query has aggregation function, and it  couldn't indicate 
whether to ignore the limit clause.

> LIMIT is buggy with subquery
> 
>
> Key: KYLIN-2841
> URL: https://issues.apache.org/jira/browse/KYLIN-2841
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: v2.1.0
>Reporter: Mu Kong
>Assignee: zhengdong
>  Labels: scope
> Attachments: 0001-KYLIN-2841-LIMIT-is-buggy-with-subquery.patch
>
>
> Hi, all.
> I found that limit in the web UI seems not behaving as expected.
> When I run a query like the follows:
> {code:sql}
> SELECT
>   SUM(col3) AS col4, 
>   SUM(col5) AS total_col5,
>   col1 
> FROM
> (
>   SELECT
> col1,
> col2,
> MAX(col3) AS col3,
> COUNT(*) AS col5
>   FROM db.table
>   WHERE col6 = 'somestring'
>   GROUP BY col1, col2
> )
> GROUP BY col1
> {code}
> When I specify the limit as 50, the result has 19 records, and when I specify 
> the limit as 50, there are 90+ records in the result and each record has 
> higher col4 and total_col5.
> But for query that doesn't have subquery, the result remains the same no 
> matter how I change the limit.
> I guess for the query with subquery, limit somehow limits the number of the 
> result from the inner query instead of the result of the outer query.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2881) Improve hbase coprocessor exception handling at kylin server side

2017-09-21 Thread Zhong Yanghong (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhong Yanghong updated KYLIN-2881:
--
Description: 
A query may need a bunch of hconnections to visit hbase. Anyone of them fails, 
the whole query should be interrupted, and all of the related hconnections 
should be released for future other queries despite that currently we cannot 
interrupt the threads at hbase coprocessor side.

To achieve this goal, one property is added to QueryContext to keep 
{{Throwable}}. If any sub-step during the query detects this {{Throwable}}, it 
should stop. In {{ExpectedSizeIterator}}, there are two parts where this 
detection is needed.
* before putting data to the queue
* during iteration

If exception happens during a query, it should stop its related threads. Thus, 
{{QueryStopListener}} is added for this.

  was:
A query may need a bunch of hconnections to visit hbase. Anyone of them fails, 
the whole query should be interrupted, and all of the related hconnections 
should be released for future other queries despite that currently we cannot 
interrupt the threads at hbase coprocessor side.

To achieve this goal, there're still some improvements:
* Before putting data to the queue of {{ExpectedSizeIterator}}, check whether 
it's timeout & whether exception exist.
* If any exception found in {{ExpectedSizeIterator}}, the callback of 
coprocessor call should be return early.


> Improve hbase coprocessor exception handling at kylin server side 
> --
>
> Key: KYLIN-2881
> URL: https://issues.apache.org/jira/browse/KYLIN-2881
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: v2.1.0
>Reporter: Zhong Yanghong
>Assignee: Zhong Yanghong
> Fix For: v2.2.0
>
>
> A query may need a bunch of hconnections to visit hbase. Anyone of them 
> fails, the whole query should be interrupted, and all of the related 
> hconnections should be released for future other queries despite that 
> currently we cannot interrupt the threads at hbase coprocessor side.
> To achieve this goal, one property is added to QueryContext to keep 
> {{Throwable}}. If any sub-step during the query detects this {{Throwable}}, 
> it should stop. In {{ExpectedSizeIterator}}, there are two parts where this 
> detection is needed.
> * before putting data to the queue
> * during iteration
> If exception happens during a query, it should stop its related threads. 
> Thus, {{QueryStopListener}} is added for this.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Created] (KYLIN-2887) Subquery columns not exported in OLAPContext allColumns

2017-09-21 Thread Roger Shi (JIRA)
Roger Shi created KYLIN-2887:


 Summary: Subquery columns not exported in OLAPContext allColumns
 Key: KYLIN-2887
 URL: https://issues.apache.org/jira/browse/KYLIN-2887
 Project: Kylin
  Issue Type: Bug
Reporter: Roger Shi


Query like this returns empty value, because olap context allColumns field 
isn't set rightly.

```sql
select c.COUNTRY, c.NAME,b.TRANS_ID, b.BUYER_ID from KYLIN_COUNTRY c join (
select * from KYLIN_SALES s join KYLIN_ACCOUNT a on s.SELLER_ID = 
a.ACCOUNT_ID where a.ACCOUNT_ID <= 1866
   ) b on b.ACCOUNT_COUNTRY = c.COUNTRY
```



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Attachment: 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch

> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keywords will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips should be as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keywords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Attachment: (was: 
0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch)

> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keywords will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips should be as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keywords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Description: 
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The keywords will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips should be as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keywords in query box.

  was:
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The keykwords will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips should be as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keywords in query box.


> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keywords will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips should be as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keywords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Description: 
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The keykwords will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips should be as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keywords in query box.

  was:
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The keykwords will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips should be as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords in query box.


> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keykwords will be list when we press Alt+Space in windows. 
> Please refer to 1.jpg.
> So the right tips should be as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keywords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Attachment: (was: 
0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch)

> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keykwords will be list when we press Alt+Space in windows. 
> Please refer to 1.jpg.
> So the right tips should be as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Attachment: 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch

> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keykwords will be list when we press Alt+Space in windows. 
> Please refer to 1.jpg.
> So the right tips should be as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Closed] (KYLIN-2885) export csv file error

2017-09-21 Thread lynn (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

lynn closed KYLIN-2885.
---
   Resolution: Duplicate
Fix Version/s: Future

repeated!!!

> export csv file error
> -
>
> Key: KYLIN-2885
> URL: https://issues.apache.org/jira/browse/KYLIN-2885
> Project: Kylin
>  Issue Type: Bug
>  Components: REST Service
>Reporter: lynn
>Assignee: Zhong,Jason
> Fix For: Future
>
> Attachments: 1.png, 21.png
>
>
> SQL:
> select price, sell_id from kylin_sales order by part_dt compute max(price) by 
> sell_id;
> when i run a "compute by sub statement",obviously, it does not support the 
> statement.
> !1.png|thumbnail!
> It doesn't matter! But when i want to export the results which  previously 
> executed successfully to the csv file, it still throws exception!
> !21.png|thumbnail!
> REST Service return message:
> {
> "code": "999",
> "data": null,
> "msg": "Encountered \"compute\" at line 1, column 57. Was expecting one 
> of:   \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... 
> \",\" ... \"ASC\" ... \"DESC\" ... \"NULLS\" ... \"NOT\" ...  
>\"IN\" ... \"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... 
> \"=\" ... \">\" ... \"<\" ... \"<=\" ... \">=\" ... 
> \"<>\" ... \"!=\" ... \"+\" ... \"-\" ... \"*\" ... \"/\" 
> ... \"||\" ... \"AND\" ... \"OR\" ... \"IS\" ... 
> \"MEMBER\" ... \"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... 
> \".\" ... \"(\" ... ",
> "stacktrace": "org.apache.kylin.rest.exception.InternalErrorException: 
> Encountered \"compute\" at line 1, column 57. Was expecting one of:  
>  \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... \",\" ... 
> \"ASC\" ... \"DESC\" ... \"NULLS\" ... \"NOT\" ... \"IN\" ... 
> \"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... \"=\" ... 
> \">\" ... \"<\" ... \"<=\" ... \">=\" ... \"<>\" ... 
> \"!=\" ... \"+\" ... \"-\" ... \"*\" ... \"/\" ... \"||\" 
> ... \"AND\" ... \"OR\" ... \"IS\" ... \"MEMBER\" ... 
> \"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... \".\" ... 
> \"(\" ... \n\tat 
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)\n\tat
>  
> org.apache.kylin.rest.controller.QueryController.downloadQueryResult(QueryController.java:121)\n\tat
>  sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat
>  
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat
>  java.lang.reflect.Method.invoke(Method.java:498)\n\tat 
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)\n\tat
>  
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\n\tat
>  
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)\n\tat
>  
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)\n\tat
>  
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)\n\tat
>  
> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat
>  
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)\n\tat
>  
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)\n\tat
>  
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)\n\tat
>  
> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)\n\tat
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:624)\n\tat 
> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)\n\tat
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:731)\n\tat 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat
>  
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
>  org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat
>  
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
>  
> 

[jira] [Commented] (KYLIN-2841) LIMIT is buggy with subquery

2017-09-21 Thread kangkaisen (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16174348#comment-16174348
 ] 

kangkaisen commented on KYLIN-2841:
---

Hi, [~zhengd] Thanks you.

I think maybe  we use context.afterAggregate is enough and needn't add a 
afterOuterAggregate variable.  What do you think of it?

> LIMIT is buggy with subquery
> 
>
> Key: KYLIN-2841
> URL: https://issues.apache.org/jira/browse/KYLIN-2841
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: v2.1.0
>Reporter: Mu Kong
>Assignee: zhengdong
>  Labels: scope
> Attachments: 0001-KYLIN-2841-LIMIT-is-buggy-with-subquery.patch
>
>
> Hi, all.
> I found that limit in the web UI seems not behaving as expected.
> When I run a query like the follows:
> {code:sql}
> SELECT
>   SUM(col3) AS col4, 
>   SUM(col5) AS total_col5,
>   col1 
> FROM
> (
>   SELECT
> col1,
> col2,
> MAX(col3) AS col3,
> COUNT(*) AS col5
>   FROM db.table
>   WHERE col6 = 'somestring'
>   GROUP BY col1, col2
> )
> GROUP BY col1
> {code}
> When I specify the limit as 50, the result has 19 records, and when I specify 
> the limit as 50, there are 90+ records in the result and each record has 
> higher col4 and total_col5.
> But for query that doesn't have subquery, the result remains the same no 
> matter how I change the limit.
> I guess for the query with subquery, limit somehow limits the number of the 
> result from the inner query instead of the result of the outer query.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2886) export csv file error

2017-09-21 Thread lynn (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

lynn updated KYLIN-2886:

Description: 
SQL:
select price, sell_id from kylin_sales order by sell_id compute max(price) by 
sell_id;

when i run a "compute by sub statement",obviously, it does not support the 
statement.
!1.png|thumbnail!

It doesn't matter! But when i want to export the results which  previously 
executed successfully to the csv file, it still throws exception!
!21.png|thumbnail!

REST Service return message:
{
"code": "999",
"data": null,
"msg": "Encountered \"compute\" at line 1, column 57. Was expecting one of: 
  \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... \",\" ... 
\"ASC\" ... \"DESC\" ... \"NULLS\" ... \"NOT\" ... \"IN\" 
... \"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... \"=\" ... 
\">\" ... \"<\" ... \"<=\" ... \">=\" ... \"<>\" ... \"!=\" 
... \"+\" ... \"-\" ... \"*\" ... \"/\" ... \"||\" ... 
\"AND\" ... \"OR\" ... \"IS\" ... \"MEMBER\" ... 
\"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... \".\" ... \"(\" 
... ",
"stacktrace": "org.apache.kylin.rest.exception.InternalErrorException: 
Encountered \"compute\" at line 1, column 57. Was expecting one of:
   \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... \",\" ... \"ASC\" 
... \"DESC\" ... \"NULLS\" ... \"NOT\" ... \"IN\" ... 
\"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... \"=\" ... \">\" 
... \"<\" ... \"<=\" ... \">=\" ... \"<>\" ... \"!=\" ...   
  \"+\" ... \"-\" ... \"*\" ... \"/\" ... \"||\" ... 
\"AND\" ... \"OR\" ... \"IS\" ... \"MEMBER\" ... 
\"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... \".\" ... \"(\" 
... \n\tat 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)\n\tat
 
org.apache.kylin.rest.controller.QueryController.downloadQueryResult(QueryController.java:121)\n\tat
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat
 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat
 java.lang.reflect.Method.invoke(Method.java:498)\n\tat 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)\n\tat
 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)\n\tat
 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat
 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)\n\tat
 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)\n\tat
 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)\n\tat
 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)\n\tat
 javax.servlet.http.HttpServlet.service(HttpServlet.java:624)\n\tat 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)\n\tat
 javax.servlet.http.HttpServlet.service(HttpServlet.java:731)\n\tat 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat
 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat
 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)\n\tat
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n\tat
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n\tat
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\n\tat
 
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)\n\tat
 

[jira] [Created] (KYLIN-2886) export csv file error

2017-09-21 Thread lynn (JIRA)
lynn created KYLIN-2886:
---

 Summary: export csv file error
 Key: KYLIN-2886
 URL: https://issues.apache.org/jira/browse/KYLIN-2886
 Project: Kylin
  Issue Type: Bug
  Components: REST Service
Reporter: lynn
Assignee: Zhong,Jason
 Attachments: 1.png, 21.png

SQL:
select price, sell_id from kylin_sales order by part_dt compute max(price) by 
sell_id;

when i run a "compute by sub statement",obviously, it does not support the 
statement.
!1.png|thumbnail!

It doesn't matter! But when i want to export the results which  previously 
executed successfully to the csv file, it still throws exception!
!21.png|thumbnail!

REST Service return message:
{
"code": "999",
"data": null,
"msg": "Encountered \"compute\" at line 1, column 57. Was expecting one of: 
  \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... \",\" ... 
\"ASC\" ... \"DESC\" ... \"NULLS\" ... \"NOT\" ... \"IN\" 
... \"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... \"=\" ... 
\">\" ... \"<\" ... \"<=\" ... \">=\" ... \"<>\" ... \"!=\" 
... \"+\" ... \"-\" ... \"*\" ... \"/\" ... \"||\" ... 
\"AND\" ... \"OR\" ... \"IS\" ... \"MEMBER\" ... 
\"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... \".\" ... \"(\" 
... ",
"stacktrace": "org.apache.kylin.rest.exception.InternalErrorException: 
Encountered \"compute\" at line 1, column 57. Was expecting one of:
   \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... \",\" ... \"ASC\" 
... \"DESC\" ... \"NULLS\" ... \"NOT\" ... \"IN\" ... 
\"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... \"=\" ... \">\" 
... \"<\" ... \"<=\" ... \">=\" ... \"<>\" ... \"!=\" ...   
  \"+\" ... \"-\" ... \"*\" ... \"/\" ... \"||\" ... 
\"AND\" ... \"OR\" ... \"IS\" ... \"MEMBER\" ... 
\"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... \".\" ... \"(\" 
... \n\tat 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)\n\tat
 
org.apache.kylin.rest.controller.QueryController.downloadQueryResult(QueryController.java:121)\n\tat
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat
 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat
 java.lang.reflect.Method.invoke(Method.java:498)\n\tat 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)\n\tat
 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)\n\tat
 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat
 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)\n\tat
 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)\n\tat
 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)\n\tat
 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)\n\tat
 javax.servlet.http.HttpServlet.service(HttpServlet.java:624)\n\tat 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)\n\tat
 javax.servlet.http.HttpServlet.service(HttpServlet.java:731)\n\tat 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat
 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat
 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)\n\tat
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n\tat
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n\tat
 

[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Description: 
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The keykwords will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips should be as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords in query box.

  was:
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The keykwords will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips is as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords in query box.


> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keykwords will be list when we press Alt+Space in windows. 
> Please refer to 1.jpg.
> So the right tips should be as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Description: 
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The keykwords will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips is as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords in query box.

  was:
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The shortcut will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips is as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords in query box.


> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The keykwords will be list when we press Alt+Space in windows. 
> Please refer to 1.jpg.
> So the right tips is as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Comment Edited] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16174336#comment-16174336
 ] 

peng.jianhua edited comment on KYLIN-2870 at 9/21/17 6:30 AM:
--

Hi [~liyang.g...@gmail.com]. my description may mislead you, I have changed the 
description, please help review again after I update the patch. Thanks.


was (Author: peng.jianhua):
Hi [~liyang.g...@gmail.com]. my description may mislead you, I have changed the 
description, please help review again after updating the patch. Thanks.

> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The shortcut will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips is as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Comment Edited] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16174336#comment-16174336
 ] 

peng.jianhua edited comment on KYLIN-2870 at 9/21/17 6:30 AM:
--

Hi [~liyang.g...@gmail.com]. my description may mislead you, I have changed the 
description, please help review again after updating the patch. Thanks.


was (Author: peng.jianhua):
Hi [~liyang.g...@gmail.com]. my description may mislead you, I have changed the 
description, please help review again. Thanks.

> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The shortcut will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips is as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Commented] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16174336#comment-16174336
 ] 

peng.jianhua commented on KYLIN-2870:
-

Hi [~liyang.g...@gmail.com]. my description may mislead you, I have changed the 
description, please help review again. Thanks.

> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The shortcut will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips is as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Created] (KYLIN-2885) export csv file error

2017-09-21 Thread lynn (JIRA)
lynn created KYLIN-2885:
---

 Summary: export csv file error
 Key: KYLIN-2885
 URL: https://issues.apache.org/jira/browse/KYLIN-2885
 Project: Kylin
  Issue Type: Bug
  Components: REST Service
Reporter: lynn
Assignee: Zhong,Jason
 Attachments: 1.png, 21.png

SQL:
select price, sell_id from kylin_sales order by part_dt compute max(price) by 
sell_id;

when i run a "compute by sub statement",obviously, it does not support the 
statement.
!1.png|thumbnail!

It doesn't matter! But when i want to export the results which  previously 
executed successfully to the csv file, it still throws exception!
!21.png|thumbnail!

REST Service return message:
{
"code": "999",
"data": null,
"msg": "Encountered \"compute\" at line 1, column 57. Was expecting one of: 
  \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... \",\" ... 
\"ASC\" ... \"DESC\" ... \"NULLS\" ... \"NOT\" ... \"IN\" 
... \"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... \"=\" ... 
\">\" ... \"<\" ... \"<=\" ... \">=\" ... \"<>\" ... \"!=\" 
... \"+\" ... \"-\" ... \"*\" ... \"/\" ... \"||\" ... 
\"AND\" ... \"OR\" ... \"IS\" ... \"MEMBER\" ... 
\"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... \".\" ... \"(\" 
... ",
"stacktrace": "org.apache.kylin.rest.exception.InternalErrorException: 
Encountered \"compute\" at line 1, column 57. Was expecting one of:
   \"LIMIT\" ... \"OFFSET\" ... \"FETCH\" ... \",\" ... \"ASC\" 
... \"DESC\" ... \"NULLS\" ... \"NOT\" ... \"IN\" ... 
\"BETWEEN\" ... \"LIKE\" ... \"SIMILAR\" ... \"=\" ... \">\" 
... \"<\" ... \"<=\" ... \">=\" ... \"<>\" ... \"!=\" ...   
  \"+\" ... \"-\" ... \"*\" ... \"/\" ... \"||\" ... 
\"AND\" ... \"OR\" ... \"IS\" ... \"MEMBER\" ... 
\"SUBMULTISET\" ... \"MULTISET\" ... \"[\" ... \".\" ... \"(\" 
... \n\tat 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440)\n\tat
 
org.apache.kylin.rest.controller.QueryController.downloadQueryResult(QueryController.java:121)\n\tat
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat
 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat
 java.lang.reflect.Method.invoke(Method.java:498)\n\tat 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)\n\tat
 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)\n\tat
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)\n\tat
 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat
 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)\n\tat
 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)\n\tat
 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)\n\tat
 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)\n\tat
 javax.servlet.http.HttpServlet.service(HttpServlet.java:624)\n\tat 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)\n\tat
 javax.servlet.http.HttpServlet.service(HttpServlet.java:731)\n\tat 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat
 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat
 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)\n\tat
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n\tat
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n\tat
 

[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Description: 
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The shortcut will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips is as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords in query box.

  was:
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The shortcut will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips is as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords list in query box.


> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The shortcut will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips is as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Updated] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-21 Thread peng.jianhua (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

peng.jianhua updated KYLIN-2870:

Description: 
Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space to 
create a sql.
The current tips is as following:
Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
table/columns in query box.

In fact, The shortcut will be list when we press Alt+Space in windows. Please 
refer to 1.jpg.

So the right tips is as following:
Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
keykwords list in query box.

  was:
Shortcut key description is error at Kylin-Web,when i click Ctrl+Shift+Space to 
create a sql.
Please see 1.jpg.


> Shortcut key description is error at Kylin-Web
> --
>
> Key: KYLIN-2870
> URL: https://issues.apache.org/jira/browse/KYLIN-2870
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v2.1.0
>Reporter: peng.jianhua
>Assignee: peng.jianhua
>Priority: Minor
>  Labels: patch
> Attachments: 
> 0001-KYLIN-2870-Shortcut-key-description-is-error-at-Kyli.patch, 1.jpg
>
>
> Shortcut key description is error at Kylin-Web when I click Ctrl+Shift+Space 
> to create a sql.
> The current tips is as following:
> Tips: Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to 
> list table/columns in query box.
> In fact, The shortcut will be list when we press Alt+Space in windows. Please 
> refer to 1.jpg.
> So the right tips is as following:
> Ctrl+Shift+Space or Alt+Space(Windows), Command+Option+Space(Mac) to list 
> keykwords list in query box.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)