I have the impression that Kylin may return a wrong answer for the raw query(if you do not have raw measure) but not throw an exception.
>From your pic, it seems like a POC, have you ever tried Kylin's tutorial about sample cube ( http://kylin.apache.org/docs/tutorial/kylin_sample.html)? Maybe it's a good beginning. Support DrakosData <supp...@drakosdata.com> 于2018年11月6日周二 下午4:22写道: > This answer is in Kylin Faq: "Why I got an error when running a “select * > “ query?" > > [http://kylin.apache.org/docs/gettingstarted/faq.html ] > > > On 6/11/18 2:30, 1311217...@qq.com wrote: > > my kylin under dev environment happen a null exception when select.develop > tool is ideal,system is windows 7. > > > ------------------------------ > 1311217...@qq.com > > > *From:* dev-help <dev-h...@kylin.apache.org> > *Date:* 2018-11-06 09:15 > *To:* 1311217283 <1311217...@qq.com> > *Subject:* WELCOME to dev@kylin.apache.org > Hi! This is the ezmlm program. I'm managing the > dev@kylin.apache.org mailing list. > > I'm working for my owner, who can be reached > at dev-ow...@kylin.apache.org. > > Acknowledgment: I have added the address > > 1311217...@qq.com > > to the dev mailing list. > > Welcome to dev@kylin.apache.org! > > Please save this message so that you know the address you are > subscribed under, in case you later want to unsubscribe or change your > subscription address. > > > --- Administrative commands for the dev list --- > > I can handle administrative requests automatically. Please > do not send them to the list address! Instead, send > your message to the correct command address: > > To subscribe to the list, send a message to: > <dev-subscr...@kylin.apache.org> <dev-subscr...@kylin.apache.org> > > To remove your address from the list, send a message to: > <dev-unsubscr...@kylin.apache.org> <dev-unsubscr...@kylin.apache.org> > > Send mail to the following for info and FAQ for this list: > <dev-i...@kylin.apache.org> <dev-i...@kylin.apache.org> > <dev-...@kylin.apache.org> <dev-...@kylin.apache.org> > > Similar addresses exist for the digest list: > <dev-digest-subscr...@kylin.apache.org> > <dev-digest-subscr...@kylin.apache.org> > <dev-digest-unsubscr...@kylin.apache.org> > <dev-digest-unsubscr...@kylin.apache.org> > > To get messages 123 through 145 (a maximum of 100 per request), mail: > <dev-get.123_...@kylin.apache.org> <dev-get.123_...@kylin.apache.org> > > To get an index with subject and author for messages 123-456 , mail: > <dev-index.123_...@kylin.apache.org> > <dev-index.123_...@kylin.apache.org> > > They are always returned as sets of 100, max 2000 per request, > so you'll actually get 100-499. > > To receive all messages with the same subject as message 12345, > send a short message to: > <dev-thread.12...@kylin.apache.org> <dev-thread.12...@kylin.apache.org> > > The messages should contain one line or word of text to avoid being > treated as sp@m, but I will ignore their content. > Only the ADDRESS you send to is important. > > You can start a subscription for an alternate address, > for example "john@host.domain" <john@host.domain>, just add a hyphen and > your > address (with '=' instead of '@') after the command word: > <dev-subscribe-john=host.dom...@kylin.apache.org> > <dev-subscribe-john=host.dom...@kylin.apache.org> > > To stop subscription for this address, mail: > <dev-unsubscribe-john=host.dom...@kylin.apache.org> > <dev-unsubscribe-john=host.dom...@kylin.apache.org> > > In both cases, I'll send a confirmation message to that address. When > you receive it, simply reply to it to complete your subscription. > > If despite following these instructions, you do not get the > desired results, please contact my owner at > dev-ow...@kylin.apache.org. Please be patient, my owner is a > lot slower than I am ;-) > > --- Enclosed is a copy of the request I received. > > Return-Path: <1311217...@qq.com> <1311217...@qq.com> > Received: (qmail 68465 invoked by uid 99); 6 Nov 2018 01:15:07 -0000 > Received: from pnap-us-west-generic-nat.apache.org (HELO > spamd4-us-west.apache.org) (209.188.14.142) > by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Nov 2018 01:15:07 > +0000 > Received: from localhost (localhost [127.0.0.1]) > by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) > with ESMTP id 6856EC066E > for > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org> > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org>; > Tue, 6 Nov 2018 01:15:07 +0000 (UTC) > X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org > X-Spam-Flag: NO > X-Spam-Score: 3.315 > X-Spam-Level: *** > X-Spam-Status: No, score=3.315 tagged_above=-999 required=6.31 > tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, > FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, INVALID_MSGID=1.167, > RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, > T_DKIMWL_WL_MED=-0.01, T_MIME_MALF=0.01] autolearn=disabled > Authentication-Results: spamd4-us-west.apache.org (amavisd-new); > dkim=pass (1024-bit key) header.d=qq.com > Received: from mx1-lw-us.apache.org ([10.40.0.8]) > by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port > 10024) > with ESMTP id aevuZEg1re_M > for > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org> > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org> > ; > Tue, 6 Nov 2018 01:15:04 +0000 (UTC) > Received: from smtpproxy19.qq.com (smtpproxy19.qq.com [184.105.206.84]) > by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with > ESMTPS id D43945F20B > for > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org> > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org>; > Tue, 6 Nov 2018 01:15:03 +0000 (UTC) > DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; > t=1541466895; bh=hs/zcDFZ2389Qif7NrJn/ELwlTHVlmIwMESXVtphGRQ=; > h=Date:From:To:Subject:References:Mime-Version:Message-ID:Content-Type; > b=BPYWO8te3+/ImjeVwa83SWpmfDGS67Abgnt3uwyEodEK5Ad4K4prRjKFp8VBpQOMt > csaIW2lj1NkI/RhjAFqdlnnG1jwfImqCvmE6iAEYuKeCTQvZSVb5DQdZcPRrxp4UFw > svxWRFY18FZDi8u2UgP9oosIUMuOI2k2Nq7ji0f4= > X-QQ-mid: esmtp5t1541466894tc96ub4xo > Received: from kindy-PC (unknown [120.234.24.49]) > by esmtp4.qq.com (ESMTP) with SMTP id 0 > for > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org> > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org>; > Tue, 06 Nov 2018 09:14:54 +0800 (CST) > X-QQ-SSF: 00000000000000F0FI601000000000I > X-QQ-FEAT: nSUdqPGu3tv5FnELwyIJDlwd236khPydYN9TOnX4tHyralmm5rf7nZkEjzA8t > whkvIkVtYv8rMhKhGYa/1Qtm+WkN8tsUS+mHAqqLhRvRc8OGxv8ym3n866qeTHL0Wx/nV5h > LwqYHjSdF15c3AuMgnMdjGa+xa1f1CMVmoVNCgwfun3cx0zM/EltkFZIxDbwlbdlO/PG1xT > niWXOYOQGAqifI1uwFeP14QUgm2jcqLlU/Ozp4MJD/cwAEqSVgcvGYwbeA/g3Wh93D/lfsb > /pk8X8wJRyT7miQHWf2biyepZ+bUOvoB6pMOeIU+bktdjbOYpnG0+H4hs= > X-QQ-GoodBg: 0 > Date: Tue, 6 Nov 2018 09:14:51 +0800 > From: "1311217...@qq.com" <1311217...@qq.com> <1311217...@qq.com> > <1311217...@qq.com> > To: dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq.com > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org> > <dev-sc.1541466730.gaeakaiajmjhgfikpion-1311217283=qq....@kylin.apache.org> > Subject: Re: confirm subscribe to dev@kylin.apache.org > References: <1541466730.66890.ez...@kylin.apache.org> > <1541466730.66890.ez...@kylin.apache.org> > X-Priority: 3 > X-GUID: 9B2789BE-3FC4-4999-8FAC-B2A44130F087 > X-Has-Attach: no > X-Mailer: Foxmail 7.2.9.156[cn] > Mime-Version: 1.0 > Message-ID: <201811060914513668...@qq.com> <201811060914513668...@qq.com> > +22E0DE3E19518BA2 > Content-Type: multipart/alternative; > boundary="----=_001_NextPart785820235202_=----" > X-QQ-SENDSIZE: 520 > Feedback-ID: esmtp:qq.com:bgforeign:bgforeign4 > X-QQ-Bgrelay: 1 > > > -- > > ======================== > DRAKOSDATA: Apache Kylin Experts > Kyligence Partner Spain (Madrid) > ======================== > > This message and any attachments are confidential and privileged and intented > for the use of the addressee only. > You are entitled to exercise your rights of access, rectification, > cancellation and opposition by addressing such written application to address > ad...@drakosdata.com > > -- Regards! Aron Tao