[jira] [Comment Edited] (KYLIN-1076) Cannot use DEFAULT as identifier of database in SQL

["Dong Li (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14958311#comment-14958311 ] 

Dong Li edited comment on KYLIN-1076 at 10/15/15 4:51 AM:
----------------------------------------------------------

Thanks Julian and Shaofeng. In fact, this issue is met in Excel while loading data thru ODBC driver. The SQL generated by Excel won't enclose identifier in quotes, then the query will fail. 
I'll look for other solutions for this scenario.


was (Author: lidong_sjtu):
Thanks Julien and Shaofeng. In fact, this issue is met in Excel while loading data thru ODBC driver. The SQL generated by Excel won't enclose identifier in quotes, then the query will fail. 
I'll look for other solutions for this scenario.

> Cannot use DEFAULT as identifier of database in SQL
> ---------------------------------------------------
>
>                 Key: KYLIN-1076
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1076
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Dong Li
>            Assignee: liyang
>            Priority: Minor
>
> input: 
> select count(item_count) from default.test_kylin_fact
> output:
> Encountered "default" at line 1, column 31. Was expecting one of: <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ... <BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "LATERAL" ... "(" ... "UNNEST" ... "TABLE" ...



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)