Re: NPE exception in KMeansTrainer

2018-08-20 Thread zaleslaw
Thank you, I think I've found this bug (or related to this) here https://issues.apache.org/jira/browse/IGNITE-9239 It will be delivered in 2.7 (Currently it's in master branch). To be sure 100% that the bug is closed, could @DocDVZ provide an approach of cache populating? I mean this cache

Fwd: NPE exception in KMeansTrainer

2018-08-20 Thread Denis Magda
Hey, ML experts, Here is an ML issue reported. Please have a look. -- Denis -- Forwarded message - From: DocDVZ Date: Mon, Aug 20, 2018 at 10:53 AM Subject: NPE exception in KMeansTrainer To: Hello, Since I'm new to data science, I'm not really sure if it's a bug or wrong

Failed to map keys for cache (all partition nodes left the grid)

2018-08-20 Thread scottmf
Hi, I'm seeing the errors below in my ignite cluster. This occurs consistently in my env when I apply a "rolling upgrade" where I take down one node at a time by updating them with a new jar file then start it up. Once the node is up I then apply this to the next node and so on. Notes: The

Re: How to detect sql schema changes and make update

2018-08-20 Thread Dmitry Lazurkin
I found solution. Query "select column_name, data_type from information_schema.columns where table_schema = ? and table_name = ?" in local mode. On 08/16/2018 06:28 PM, Dmitry Lazurkin wrote: > Hello. > > I have cache with query entity. Now I want to add new field to query > entity of existing

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread Ilya Kasnacheev
Hello! I have filed an issue against JIRA: https://issues.apache.org/jira/browse/IGNITE-9334 Regards, -- Ilya Kasnacheev 2018-08-20 18:39 GMT+03:00 wt : > i was literally about to respond with the same findings . tested it and it > works although i should point out that it is not in an

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread wt
i was literally about to respond with the same findings . tested it and it works although i should point out that it is not in an obvious place. It is not in the schema section but in the cache section under Store. Thanks for your help on this. -- Sent from:

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread Ilya Kasnacheev
Hello! So I have found this 'sqlEscapeAll' flag that you can try and set, with hopes that your problem will go away: I have attached config file with this property already set, can you replace your own with this one, try again? Regards, -- Ilya Kasnacheev 2018-08-20 15:41 GMT+03:00 wt : >

Ignite RPM Installation As Service ignitevisorcmd usage

2018-08-20 Thread ApacheUser
Hi Ignite Team, I have Installed Ignite as Service using RPM, its running fine but how can I use ignitevisorcmd.sh to check the topology etc.? Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

NPE exception in KMeansTrainer

2018-08-20 Thread DocDVZ
Hello, Since I'm new to data science, I'm not really sure if it's a bug or wrong incoming data, so I decided to ask here for advice before submitting a ticket. I tried to apply Kmeans algorithm on my bag-of-words data with ~8k features. So I copy-pasted some lines from example:

Ignite and Persistent Collections

2018-08-20 Thread steve.hostettler
Hello, I would like to know what is the position of the committers towards Persistent Collections (https://pcollections.org/)? Apparently it could massively reduce the marshalling/unmarshalling time. Best Regards -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread wt
That column with the : is also an issue but in SQL server you can either quote columns in quotes or square braces. I would have expected Ignite to generate code with quoted columns because even a simple space in the name is a problem in the current statement regardless of the column with : in it.

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread Ilya Kasnacheev
Hello! It's strange, but my expectation here is that "Exchange:Ticker" is not a proper name for a column. Is it? I expect it to be [Exchange:Ticker] if it's real. SQLServerDialect should be able to quote column names so I'm having trouble understanding what happens here. Can anybody with SQL

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread wt
here is the exact query intercepted declare @p1 int set @p1=NULL exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 nvarchar(4000)',N'SELECT CompanyId,CompanyName,Country,Region,Peer Group,Company Type,ExtractionDate,Exchange:Ticker,Exchange,Ticker,Legal Entity Identifier,Bloomberg

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread Ilya Kasnacheev
Hello! Is it possible to intercept the problematic query as sent to SQL server, paste it into e-mail? Regards, -- Ilya Kasnacheev 2018-08-20 14:42 GMT+03:00 wt : > i think i found the issue it is related to the select not quoting columns. > I > ran a trace against the database and executed

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread wt
i think i found the issue it is related to the select not quoting columns. I ran a trace against the database and executed each query generated separately. Is this a driver issue or an ignite issue? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread wt
When i load the cache for an integrated rmdbs with a table that doesn't have values with special characters then the table loads fine. If i try the same with a table that has values with special characters i get the following error: >>> Loading caches... >>> Loading cache: CompanyCache

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread ilya.kasnacheev
Hello! Unfortunately I still do not understand what kind of problem you are having. Can you please make screenshot where the problem is apparent? Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread wt
POC-project.zip cols.png sqljdbc42.jar here is the project. The

Re: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread Ilya Kasnacheev
Hello! We would need examples of auto-generated code or a screenshot at least. Regards, -- Ilya Kasnacheev 2018-08-20 13:25 GMT+03:00 wt : > i am having trouble with the auto generated code from the web console. > There > are tables with columns that contain values with special characters

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','

2018-08-20 Thread wt
i am having trouble with the auto generated code from the web console. There are tables with columns that contain values with special characters like ",". If i load a table that i know doesn't have special characters it works. Does anyone know where in the load code i need to look and what sort of

Re: The Apache Ignite Book

2018-08-20 Thread srecon
Hi Luqman, Nice work. I will add this info to the book. Best regards Shamim -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: The Apache Ignite Book

2018-08-20 Thread srecon
Hi Ivan, thanks for pointing me out. I have fixed the issue. Best regards Shamim -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Possible issue with Web Console

2018-08-20 Thread vbm
Hi, I can do the cherry-pick. Is this issue fixed in 2.7 ? I checked the ticket https://issues.apache.org/jira/browse/IGNITE-9262 but was not able to find any commit id in it. Regards, Vishwas -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/