Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 9C3BC200B79 for ; Wed, 24 Aug 2016 03:24:51 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 9AAE4160ABF; Wed, 24 Aug 2016 01:24:51 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id B8B6E160AAD for ; Wed, 24 Aug 2016 03:24:50 +0200 (CEST) Received: (qmail 87297 invoked by uid 500); 24 Aug 2016 01:24:49 -0000 Mailing-List: contact user-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@kylin.apache.org Delivered-To: mailing list user@kylin.apache.org Received: (qmail 87287 invoked by uid 99); 24 Aug 2016 01:24:49 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2016 01:24:49 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 7047F1A61FE for ; Wed, 24 Aug 2016 01:24:49 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id ftnwh4DzeE3P for ; Wed, 24 Aug 2016 01:24:46 +0000 (UTC) Received: from mail-qk0-f170.google.com (mail-qk0-f170.google.com [209.85.220.170]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 913275F39B for ; Wed, 24 Aug 2016 01:24:45 +0000 (UTC) Received: by mail-qk0-f170.google.com with SMTP id t7so2016401qkh.1 for ; Tue, 23 Aug 2016 18:24:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=TWQ32botgVSjyzkLCnQlCREA8eQoheuRSFUkBcCq8X8=; b=dodnjmZOaQ8GCb2x4f4xKJbb9Wp622eoZOhtBb+BUaayejAbm1wyw7YurPSyFnHIfo rOXX4xNjbnaElxfJpnuGl0kyDwyb6WnIhPoK8gd7TMTpGRxTDPv5i3Caw+JUJjLvtZA/ L3jmpE/FDBCKHEJ6xBV+m+YTQ2VuwJFMfi4/RpUB9BvT4Zmo99BRPzE9ZpoyHBUwiGTf xoRBFzTyxmfzDOWBx1KRiLXU//8JwwDVwhkyrRRbcnH2DD26QpBEcwq9BfuK3+j3FpJF X8T/2CDD0X0b7kFlIPHFvJApISiixSL8/vFaUWe9DKnM3hH55uctZiqtZKf/XYhO2cWs JeKg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=TWQ32botgVSjyzkLCnQlCREA8eQoheuRSFUkBcCq8X8=; b=hULzhrmfdVbjKmX9uOUjjhc5mJIv2gifRdiV24Zyai/16G2xIAZn4rQ81oTeimanhI z38mlpnGcP6+PLOiRbC6ZHdYmNqxtyjH5Mtey/6ZR+FD/4+JFa0UIkf2LSt3qfWa6BBb te63xappMTebkeEEwh7CICn/ZNHTgWF/KyebJm/3QMZo+zC/zda3J00cPLwPg9ai0r3S /0MDC6WApU8LiVurpZxiaoqyZc3dWbEsWpAupTzzkdHUIAhJ/Dzqugan7IFQG1+gAcHZ sC/3KW6UQLr8/DXRgLPB5SDqzXd1ekNCLi02j+G/E5sVOYf6av45/d5ps2oTopcfoSeD cIMg== X-Gm-Message-State: AE9vXwNgosevApALnDK0UwKpYWYAulYmClZlzckwDohnrYXOKxJSF9Ylp6lOGZ8zaosyf8xcFrL5Qa2wLqWgAg== X-Received: by 10.55.116.1 with SMTP id p1mr396295qkc.197.1472001879453; Tue, 23 Aug 2016 18:24:39 -0700 (PDT) MIME-Version: 1.0 Received: by 10.140.18.195 with HTTP; Tue, 23 Aug 2016 18:24:19 -0700 (PDT) In-Reply-To: References: From: Yiming Liu Date: Wed, 24 Aug 2016 09:24:19 +0800 Message-ID: Subject: Re: fail Build Dimension Dictionary To: user@kylin.apache.org Cc: =?UTF-8?Q?Roberto_Tard=C3=ADo_Olmos?= Content-Type: multipart/alternative; boundary=001a11487996223de7053ac7254d archived-at: Wed, 24 Aug 2016 01:24:51 -0000 --001a11487996223de7053ac7254d Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable The exception means the cube has defined one column with type: date/time/datetime/timestamp, but the value of that column is NULL. 2016-08-23 18:06 GMT+08:00 Jose Raul Perez Rodriguez < joseraul.work@gmail.com>: > Hi, > > When I build cubes with *derived columns* always get the same error at > "Build Dimension Dictionary" step. > > kylin version: 1.5.3 > > error: > > java.lang.NullPointerException > at org.apache.kylin.common.util.DateFormat.isAllDigits( > DateFormat.java:121) > at org.apache.kylin.common.util.DateFormat.stringToMillis( > DateFormat.java:104) > at org.apache.kylin.common.util.DateFormat.stringToMillis( > DateFormat.java:91) > at org.apache.kylin.dict.lookup.LookupStringTable.convertRow( > LookupStringTable.java:86) > at org.apache.kylin.dict.lookup.LookupStringTable.convertRow( > LookupStringTable.java:34) > at org.apache.kylin.dict.lookup.LookupTable.initRow( > LookupTable.java:76) > at org.apache.kylin.dict.lookup.LookupTable.init(LookupTable.java:67) > at org.apache.kylin.dict.lookup.LookupStringTable.init( > LookupStringTable.java:79) > at org.apache.kylin.dict.lookup.LookupTable.( > LookupTable.java:55) > at org.apache.kylin.dict.lookup.LookupStringTable.( > LookupStringTable.java:65) > at org.apache.kylin.cube.CubeManager.getLookupTable( > CubeManager.java:619) > at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment( > DictionaryGeneratorCLI.java:61) > at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment( > DictionaryGeneratorCLI.java:42) > at org.apache.kylin.engine.mr.steps.CreateDictionaryJob.run( > CreateDictionaryJob.java:56) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90) > at org.apache.kylin.engine.mr.common.HadoopShellExecutable. > doWork(HadoopShellExecutable.java:63) > at org.apache.kylin.job.execution.AbstractExecutable. > execute(AbstractExecutable.java:112) > at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork( > DefaultChainedExecutable.java:57) > at org.apache.kylin.job.execution.AbstractExecutable. > execute(AbstractExecutable.java:112) > at org.apache.kylin.job.impl.threadpool.DefaultScheduler$ > JobRunner.run(DefaultScheduler.java:127) > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > > result code:2 > > > The curious thing is that I don't use any Date column, so it is pretty > baffling. And only happens with cubes using derived columns. > > > Any idea will be helpful, > > > Thanks > > > --=20 With Warm regards Yiming Liu (=E5=88=98=E4=B8=80=E9=B8=A3) --001a11487996223de7053ac7254d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
The exception means the cube has defined one column with t= ype: date/time/datetime/timestamp, but the value of that column is NULL.

2016-08-23 18:= 06 GMT+08:00 Jose Raul Perez Rodriguez <joseraul.work@gmail.com&= gt;:
=20 =20 =20

Hi,

When I build cubes with derived columns always get the same error at "Build Dimension Dictionary" step.

kylin version: 1.5.3

error:

=20

java.lang.NullPointerException
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.common.util.DateFormat.isAllDigits(DateF= ormat.java:121)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.common.util.DateFormat.stringToMillis(DateFormat= .java:104)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.common.util.DateFormat.stringToMillis(DateFormat= .java:91)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.dict.lookup.LookupStringTable.convertRow(LookupS= tringTable.java:86)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.dict.lookup.LookupStringTable.convertRow(LookupS= tringTable.java:34)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.dict.lookup.LookupTable.initRow(LookupTa= ble.java:76)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.dict.lookup.LookupTable.init(LookupTable.java:67)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.dict.lookup.LookupStringTable.init(LookupStringT= able.java:79)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.dict.lookup.LookupTable.<init>(LookupTable= .java:55)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.dict.lookup.LookupStringTable.<init>(Looku= pStringTable.java:65)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.cube.CubeManager.getLookupTable(CubeMana= ger.java:619)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(<= wbr>DictionaryGeneratorCLI.java:61)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(<= wbr>DictionaryGeneratorCLI.java:42)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.engine.mr.steps.CreateDictionaryJob.run(CreateDictionaryJob.java:56)
=C2=A0=C2=A0=C2=A0 at org.apache.hadoop.util.ToolRunner.run(To= olRunner.java:76)
=C2=A0=C2=A0=C2=A0 at org.apache.hadoop.util.ToolRunner.run(To= olRunner.java:90)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.engine.mr.common.HadoopShellExecutable.doWork(HadoopShellExecutable.= java:63)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.job.execution.AbstractExecutable.execute(Abstrac= tExecutable.java:112)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.job.execution.DefaultChainedExecutable.doWo= rk(DefaultChainedExecutable.java:57)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.job.execution.AbstractExecutable.execute(Abstrac= tExecutable.java:112)
=C2=A0=C2=A0=C2=A0 at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.r= un(DefaultScheduler.java:127)
=C2=A0=C2=A0=C2=A0 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecu= tor.java:1142)
=C2=A0=C2=A0=C2=A0 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExec= utor.java:617)
=C2=A0=C2=A0=C2=A0 at java.lang.Thread.run(Thread.java:745)
result code:2


The curious thing is that I don't use any Date column, so it is pretty baffling. And only happens with cubes using derived columns. =20


Any idea will be helpful,


Thanks





--
With Warm regards
Yiming Liu (=E5=88=98=E4=B8=80=E9=B8=A3)
--001a11487996223de7053ac7254d--