kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hubert Stefani <hstef...@novagen.tech>
Subject SQL Error when using DEFAULT schema in query
Date Mon, 27 Nov 2017 12:52:37 GMT
Hi,

  when running query through the Insight tab (or any other mean like ODBC
connector), if the 'DEFAULT' Namespace is mentioned, the query results in
error.


2017-11-27 11:42:53,695 ERROR [Query
872553e9-f450-4fe4-9ab9-8e5130742e96-11999] service.QueryService:421 :
Exception when execute sql
java.sql.SQLException: Error while executing SQL "SELECT
NOVAPAK2.UTILISATEUR, NOVAPAK2.MODEL, NOVAPAK2.DEVICE, NOVAPAK2.GT  FROM
DEFAULT.NOVAPAK2 NOVAPAK2": parse failed: Encountered "FROM DEFAULT" at
line 1, column 76.
Was expecting one of:
    <EOF>
    "ORDER" ...
    "LIMIT" ...

If i ever put the table / model  in a different schema it works fine.

Should it be reported as a Calcite issue more than a kylin specific one ?

Hubert

Mime
View raw message