If that is the query you want to use, why build cubes at all?
On Wed, Apr 15, 2015 at 3:19 PM, Xiaoyu Wang (JIRA) <[email protected]> wrote: > > [ > https://issues.apache.org/jira/browse/KYLIN-689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14496155#comment-14496155 > ] > > Xiaoyu Wang commented on KYLIN-689: > ----------------------------------- > > My sql just like this: select column_a,column_b,column_c from test_table > where column_a=xx; > Does kylin not support like this? > > > Too many digits for NumberDictionary > > ------------------------------------ > > > > Key: KYLIN-689 > > URL: https://issues.apache.org/jira/browse/KYLIN-689 > > Project: Kylin > > Issue Type: Bug > > Components: Metadata > > Affects Versions: v0.6.5, v0.7.1 > > Reporter: Xiaoyu Wang > > Assignee: Shaofeng SHI > > > > The double field value is 35.800000000000004 > > Build cube got error: > > java.lang.IllegalArgumentException: Too many digits for > NumberDictionary: 35.800000000000004. Expect 16 digits before decimal point > at max. > > at > com.kylinolap.dict.NumberDictionary$NumberBytesCodec.encodeNumber(NumberDictionary.java:76) > > at > com.kylinolap.dict.NumberDictionaryBuilder.addValue(NumberDictionaryBuilder.java:35) > > at > com.kylinolap.dict.TrieDictionaryBuilder.addValue(TrieDictionaryBuilder.java:83) > > at > com.kylinolap.dict.DictionaryGenerator.buildNumberDict(DictionaryGenerator.java:164) > > at > com.kylinolap.dict.DictionaryGenerator.buildDictionaryFromValueList(DictionaryGenerator.java:63) > > at > com.kylinolap.dict.DictionaryGenerator.buildDictionary(DictionaryGenerator.java:114) > > at > com.kylinolap.dict.DictionaryManager.buildDictionary(DictionaryManager.java:166) > > at > com.kylinolap.cube.CubeManager.buildDictionary(CubeManager.java:171) > > at > com.kylinolap.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:50) > > at > com.kylinolap.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:39) > at > com.kylinolap.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:39) > > at > com.kylinolap.job.hadoop.dict.CreateDictionaryJob.run(CreateDictionaryJob.java:51) > > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84) > > at > com.kylinolap.job.cmd.JavaHadoopCmd.execute(JavaHadoopCmd.java:54) > > at > com.kylinolap.job.flow.JobFlowNode.execute(JobFlowNode.java:77) > > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > > at > org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) > > [QuartzScheduler_Worker-19]:[2015-04-15 > 10:29:39,381][ERROR][com.kylinolap.job.hadoop.dict.CreateDictionaryJob.run(CreateDictionaryJob.java:55)] > - Too many digits for NumberDictionary: 35.800000000000004. Expect 16 > digits before decimal point at max. > > java.lang.IllegalArgumentException: Too many digits for > NumberDictionary: 35.800000000000004. Expect 16 digits before decimal point > at max. > > at > com.kylinolap.dict.NumberDictionary$NumberBytesCodec.encodeNumber(NumberDictionary.java:76) > > at > com.kylinolap.dict.NumberDictionaryBuilder.addValue(NumberDictionaryBuilder.java:35) > > at > com.kylinolap.dict.TrieDictionaryBuilder.addValue(TrieDictionaryBuilder.java:83) > > at > com.kylinolap.dict.DictionaryGenerator.buildNumberDict(DictionaryGenerator.java:164) > > at > com.kylinolap.dict.DictionaryGenerator.buildDictionaryFromValueList(DictionaryGenerator.java:63) > > at > com.kylinolap.dict.DictionaryGenerator.buildDictionary(DictionaryGenerator.java:114) > > at > com.kylinolap.dict.DictionaryManager.buildDictionary(DictionaryManager.java:166) > > at > com.kylinolap.cube.CubeManager.buildDictionary(CubeManager.java:171) > > at > com.kylinolap.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:50) > > at > com.kylinolap.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:39) > > at > com.kylinolap.job.hadoop.dict.CreateDictionaryJob.run(CreateDictionaryJob.java:51) > > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84) > > at > com.kylinolap.job.cmd.JavaHadoopCmd.execute(JavaHadoopCmd.java:54) > > at > com.kylinolap.job.flow.JobFlowNode.execute(JobFlowNode.java:77) > > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > > at > org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) > > > > -- > This message was sent by Atlassian JIRA > (v6.3.4#6332) >
