Thanks for your inputs.. it has resolved the issue.. Appreciate your help.
Regards, Manoj From: ShaoFeng Shi [mailto:[email protected]] Sent: Friday, November 17, 2017 9:34 AM To: user Subject: Re: Cube Error - Kyin 2.1 version Hi Manoj, From the message, you have a dimension which select to use "integer" encoding; but in the source table, it has invalid value like 'undefined', causing the encoding error. 2017-11-16 19:57 GMT+08:00 Kumar, Manoj H <[email protected]<mailto:[email protected]>>: While Cube building It has got error out – Step #6 – Create HT table.. Can someone Advise on this? What kind of data type Error is this? java.lang.NumberFormatException: For input string: "undefined" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:492) at java.lang.Integer.parseInt(Integer.java:527) at org.apache.kylin.dimension.IntegerDimEnc$Factory.createDimensionEncoding(IntegerDimEnc.java:65) at org.apache.kylin.dimension.DimensionEncodingFactory.create(DimensionEncodingFactory.java:65) at org.apache.kylin.cube.kv.CubeDimEncMap.get(CubeDimEncMap.java:74) at org.apache.kylin.engine.mr<http://org.apache.kylin.engine.mr>.common.CubeStatsReader.getCuboidSizeMapFromRowCount(CubeStatsReader.java:183) at org.apache.kylin.engine.mr<http://org.apache.kylin.engine.mr>.common.CubeStatsReader.getCuboidSizeMap(CubeStatsReader.java:149) at org.apache.kylin.storage.hbase.steps.CreateHTableJob.run(CreateHTableJob.java:97) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84) at org.apache.kylin.engine.mr<http://org.apache.kylin.engine.mr>.common.HadoopShellExecutable.doWork(HadoopShellExecutable.java:62) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125) at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:65) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125) at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:141) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Regards, Manoj This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer<http://www.jpmorgan.com/emaildisclaimer> including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited. -- Best regards, Shaofeng Shi 史少锋 This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.
