Issue in Alter Table - Drop Column functionality

rameter 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:09c0df72-eaf4-487f-b018-60299eb21fc3] Hyderabad.

Re: Issue in Alter Table - Drop Column functionality

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 Sent

Re: Issue in Alter Table - Drop Column functionality

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:d1e7061d-22a5-4a9b-a80b-53eeae872f21] Hyderabad. From: Denis Mekhanikov Sent

Re: Issue in Alter Table - Drop Column functionality

ode: String sql = "ALTER TABLE person DROP COLUMN (age)"; FieldsQueryCursor cursor = cache.query(new SqlFieldsQuery(sql)); Regards, Shravya Nethula, BigData Developer, [cid:b616dee9-4b10-4059-a473-8cc8c4fc7342] Hyderabad. From: Ilya Kasnacheev

Re: Issue in Alter Table - Drop Column functionality

ocessor.java:2323) at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:802) ... 3 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.query.h2.CommandProcessor.runCommandH2(CommandProcesso

Re: Issue in Alter Table - Drop Column functionality

Hi Ilya, Thank you for the confirmation and the workaround is working as expected. Much appreciated. Is there any rough release date or release version for this issue? Regards, Shravya Nethula, BigData Developer, [cid:357d40f2-e612-4cef-b899-fb17a36896bb] Hyderabad

Re: Issue in Alter Table - Drop Column functionality

Thank you for the information Ilya. Regards, Shravya Nethula, BigData Developer, [cid:9d5782fd-7700-4644-9354-38435191aa05] Hyderabad. From: Ilya Kasnacheev Sent: Thursday, September 24, 2020 5:01 PM To: user@ignite.apache.org Subject: Re: Issue in Alter

How to get column names for a query in Ignite thin client mode

ode? And also is there anyway in which we can identify the datatype of columns given in the query! We are looking for the datatype of the columns in the query but not the datatype of columns in the table! Any help here will be much appreciated! Thanks in advance! Regards, Shravya Nethula, BigData Developer, [cid:066886cc-0cdf-4e72-b66b-181ae1642679] Hyderabad.

How to get data for subqueries with aggregate functions in Ignite Thick client mode

ged to get the data properly even in Thick client mode? Any help is much appreciated! Thanks in advance! Regards, Shravya Nethula, BigData Developer, [cid:ac89baff-8f32-4873-b999-0e829eb26203] Hyderabad.

Re: How to get column names for a query in Ignite thin client mode

Ilya and Alex, Thank you for information. Can you please also suggest how to get the datatypes of those columns obtained from the query? Regards, Shravya Nethula, BigData Developer, [cid:134aaaea-babf-48d0-9084-0e30ff58e8b5] Hyderabad. From: Alex Plehanov

Re: How to get column names for a query in Ignite thin client mode

Hi Alex, Thank you for the information. Is there a possibility of getting the datatypes in thick client mode? Regards, Shravya Nethula, BigData Developer, [cid:0d6f1002-8e08-4cec-a2dd-85d2391ee2f7] Hyderabad. From: Alex Plehanov Sent: Thursday, November 5

Performance of indexing on varchar columns without specific length

the above scenario, can we create index on last_name column? And while creating index on those columns, will there be any performance difference on these columns? Regards, Shravya Nethula, BigData Developer, [cid:5ffa4fac-72f1-4b29-a0f6-4750deb51d8f] Hyderabad.

Re: How to get column names for a query in Ignite thin client mode

Hi, Any update on this? Any help is much apppreciated! Regards, Shravya Nethula, BigData Developer, [cid:7572d2f4-9800-4bf2-9ca4-85f6f18e44c6] Hyderabad. From: Shravya Nethula Sent: Thursday, November 5, 2020 4:54 PM To: user@ignite.apache.org Cc: Bhargav

Re: How to get column names for a query in Ignite thin client mode

Thank you Ilya Regards, Shravya Nethula, BigData Developer, [cid:2d89cf9f-aa3f-4a88-aea2-70b3dfe9cb3e] Hyderabad. From: Ilya Kasnacheev Sent: Wednesday, November 11, 2020 7:46 PM To: user@ignite.apache.org Cc: Bhargav Kunamneni Subject: Re: How to get

How to insert date values in yyyy format in Ignite table?

alues in this format? Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

IgniteCache.destroy() taking long time

cache information among the nodes whenever a cache is deleted? Is there any way in which, the execution time can be optimized? Regards, Shravya Nethula. Regards, Shravya Nethula, BigData Developer, [cid:08a38b0c-9ee5-4e1b-94ae-7f42ee561277] Hyderabad.

Re: IgniteCache.destroy() taking long time

ur. More details here: https://apacheignite.readme.io/docs/cache-modes Do you have a reproducer project? Thanks, Alex On Wed, Aug 14, 2019 at 1:22 AM Shravya Nethula mailto:shravya.neth...@aline-consulting.com>> wrote: Hi, I have created a cache using the following API: Ignite

Re: IgniteCache.destroy() taking long time

ded? What is the importance of Partition exchange? Regards, Shravya Nethula. ____ From: Shravya Nethula Sent: Monday, August 19, 2019 6:06:36 PM To: user@ignite.apache.org Subject: Re: IgniteCache.destroy() taking long time The following is the cache conf

Re: Altered sql table (adding new columns) does not reflect in Spark shell

Thank you Andrei. Regards, Shravya Nethula, BigData Developer, [cid:ca42104d-9443-490c-87d3-af6f7d4f5077] Hyderabad. From: Andrei Aleksandrov Sent: Tuesday, September 10, 2019 8:22 PM To: user@ignite.apache.org Subject: Re: Altered sql table (adding new

Support for Unique columns in Ignite

this functionality? Regards, Shravya Nethula, BigData Developer, [cid:e19953a7-275a-42e4-a694-dfb4eda34dbb] Hyderabad.

Re: Support for Unique columns in Ignite

Hi Anton, Thank you for the information. Regards, Shravya Nethula, BigData Developer, [cid:6447e351-fbb4-44f3-94f2-94b638753545] Hyderabad. From: akurbanov Sent: Thursday, November 21, 2019 5:23 PM To: user@ignite.apache.org Subject: Re: Support for

Select query not working as expected

-f678-4814-91e7-7b32c510a607] Is the select query wrong? Is there any syntax error? Or is there any other way in which I can achieve this? Regards, Shravya Nethula, BigData Developer, [cid:58267690-e75f-4ea8-b011-dcc384a7f010] Hyderabad.

Alter table issue

to be addressed in the next releases. I saw that there is a limitation in Alter Table. So in which release can this support be provided? What is the tentative date? Regards, Shravya Nethula, BigData Developer, [cid:18fe433f-515a-4b53-bd76-358144bbf8a5] Hyderabad.

Re: Alter table issue

Hi Ivan, Thank you for the confirmation. In the link, I can see that the issue will be resolved in Ignite 3.0 version. When will Ignite 3.0 be released? Is there any tentative date? Regards, Shravya Nethula, BigData Developer, [cid:2a5e6893-c131-4622-bebf-2deef20e1f50] Hyderabad

Ignite Select Query Performance

test case. Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

LIKE operator issue in Ignite Database

e? Is there any equivalent for LIKE operator in Ignite? Please go through the enclosed attachments for more details. Regards, Shravya Nethula. LIKE_with_(%059).jpeg <http://apache-ignite-users.70518.x6.nabble.com/file/t1559/LIKE_with_%28%25059%29.jpeg> LIKE_with_(%9).jpeg <http://apach

Failing to create index on Ignite table column

rg.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2707) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2144) at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(

Re: Failing to create index on Ignite table column

on 1 or 2 columns. But for rest of the columns creation of index fails. There were no exceptions during creation of table. Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Failing to create index on Ignite table column

Hi, Is there any way to check the list of column names on which index has been created for a particular table? Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Failing to create index on Ignite table column

ception. Now I have explicitly given the index name and executed the following query: CREATE INDEX User_age_asc_IDX ON User (age asc) And it worked successfully. Now I am able to create multiple indexes on columns one after the other successfully (which wasn't the case previously). Rega

RE: Failing to create index on Ignite table column

Hi Stan, Thank you! This information is helpful. Do you know any Ignite API through which I can get the indexes of a particular table? Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Purpose of cache in cache.query(Create Table ...) statement

What is the main purpose of "cache"? I kindly request you guys to throw some light on this topic. Any related information is appreciable. Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Purpose of cache in cache.query(Create Table ...) statement

, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Purpose of cache in cache.query(Create Table ...) statement

Hi Andrey, This information will definitely be useful. Thank you. Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Purpose of cache in cache.query(Create Table ...) statement

Hi Denis, Thank you for the information. Regards, Shravya. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

setNodeFilter throwing a CacheException

al.getOrCreateCache(IgniteKernal.java:2906) at net.aline.cloudedh.inmemorydb.ignite.IgniteTable.(IgniteTable.java:50) Can anyone please tell if we are missing any other configuration setting? Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: setNodeFilter throwing a CacheException

org.apache.ignite.spi.discovery.tcp.messages.TcpDiscoveryCustomEventMessage.message(TcpDiscoveryCustomEventMessage.java:81) Please let us know if we are missing any configurations! Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

How to execute an sql on a specific remote server?

ecific remote node? Can anyone please post some suggestions in this regard? Regards, Shravya Nethula. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/