You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Robert Hou (JIRA)" <ji...@apache.org> on 2016/12/19 23:09:58 UTC
[jira] [Updated] (DRILL-5136) Some SQL statements fail due to
Prepared Statement API
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Robert Hou updated DRILL-5136:
------------------------------
Description:
"show schemas" does not work.
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.
was:
"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.
> Some SQL statements fail due to Prepared Statement API
> ------------------------------------------------------
>
> 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
> Assignee: Laurent Goujon
>
> "show schemas" does not work.
> 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)