Hello,
I’m running DREMIO EE 22.2.3.
Just copying sample code :
CREATE TABLE $scratch.fruits (name, color)
AS VALUES (‘strawberry’, ‘red’), (‘banana’, ‘yellow’), (‘raspberry’, ‘red’);
CREATE FUNCTION red_fruits()
RETURNS TABLE (name VARCHAR, color VARCHAR)
RETURN SELECT * FROM $scratch.fruits WHERE color = ‘red’;
SELECT name FROM TABLE (red_fruits())
copied from Dremio’s page
Tabular User-Defined Functions Unveiled | Dremio
I get an error - is it my release 22.2.3 the source for this error ??
Thanks
PARSE ERROR: Failure parsing the query.
SQL Query CREATE FUNCTION red_fruits()
RETURNS TABLE (name VARCHAR, color VARCHAR)
RETURN SELECT * FROM $scratch.fruits WHERE color = ‘red’
startLine 2
startColumn 13
endLine 2
endColumn 17
SQL Query CREATE FUNCTION red_fruits()
RETURNS TABLE (name VARCHAR, color VARCHAR)
RETURN SELECT * FROM $scratch.fruits WHERE color = ‘red’
(org.apache.calcite.sql.parser.SqlParseException) Encountered “TABLE” at line 2, column 13.
Was expecting one of:
“CHARACTER” …
“CHAR” …
“VARCHAR” …
“DATE” …
“TIME” …
“TIMESTAMP” …
“DECIMAL” …
“DEC” …
“NUMERIC” …
“BOOLEAN” …
“INTEGER” …
“INT” …
“BINARY” …
“VARBINARY” …
“TINYINT” …
“SMALLINT” …
“BIGINT” …
“REAL” …
“DOUBLE” …
“FLOAT” …
“ANY” …
“ROW” …
“ARRAY” …
“MULTISET” …
…
<QUOTED_IDENTIFIER> …
<BACK_QUOTED_IDENTIFIER> …
<BRACKET_QUOTED_IDENTIFIER> …
<UNICODE_QUOTED_IDENTIFIER> …