Return-Path: <user-return-1089-archive-asf-public=cust-asf.ponee.io@kylin.apache.org>
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 2671A200B3E
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Wed,  7 Sep 2016 17:12:12 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 24E83160AC1; Wed,  7 Sep 2016 15:12:12 +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 6C302160ABF
	for <archive-asf-public@cust-asf.ponee.io>; Wed,  7 Sep 2016 17:12:11 +0200 (CEST)
Received: (qmail 22648 invoked by uid 500); 7 Sep 2016 15:12:10 -0000
Mailing-List: contact user-help@kylin.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@kylin.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@kylin.apache.org>
List-Post: <mailto:user@kylin.apache.org>
List-Id: <user.kylin.apache.org>
Reply-To: user@kylin.apache.org
Delivered-To: mailing list user@kylin.apache.org
Received: (qmail 22639 invoked by uid 99); 7 Sep 2016 15:12:10 -0000
Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Sep 2016 15:12:10 +0000
Received: from mail-yb0-f173.google.com (mail-yb0-f173.google.com [209.85.213.173])
	by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 3B6C71A0055
	for <user@kylin.apache.org>; Wed,  7 Sep 2016 15:12:10 +0000 (UTC)
Received: by mail-yb0-f173.google.com with SMTP id x93so6960123ybh.1
        for <user@kylin.apache.org>; Wed, 07 Sep 2016 08:12:10 -0700 (PDT)
X-Gm-Message-State: AE9vXwMDRYm2WR9SosZuAKklBKZV6TushO3G+2dTl49wksrtmLJxhYOYxy8AvJuASL/ffxaAnXo+oNb9i/07Jw==
X-Received: by 10.37.2.22 with SMTP id 22mr13758585ybc.153.1473261129532; Wed,
 07 Sep 2016 08:12:09 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.13.219.145 with HTTP; Wed, 7 Sep 2016 08:11:29 -0700 (PDT)
In-Reply-To: <CAHXz3_Er-OnepD_3wRr4HKenY0RaBXtcrjeja4EqygOziQp-Sw@mail.gmail.com>
References: <CAHXz3_Er-OnepD_3wRr4HKenY0RaBXtcrjeja4EqygOziQp-Sw@mail.gmail.com>
From: ShaoFeng Shi <shaofengshi@apache.org>
Date: Wed, 7 Sep 2016 23:11:29 +0800
X-Gmail-Original-Message-ID: <CANfpUcsYQC1XYXoswJUzW2zdDPxZAJFBWSjHWcNs_EuhsohRDw@mail.gmail.com>
Message-ID: <CANfpUcsYQC1XYXoswJUzW2zdDPxZAJFBWSjHWcNs_EuhsohRDw@mail.gmail.com>
Subject: Re: Syntax error in Kylin - even though query works in Hive
To: user <user@kylin.apache.org>
Content-Type: multipart/alternative; boundary=001a113d421c4991c5053bec5686
archived-at: Wed, 07 Sep 2016 15:12:12 -0000

--001a113d421c4991c5053bec5686
Content-Type: text/plain; charset=UTF-8

DEFAULT is a reserved keyword in Apache Calcite (which acts as Kylin's SQL
parser) ; when use it in SQL, please add double quote ("DEFAULT") to
escape;

2016-09-07 13:17 GMT+08:00 Something Something <mailinglists19@gmail.com>:

> Here's a query that works in Hive, but gives a syntax error in Kylin. Any
> idea why?
>
> select part_dt, kylin_sales.LEAF_CATEG_ID, LSTG_FORMAT_NAME, LSTG_SITE_ID,
> META_CATEG_NAME, sum(price), max(price), min(price) from kylin_sales INNER
> JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS ON
> KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND
> KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID group by
> part_dt, kylin_sales.LEAF_CATEG_ID, LSTG_FORMAT_NAME, LSTG_SITE_ID,
> META_CATEG_NAME order by part_dt, kylin_sales.LEAF_CATEG_ID,
> LSTG_FORMAT_NAME, LSTG_SITE_ID, META_CATEG_NAME;
>
>
> Error message:
>
> Encountered "DEFAULT" at line 1, column 156. Was expecting one of:
> <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ...
> <BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "LATERAL"
> ... "(" ... "UNNEST" ... "TABLE" ...
>



-- 
Best regards,

Shaofeng Shi

--001a113d421c4991c5053bec5686
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">DEFAULT is a reserved keyword in Apache Calcite (which act=
s as Kylin&#39;s SQL parser) ; when use it in SQL, please add double quote =
(&quot;DEFAULT&quot;) to escape;=C2=A0</div><div class=3D"gmail_extra"><br>=
<div class=3D"gmail_quote">2016-09-07 13:17 GMT+08:00 Something Something <=
span dir=3D"ltr">&lt;<a href=3D"mailto:mailinglists19@gmail.com" target=3D"=
_blank">mailinglists19@gmail.com</a>&gt;</span>:<br><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex"><div dir=3D"ltr">Here&#39;s a query that works in Hive, but gives a=
 syntax error in Kylin. Any idea why?<div><br></div><div>select part_dt, ky=
lin_sales.LEAF_CATEG_ID, LSTG_FORMAT_NAME, LSTG_SITE_ID, META_CATEG_NAME, s=
um(price), max(price), min(price) from kylin_sales INNER JOIN DEFAULT.KYLIN=
_CATEGORY_<wbr>GROUPINGS as KYLIN_CATEGORY_GROUPINGS ON KYLIN_SALES.LEAF_CA=
TEG_ID =3D KYLIN_CATEGORY_GROUPINGS.LEAF_<wbr>CATEG_ID AND KYLIN_SALES.LSTG=
_SITE_ID =3D KYLIN_CATEGORY_GROUPINGS.SITE_<wbr>ID group by part_dt, kylin_=
sales.LEAF_CATEG_ID, LSTG_FORMAT_NAME, LSTG_SITE_ID, META_CATEG_NAME order =
by part_dt, kylin_sales.LEAF_CATEG_ID, LSTG_FORMAT_NAME, LSTG_SITE_ID, META=
_CATEG_NAME;<br></div><div><br></div><div><br></div><div>Error message:</di=
v><div><br></div><div>Encountered &quot;DEFAULT&quot; at line 1, column 156=
. Was expecting one of:    =20
&lt;IDENTIFIER&gt; ...     &lt;QUOTED_IDENTIFIER&gt; ...    =20
&lt;BACK_QUOTED_IDENTIFIER&gt; ...     &lt;BRACKET_QUOTED_IDENTIFIER&gt;
 ...     &lt;UNICODE_QUOTED_IDENTIFIER&gt; ...     &quot;LATERAL&quot; ... =
    &quot;(&quot;
 ...     &quot;UNNEST&quot; ...     &quot;TABLE&quot; ... =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<br></div></div>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr">Be=
st regards,<div><br></div><div>Shaofeng Shi</div><div><br></div></div></div=
>
</div>

--001a113d421c4991c5053bec5686--