Could not create a table

Dremio University
1

hi guys i am a new to Dremio I am trying to create a table but not able to create it can any one could guide me

CREATE TABLE [Dremio].[Dremio Fundamentals].[demo](
name varchar(130),
desc varchar(200),
grade int;

PARSE ERROR: Failure parsing the query.

SQL Query CREATE TABLE [Dremio].[Dremio Fundamentals].demo, desc varchar(200), grade int; startLine 2 startColumn 14 endLine 2 endColumn 14 SQL Query CREATE TABLE [Dremio].[Dremio Fundamentals].demo, desc varchar(200), grade int;

[Error Id: 438cee9b-0507-4149-b386-5c97eea99750 on ed55d2f31e74:31010]

(org.apache.calcite.sql.parser.SqlParseException) Encountered “[” at line 2, column 14. Was expecting one of: … <QUOTED_IDENTIFIER> … <BACK_QUOTED_IDENTIFIER> … <BRACKET_QUOTED_IDENTIFIER> … <UNICODE_QUOTED_IDENTIFIER> …

com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():349
com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():135
org.apache.calcite.sql.parser.SqlParser.handleException():130
org.apache.calcite.sql.parser.SqlParser.parseStmtList():185
com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172
com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187
com.dremio.exec.planner.sql.SqlConverter.parse():203
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():285
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():236
com.dremio.exec.work.foreman.AttemptManager.plan():450
com.dremio.exec.work.foreman.AttemptManager.lambda$run$1():362
com.dremio.service.commandpool.CommandWrapper.run():62
com.dremio.context.RequestContext.run():95
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():180
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered “[” at line 2, column 14. Was expecting one of: … <QUOTED_IDENTIFIER> … <BACK_QUOTED_IDENTIFIER> … <BRACKET_QUOTED_IDENTIFIER> … <UNICODE_QUOTED_IDENTIFIER> …

com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():29174
com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():28982
com.dremio.exec.planner.sql.parser.impl.ParserImpl.Identifier():6215
com.dremio.exec.planner.sql.parser.impl.ParserImpl.CompoundIdentifier():6278
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlCreateTable():1260
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():883
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():841
com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():186
com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73
org.apache.calcite.sql.parser.SqlParser.parseStmtList():183
com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172
com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187
com.dremio.exec.planner.sql.SqlConverter.parse():203
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():285
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():236
com.dremio.exec.work.foreman.AttemptManager.plan():450
com.dremio.exec.work.foreman.AttemptManager.lambda$run$1():362
com.dremio.service.commandpool.CommandWrapper.run():62
com.dremio.context.RequestContext.run():95
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():180
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748

2

Hi @vigneshpathapati ,
could you please try this instead ?

CREATE TABLE Dremio."Dremio Fundamentals".demo(
name varchar(130),
"desc" varchar(200),
grade int
);

Simply double quotes identifiers named as reserved words or containing special characters.
It seems to me the final ‘)’ is missing.

Depending on the dremio version you are using,
you may have to enable iceberg table support in order to CREATE TABLE.

CREATE TABLE AS is allowed on all table types.

Best,

3

thank you so much it is working and i need to enable iceberg table support.