Hi, I have tried "ALTER TABLE PUBLIC.person DROP COLUMN (age)" query as well. I am getting the same error message.
Regards, Shravya Nethula, BigData Developer, [cid:6edeb691-d625-4f59-861d-33767b51c98d] Hyderabad. ________________________________ From: Denis Mekhanikov <[email protected]> Sent: Thursday, September 3, 2020 2:17 PM To: user <[email protected]> Subject: Re: Issue in Alter Table - Drop Column functionality I mean, DROP COLUMN, not DROP TABLE. Denis чт, 3 сент. 2020 г. в 11:46, Denis Mekhanikov <[email protected]<mailto:[email protected]>>: Does the DROP TABLE statement work if you specify the schema name explicitly? For example, if the table is in the PUBLIC schema, try running the following query: ALTER TABLE PUBLIC.person DROP COLUMN (age) Denis ср, 2 сент. 2020 г. в 20:27, Shravya Nethula <[email protected]<mailto:[email protected]>>: Hi, When I am trying the following query from GridGain, it works as expected. ALTER TABLE person DROP COLUMN (age) But when I try to execute the same query as a thick client with following Java code, its throwing IgniteSQLException. Java Code: String sql = "ALTER TABLE person DROP COLUMN (age)"; FieldsQueryCursor cursor = cache.query(new SqlFieldsQuery(sql)); Output: javax.cache.CacheException at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:817) at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:750) at org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:424) at net.aline.cloudedh.base.database.IgniteTable._alterTable(IgniteTable.java:138) at net.aline.cloudedh.base.database.BigTable.alter(BigTable.java:697) at net.aline.cloudedh.base.framework.DACEngine.alterTable(DACEngine.java:1015) at net.aline.cloudedh.base.framework.DACOperationsTest.main(DACOperationsTest.java:89) Caused by: class org.apache.ignite.internal.processors.query.IgniteSQLException: null at org.apache.ignite.internal.processors.query.h2.CommandProcessor.runCommandH2(CommandProcessor.java:888) at org.apache.ignite.internal.processors.query.h2.CommandProcessor.runCommand(CommandProcessor.java:418) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeCommand(IgniteH2Indexing.java:1048) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1130) at org.apache.ignite.internal.processors.query.GridQueryProcessor$3.applyx(GridQueryProcessor.java:2406) at org.apache.ignite.internal.processors.query.GridQueryProcessor$3.applyx(GridQueryProcessor.java:2402) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2919) at org.apache.ignite.internal.processors.query.GridQueryProcessor.lambda$querySqlFields$1(GridQueryProcessor.java:2422) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuerySafe(GridQueryProcessor.java:2460) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2396) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2323) at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:802) ... 6 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.query.h2.CommandProcessor.runCommandH2(CommandProcessor.java:834) ... 18 more On the other hand, ALTER TABLE ADD COLUMN functionality is working in both GridGain and also through thick client Java code. Why is it so? Is there any parameter or configurations that are missing? Please kindly let me know if you need any more details regarding the failure scenario. Regards, Shravya Nethula, BigData Developer, [cid:17453219a79676f7b2e1] Hyderabad.
