Re: Parsing ALTER TABLE Statements

2022-01-08 Thread Stamatis Zampetakis
: Stamatis Zampetakis > Sent: Friday, January 7, 2022 3:12 AM > To: dev@calcite.apache.org > Subject: Re: Parsing ALTER TABLE Statements > > Hi Yogendra, > > ALTER TABLE is not part of the standard and differs from one system to the > other so it's difficult to come up w

Re: Parsing ALTER TABLE Statements

2022-01-06 Thread Yogendra Sharma
@calcite.apache.org Subject: Re: Parsing ALTER TABLE Statements Hi Yogendra, ALTER TABLE is not part of the standard and differs from one system to the other so it's difficult to come up with something that covers every use-case. Most often users choose to add the ALTER TABLE via the FreeMarker tem

Re: Parsing ALTER TABLE Statements

2022-01-06 Thread Stamatis Zampetakis
SqlParser parser = SqlParser.create("alter table tab1 drop column col1", > config); > SqlNode node = parser.parse(); > > > > From: Jacques Nadeau > Sent: Thursday, January 6, 2022 11:19 PM > To: dev@calcite.apache.org > Subject

Re: Parsing ALTER TABLE Statements

2022-01-06 Thread Yogendra Sharma
Sent: Thursday, January 6, 2022 11:19 PM To: dev@calcite.apache.org Subject: Re: Parsing ALTER TABLE Statements I believe this is a feature that is off by default. Try creating your parser with an alternative parser factory. I think it is something like this: SqlParser.Config.DEFAULT.wi

Re: Parsing ALTER TABLE Statements

2022-01-06 Thread Jacques Nadeau
I believe this is a feature that is off by default. Try creating your parser with an alternative parser factory. I think it is something like this: SqlParser.Config.DEFAULT.withParserFactory(SqlDdlParserImpl.FACTORY) On Thu, Jan 6, 2022 at 6:10 AM Yogendra Sharma wrote: > Wondering why does cal

Parsing ALTER TABLE Statements

2022-01-06 Thread Yogendra Sharma
Wondering why does calcite DDL parser fail to parse ALTER TABLE stayements? In the code I see that we support ALTER SESSION and ALTER SYSTEM but not ALTER Table. -Yogi Get Outlook for Android