[ 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: {color:blue} SELECT * FROM {color} (show schemas) {color:blue} LIMIT 0 {color} The blue text has been added when displaying schemas "use schema" also does not work. was: "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. > Some SQL statements fail due to PreparedStatement > ------------------------------------------------- > > 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: > {color:blue} SELECT * FROM {color} (show schemas) {color:blue} LIMIT 0 > {color} > > The blue text has been added when displaying schemas > "use schema" also does not work. -- This message was sent by Atlassian JIRA (v6.3.4#6332)