You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2019/03/27 03:16:00 UTC
[jira] [Commented] (KYLIN-3420) common sql query fail on kylin web
ui
[ https://issues.apache.org/jira/browse/KYLIN-3420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16802390#comment-16802390 ]
Shaofeng SHI commented on KYLIN-3420:
-------------------------------------
Please note DEFAULT is a keyword in Calcite. Please use double quote to escape:
select .. .from "DEFAULT"."TABLE_NAME"
> common sql query fail on kylin web ui
> -------------------------------------
>
> Key: KYLIN-3420
> URL: https://issues.apache.org/jira/browse/KYLIN-3420
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.3.1
> Environment: debian
> Reporter: ZoneYang
> Priority: Critical
> Labels: bug
> Attachments: Clip(06-19-14-57-34).png, Clip(06-19-14-58-36).png
>
>
> kylin version:2.3.1
> sql:
> SELECT "COUNTRY",
> "LATITUDE",
> "LONGITUDE",
> "NAME"
> FROM DEFAULT.KYLIN_COUNTRY
> LIMIT 10
>
> when i execute this sql, kylin web ui will tell me fail
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)