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 <manoj.h.ku...@jpmorgan.com>: > 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.common.CubeStatsReader. > getCuboidSizeMapFromRowCount(CubeStatsReader.java:183) > > at 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.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 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 史少锋