[jira] [Commented] (KYLIN-3285) "Value NNN not exists" error run executing query

[ZHAOXIXIN (JIRA)]

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

ZHAOXIXIN commented on KYLIN-3285:
--

the problem maybe from the "shard by" setting, after I set the day_time "shard 
by” to true,the issue comes when I query.
If set all "shard by" to false, query can be done successfully.

>  "Value NNN not exists" error run executing query
> -
>
> Key: KYLIN-3285
> URL: https://issues.apache.org/jira/browse/KYLIN-3285
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: v2.3.0
>Reporter: Shaofeng SHI
>Priority: Major
> Attachments: cube (1).json, kylin.log
>
>
> Reported by community user zxxb...@163.com:
>  
> {color:#b94a48}Kylin version update from 2.2.0 to 2.3.0; cube was build 
> before update, and query without error.{color}
> {color:#b94a48}After updatge to version 2.3.0 and query {color}"select 
> count(userid) num,day_time from record_ap group by day_time LIMIT 
> 1000{color:#b94a48}”{color}
> {color:#b94a48}show errors below:{color}
> Column 0 value '2018-03-06' met dictionary error: Value '2018-03-06' 
> (2018-03-06) not exists! while executing SQL: "select count(userid) 
> num,day_time from record_ap group by day_time LIMIT 1000”
>  
> {color:#b94a48}Where {color}{color:#b94a48}'2018-03-06’ come from? I was 
> fully confused.{color}
> {color:#b94a48}Cube have several segments:{color}
> {color:#b94a48}Starttime-endtime{color}
> {color:#b94a48}20180101-20180225{color}
> 20180225-20180304
>  
> Attached the log and cube JSON.



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

[jira] [Created] (KYLIN-3276) query with dynamic parameter get the same query result

[ZHAOXIXIN (JIRA)]

ZHAOXIXIN created KYLIN-3276:


 Summary: query with dynamic parameter get the same query result
 Key: KYLIN-3276
 URL: https://issues.apache.org/jira/browse/KYLIN-3276
 Project: Kylin
  Issue Type: Bug
  Components: Driver - JDBC, Query Engine
Affects Versions: v2.2.0
 Environment: Kylin 2.2.0, JDK 1.8
Reporter: ZHAOXIXIN


sql:"select distinct uid from table where daytime=? limit 70" 
ps.setString(1,"2018-01-03") 
store the result to ArrayList, and print the size of ArrayList. 
when I set the daytime to different dates, the same result I got. 

I changed the sql, just change limit value for example 
sql:"select distinct uid from table where daytime=? limit 60" 
then I got the right value the same like query from GUI:count (distinct uid) 




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