I mean, DROP COLUMN, not DROP TABLE. Denis
чт, 3 сент. 2020 г. в 11:46, Denis Mekhanikov <dmekhani...@gmail.com>: > 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 < > shravya.neth...@aline-consulting.com>: > >> 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, >> >> >> Hyderabad. >> >>
