Robert Hou created DRILL-5136:
---------------------------------

             Summary: Some SQL statements fail when using Simba ODBC driver 1.3
                 Key: DRILL-5136
                 URL: https://issues.apache.org/jira/browse/DRILL-5136
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - ODBC
    Affects Versions: 1.9.0
            Reporter: Robert Hou


"show schemas" does not work with Simba ODBC driver 

SQL>show schemas
1: SQLPrepare = [MapR][Drill] (1040) Drill failed to execute the query: show 
schemas
[30029]Query execution error. Details:[
PARSE ERROR: Encountered "( show" at line 1, column 15.
Was expecting one of:
    <IDENTIFIER> ...
    <QUOTED_IDENTIFIER> ...
    <BACK_QUOTED_IDENTIFIER> ...
    <BRACKET_QUOTED_IDENTIFIER> ...
    <UNICODE_QUOTED_IDENTIFIER> ...
    "LATERAL" ...
    "(" "WITH" ...
    "(" "+" ...
    "(" "-" ...
    "(" <UNSIGNED_INTEGER_LITERAL> ...
    "(" <DECIMAL_NUMERIC_LITERAL> ...
    "(" <APPROX_NUMERIC (1040) SQLSTATE=HY000

The query profile shows this SQL statement is being executed:

   SELECT * FROM (show schemas) LIMIT 0
 
The yellow highlighted syntax has been added when displaying schemas

"use schema" also does not work.



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

Reply via email to