Re: rest api rmdbs integration

2018-07-29 Thread wt
How do I set the classpath in an intelij ignite project generated by the Web console? Happy to send the project through however it is using rmdbs integration with an sql server dB so won't work without the dB on your side. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

rest api rmdbs integration

2018-07-27 Thread wt
i have integrated a database with ignite and the generated project created classes for the tables. If i try run Sql scan query execute over the cache like this example http://host:port/ignite?cmd=qryscanexe=10=Person=org.apache.ignite.schema.Person here is my query string

Re: rest api rmdbs integration

2018-07-30 Thread wt
that's done and working and how i start the server and load cache in intellij. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

client security (rest, .net\java clients, jdbc)

2018-08-14 Thread wt
we will be using a combination of .net and java client apps as well as jdbc and rest. I know we need to implement our own security plugin but how can this be applied to each access type (.net\java clients, rest,jdbc). would i need to create different security plugins for each and if so are they

Re: ignite.net spring config ( jdbc classpath)

2018-08-16 Thread wt
Brilliant thanks that did the trick. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

ignite.net spring config ( jdbc classpath)

2018-08-16 Thread wt
i am playing with getting ignite working on .net and it works nicely with standard configs. If i try copy a config that has rmdbs integration it doesn't know where to find the jbdc jar file and classpath. Does anyone have any information on how this can be done ? Caused by: class

Re: ignite.net spring config ( jdbc classpath)

2018-08-16 Thread wt
hi Ilya thanks for the quick response. I am running this from code using a visual studio project so there isn't an ignite home but if i create one and update the env variable to use either a windows format for the path or a /folder format i get the following error

security question - custom plugin

2018-08-13 Thread wt
I am looking at the http://smartkey.co.uk/development/securing-an-apache-ignite-cluster/ example but it doesn't dive into details and when trying to build one myself i am unsure of the following 1) what imports are needed for the annotations is it org.jetbrains.annotations? 2) i have the

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: ignite.net config (applying spring and .net config)

2018-08-21 Thread wt
Brilliant thanks a million Ilya. pts working with the plugin -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

has the following been resolved since 2.3? (jdbc thin client security)

2018-08-22 Thread wt
https://issues.apache.org/jira/browse/IGNITE-6856 https://issues.apache.org/jira/browse/IGNITE-6941 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

custom plugin question - jdbc client

2018-08-28 Thread wt
i have finally managed to get a plugin working for a white list on ignite 2.6. I am now going to start working on an authorization for users connecting to the cluster. How can i get clients pass through a kerberos ticket to the cluster? I think i need to override the authorization context class

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: 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 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 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
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 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

ignite.net config (applying spring and .net config)

2018-08-21 Thread wt
Hi I am trying to work out if i can start ignite using the spring config but then register a custom .net plugin through .net but i can't find any documentation on how this can be done apart from this section from the following documentation (see in bold for the specific reference to this)

Re: custom plugin question - jdbc client

2018-08-29 Thread wt
Hi Taras I am slightly confused. You are mentioning sslcontext and looking at those related classes it doesn't appear to offer authentication and authorization. Here is where i currently am with this project. I have a white list plugin that i will apply to server nodes when they join. I have

Task not serializable: java.io.NotSerializableException: org.apache.ignite.configuration.IgniteConfiguration

2018-07-18 Thread wt
I can connect to ignite rmdbs table from spark but can't query it. ignite server running in intellij - rmdbs integration (1 table) and cache loaded in spark i have the following code: import org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi import

what version of spark is supported by ignite 2.5

2018-07-18 Thread wt
I can't get it to work with spark 2.2 with context error that i asked about last week with no answers. Documentation is lacking here it only described the features and not the version compatability -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

ignite odbc - Cannot open include file: 'openssl/ssl.h': No such file or directory

2018-07-23 Thread wt
i have downloaded and trying to build the odbc project but it is referencing the following files that are not in the visual studio project ssl_bindings.h and ssl_gateway.cpp #include #include #include error is Error C1083 Cannot open include file: 'openssl/ssl.h': No such file or

spark - Failed to process custom exchange task

2018-07-19 Thread wt
*Everything was working fine this morning then i had to reboot to install an update on other software. Starting it all up again the ignite server starts, cache is loaded and can be queried from DBBeaver. When i access from spark however it all falls apart. * *import

Re: Task not serializable: java.io.NotSerializableException: org.apache.ignite.configuration.IgniteConfiguration

2018-07-19 Thread wt
brilliant thanks it is working here is the code for anyone else that will find this useful. val igniteContext = new IgniteContext(sc, () =>{ val tcpDiscoverySpi: TcpDiscoverySpi = new TcpDiscoverySpi val ipFinder: TcpDiscoveryVmIpFinder = new

Re: spark - Failed to process custom exchange task

2018-07-19 Thread wt
is this bug still active (generated from web console) https://issues.apache.org/jira/browse/IGNITE-4829 Spring context is not injected into POJO store when JDBC driver is utilized -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

***UNCHECKED*** RE: odbc - conversion failed because data value overflowed

2018-07-25 Thread wt
thank i have that working. I am trying to be able to integrate sql server with ignite for ETL purposes. We are looking to build an EDW with ignite so would like to have it accessible by the underlying databases as a source of truth. Looking at .Net CLR integration now as a workaround. I think with

RE: odbc - conversion failed because data value overflowed

2018-07-24 Thread wt
yes but i would have thought the ODBC driver would be compatible through odbc interface standards. It would be nice to be able to add a linked server in MSSQL and query ignite. I might have to fudge it and create a .net CLR -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

odbc - conversion failed because data value overflowed

2018-07-24 Thread wt
I have a SQL server instance and configured odbc driver and a linked server. I noticed the linked server doesn't show any columns and in fact can't retrieve a list of columns. Secondly, if i query the data source i get a data overflow error. any idea 1.png

Re: what version of spark is supported by ignite 2.5

2018-07-18 Thread wt
could it be that spark is not compatible with ignite rmdbs integration? If i run an example without that it works (writing to and reading from caches and tables) -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: what version of spark is supported by ignite 2.5

2018-07-18 Thread wt
If i run the same code on spark 2.1 i get the following error (same jars in classpath) Welcome to __ / __/__ ___ _/ /__ _\ \/ _ \/ _ `/ __/ '_/ /___/ .__/\_,_/_/ /_/\_\ version 2.1.0 /_/ Using Scala version 2.11.8 (Java HotSpot(TM) 64-Bit Server

Re: what version of spark is supported by ignite 2.5

2018-07-18 Thread wt
thanks but that doesnt work I have the folowing jars in spark classpath for spark 2.2 cache-api-1.0.0.jar spring-expression-4.3.7.RELEASE.jar spring-context-4.3.7.RELEASE.jar spring-core-4.3.7.RELEASE.jar spring-beans-4.3.7.RELEASE.jar ignite-spring-2.5.0.jar ignite-core-2.5.0.jar

Re: what version of spark is supported by ignite 2.5

2018-07-18 Thread wt
here is my rmdbs integration server config http://www.springframework.org/schema/beans; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; xmlns:util="http://www.springframework.org/schema/util; xsi:schemaLocation="http://www.springframework.org/schema/beans

TcpDiscoverySpi.setAuthenticator

2018-08-29 Thread wt
Where does this call for a custom plugin need to be done? i.e TcpDiscoverySpi discoSpi = new TcpDiscoverySpi(); discoSpi.setAuthenticator(new TokenAuthenticator()); igniteConfig.setDiscoverySpi(discoSpi); -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite.net config (applying spring and .net config)

2018-08-30 Thread wt
Super, that looks like the solution. Thank you so much for this. It's been so difficult navigating without complete documentation. Will give it a whirl. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Looking for information on these methods

2018-08-31 Thread wt
okay i have a white list plugin class that is now working - ThankYou Ilya (GridGain) I can now control nodes joining the cluster be it clients or servers. My next task is to manage user requests to specific caches and what they can do on those. I already have the GridSecurityProcessor class as

Re: ignite.net config (applying spring and .net config)

2018-08-31 Thread wt
Its working - Thanks a million Ilya Regards Wayne -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: TcpDiscoverySpi.setAuthenticator

2018-08-30 Thread wt
I am using a config file and not setting config in code. How can i register setDiscoverySpi with my custom class in the config file or can i set it in code and also apply the config file? thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Looking for information on these methods

2018-08-31 Thread wt
okay i have a white list plugin class that is now working - ThankYou Ilya (GridGain) I can now control nodes joining the cluster be it clients or servers. My next task is to manage user requests to specific caches and what they can do on those. I already have the GridSecurityProcessor class

how to convert org.apache.ignite.lang.IgniteBiTuple to IgniteConfiguration

2018-08-30 Thread wt
need to be able to read in the config file and then apply an authenticator to it before starting ignite. I have managed to call IgnitionEx.loadConfigurations("server.xml"); which returns org.apache.ignite.lang.IgniteBiTuple How can i convert this to an IgniteConfiguration object? -- Sent

Re: ignite.net config (applying spring and .net config)

2018-08-30 Thread wt
hi Ilya Is there a way to do this in java? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Spring application context resource is not injected

2018-07-13 Thread wt
this is all i am running val df = spark.read.format(FORMAT_IGNITE).option(OPTION_TABLE,"ComplianceSummaryCache.ComplianceSummary").option(OPTION_CONFIG_FILE,"stoxx-server.xml").load() the intellij project hosting the server was downloaded from the web console. I haven't changed anything there.

Spring application context resource is not injected

2018-07-13 Thread wt
Hi I switched to spark 2.2 and now i am getting a different error: *on the server (intellij running) i have the following output:* [18:50:49]__ [18:50:49] / _/ ___/ |/ / _/_ __/ __/ [18:50:49] _/ // (7 7// / / / / _/ [18:50:49] /___/\___/_/|_/___/

Re: spark ignite - Failed to instantiate Spring XML application context

2018-07-13 Thread wt
thanks a million for that nugget. I tried to find that info and couldn't find it, do you perhaps have a link to a resource i can digest as there seems to be little documentation around the technicals. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

spark ignite - Failed to instantiate Spring XML application context

2018-07-13 Thread wt
i have ignite running out of intellij and all is okay, i can connect to it using dbbeaver and create and query tables. Trying to get spark working with it and all imports are okay however when i try read from ignite i get this error that i am struggling to find any information about on the web.

spark ignite - how to set ignite client jvm memory options?

2018-07-13 Thread wt
the console is warning on heap memory and i want to increase it but doing so in sparks config doesn't have an affect. How can i set it for the client in spark? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Looking for information on these methods

2018-09-12 Thread wt
hows it going with this Luqman I am still exploring an approach to single signon using kerberos without needing config files. I think i have made progress but i need to register a service principal name first. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: client probe cache metadata

2018-10-12 Thread wt
i need to to be able to discover what each cache configuration is. It this system is to have a large number of tables we need a way to identify what the original configuration for the given cache is. All our configs are happening at runtime (no xml file) because we are moving in a direction of

RE: data streamer - failed to update keys (GUID)

2018-10-12 Thread wt
There is an error “Failed to update index, incorrect key class”. Any chance you’ve changed an integer field to a string one, or something like that? using (var ldr = igniteclient.GetDataStreamer(TableName)) = works using (var ldr = igniteclient.GetDataStreamer(TableName)) = fails shown error

Re: client probe cache metadata

2018-10-12 Thread wt
thanks for the help on this Stan -i will look into that method. thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: data streamer - failed to update keys (GUID)

2018-10-12 Thread wt
not sure if it is related but the error isn;t pointing to it being an issue. interop requires uct date and from sql server we are parsing in a datetimeoffset and ignite sees it as an object and not timestamp -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: odbc caches - cannot browse

2018-10-15 Thread wt
here is the log file generated when opening a new odbc connection to ignite in excel. odbc3.log -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

.net Datetime loads without error but table empty

2018-10-15 Thread wt
Running into an issue where i have an underlying sql server with a DateTime field. That is loaded into a class that has DateTime field in .net. I set the class field to its value like this from the data reader value = dataReader.GetDateTime(ordinal); the load code uses GetDataStreamer and

RE: data streamer - failed to update keys (GUID)

2018-10-15 Thread wt
please ignore this thread - i have found the problem and it was some old residual test code that was being called instead. Correcting that has resolved the issue. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: .net Datetime loads without error but table empty

2018-10-15 Thread wt
this is sorted now thanks Stan - >net has several ways to do it and it didn't seem to like the other ways i was trying. simply setting it to datetime.touniversaltime resolved it. I do however think it odd that ignite was not throwing any errors -- Sent from:

Re: odbc caches - cannot browse

2018-10-16 Thread wt
Thank you Igor -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

GetDataStreamer issue - ignite stops writing when underlying db reader closes

2018-10-16 Thread wt
I have the following load code for ignite (.net) 1) setup a data streamer ldr = igniteclient.GetDataStreamer(TableName); 2) open connection to database and read data 3) create class objects and pass to streamer 4) close db connection I am observing the following behaviour the row count for this

Re: Query 3x slower with index

2018-10-12 Thread wt
having worked with databases for 20 years i can see your indexes are not fully scoped. i see this as your issue having SUM(product_views_app) > 2 OR SUM(product_clicks_app) > 1 add those columns to the composite index so that it doesn't need to access the underlying table and can just use the

data streamer - failed to update keys (GUID)

2018-10-12 Thread wt
hi I just wanted to check something. I have a table that has a guid key. When i try insert into this table at the end of the insert when the data reader connection closes i get this error (i have included a select that shows there is just 1 record with that key). Can Ignite handle guid keys?

RE: data streamer - failed to update keys (GUID)

2018-10-12 Thread wt
I get the same error when trying the key as a string. here are some screen shots of the code, error, and table structure table_stucture.png code.png

Re: GetDataStreamer issue - ignite stops writing when underlying db reader closes

2018-10-16 Thread wt
could it have something to do with a Guid being the key? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: GetDataStreamer issue - ignite stops writing when underlying db reader closes

2018-10-16 Thread wt
looks like you are right, there is dirty data in the source. Thanks Ilya for the pointer -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite odbc build error

2018-10-24 Thread wt
maybe you could provide me with the 2.7 ignite.odbc.dll and i can skip the build part in visual studio and run light.exe -ext WixUIExtension ignite-odbc-x86.wixobj -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

ignite odbc build error

2018-10-24 Thread wt
i am trying to build the 2.7 odbc driver and i am getting an error. I am using ubuntu 14 root@ip-10-112-47-3:/ignite2.7/ignite/modules/platforms/cpp# ls aclocal.m4 config.sub cpp.dxg jni missing thin-client autom4te.cache configuredepcomp ltmain.sh

Re: ignite odbc build error

2018-10-24 Thread wt
ok i didnt realise that. Could you please help me understand why i am getting that error when following the exact instructions on https://apacheignite.readme.io/docs/odbc-driver *Building installers on Windows* /Once you have built driver binaries you may want to build installers for easier

Re: where to download 2.7 source

2018-10-24 Thread wt
thanks Igor Unfortunately i have a demo next week and i need the odbc bug that was fixed in 2.7 to be ready for the demo so i have no choice but to try use the current status of 2.7. Thanks for the info -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite odbc build error

2018-10-24 Thread wt
Hi Igor *I tried as a standard user and i get this* ubuntu@ip-10-112-47-3:/ignite2.7/ignite/modules/platforms/cpp$ libtoolize && aclocal && autoheader && automake --add-missing && autoreconf ./configure.ac --enable-odbc --disable-node --disable-core aclocal:configure.ac:32: warning: macro

2.7 (.net) JavaException: class org.apache.ignite.binary.BinaryObjectException: Invalid flag value: 0

2018-10-24 Thread wt
Not sure if there is something missing in the .net ignite side for 2.7 I have built 2.7 on a linux machine, copied it to my windows machine and can launch it from the ignite.bat file no problem. I built the dotnet source as well and referenced those in my current project (a winforms app). When

Re: ignite odbc build error

2018-10-24 Thread wt
i do. this is a major blocker for me for my demo to the COO. All i am looking for is the 32bit odbc msi. is there anywhere i can get it or if you know if i should be using a different version of linux -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: where to download 2.7 source

2018-10-24 Thread wt
I believe i have done this. I have downloaded 2.7 from github. packaged it with maven and then copied the entire dir to my local windows pc. I then updated the IGNITE_HOME variable to point to this new location. I started the server using the bat file (i couldnt start it in a .net proj as it was

Re: where to download 2.7 source

2018-10-24 Thread wt
hi Thank you it is all resolved now using the nightly build including the odbc and i can now see the odbc tables from Excel. fabulous -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: where to download 2.7 source

2018-10-24 Thread wt
Hi Igor Not sure if there is something missing in the .net ignite side for 2.7 I have built 2.7 on a linux machine, copied it to my windows machine and can launch it from the ignite.bat file no problem. I built the dotnet source as well and referenced those in my current project (a winforms

Re: ignite odbc build error

2018-10-24 Thread wt
those errors are gone but it looks like some ubuntu issue is now a problem. Have you seen this before? ubuntu@ip-10-112-47-3:/ignite2.7/ignite/modules/platforms/cpp$ libtoolize && aclocal && autoheader && automake --add-missing && autoreconf ./configure --enable-odbc --disable-node --disable-core

Re: ignite odbc build error

2018-10-24 Thread wt
omg you are a life saver I CAN'T THANK YOU ENOUGH :) -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite odbc build error

2018-10-24 Thread wt
hi Thank you it is all resolved now using the nightly build including the odbc and i can now see the odbc tables from Excel. fabulous -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: where to download 2.7 source

2018-10-24 Thread wt
i am giving the nightly builds a go and will use those in the .net proj reference. Fingers crossed - been struggling on this all day so far and feel very demotivated. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

odbc 2.7 columns issue

2018-10-24 Thread wt
Hi Thank you for fixing the bug where in Excel i was not able to see the tables. I can now however there are no columns visible and it gives an error that the data source did not return any columns. So it is a bit better that we can see the tables but we still cannot browse them and have to run a

Re: 2.7 (.net) JavaException: class org.apache.ignite.binary.BinaryObjectException: Invalid flag value: 0

2018-10-24 Thread wt
hi please ignore the issue has been resolved by getting the latest from the nightly build -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: odbc 2.7 columns issue

2018-10-25 Thread wt
hi here is the odbc log file odbc.log My server configuration http://ignite.apache.org/schema/dotnet/IgniteConfigurationSection;> 127.0.0.1:47500..47509

how to handle dataregion out of memmory gracefully

2018-10-28 Thread wt
in testing i managed to exceed a data regions space and this region is memory only. When this happens an unhandled exception is thrown from the underlying ignite dlls and the process crashes. How can i handle this gracefully without losing the server? -- Sent from:

destroy cache holding residual metadata in memory (2.7)

2018-10-31 Thread wt
i am testing code and part of my tests is adding\removing tables. In one of the tests i add a table then destroy it and add it again but with an additional column. When i try load the table i am getting a data type mismatch and it is referring to the previous version of the table in the work

Re: Unable to load more than 5g data through sqlline

2018-10-31 Thread wt
a better option would be to drop sqlline and write your own client that reads the csv files and loads into the database. This way you can have multiple threads loading multiple files concurrently and each load you setup the parameters for the streamer including batch sizes and flush frequency.

Re: how to handle dataregion out of memmory gracefully

2018-10-31 Thread wt
Thanks for this but what concerns me is if i setup several data regions and one of them happens to be a play area i guess for data scientists and they hit the memory limit of that region then the whole server goes down. in the case for a cluster all the nodes hosting that region will go down. I

Re: What is the username of ignite web console

2018-11-01 Thread wt
click register and enter your details and it will let you in -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Unable to load more than 5g data through sqlline

2018-11-01 Thread wt
a different machine is fine all you need to do is build a client using either java, c++,.net, scala, and probably powershell as well i have something like this in .Net and can parallel load files (one per thread in a pool of 10 threads) using (var ldr =

Re: odbc 2.7 columns issue

2018-10-25 Thread wt
Thanks Igor I didn't think about the underscores in the names. Will try it in the morning. Thanks for the tip, hopefully it will get me over the line for the demo to the COO. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

where to download 2.7 source

2018-10-24 Thread wt
I am doing a demo to our COO next week and part of this demo is excel ignite odbc which in 2.6 doesn't allow tables to be browsed see the following jira https://issues.apache.org/jira/browse/IGNITE-9891 anyway I am struggling to find if there is an available source with the latest builds to

Re: OVER() clause in ignite

2018-10-24 Thread wt
i noticed H2 roadmap for the current version has windowing functions. http://www.h2database.com/html/roadmap.html i guess this will mean ignite will have it available in the near future? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

BUG - .net decimal type creating ignite table produces double

2018-10-04 Thread wt
version 2.6 i have a tool that creates ignite tables and it is passing in a class with the type as decimal but it is coming out as double in when i query the metadata using rest in ignite? The documentation explicitly states c# decimal converts to java.math.bigdecimal which is not a floating

odbc caches - cannot browse

2018-10-05 Thread wt
is there a reason why the odbc driver can't show all the caches and browse their schemas' like regular odbc drivers? this is a regular odbc driver allowing the user to navigate tables. odbc.png -- Sent from:

Re: ignite .net programatically access cluster config (not working)

2018-10-01 Thread wt
thanks ill try the compute tasks route -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Fetch column names in sql query results

2018-10-01 Thread wt
hi I am on 2.6 using the .net api and there are is no metadata object on the result set even though this was said to have been added in 2.1. I could use the rest service but would prefer to use the api. can anyone advise if this is possible with SqlFieldsQuery? -- Sent from:

Re: ignite .net index group definition

2018-10-01 Thread wt
So are you saying that i have to revert to the spring xml to get this done? I am using query entities when trying to do this but the order field doesn't seem to apply in the .net API. foreach (var field in item.Columns) { properties.Add(new Property()

Re: BUG - .net decimal type creating ignite table produces double

2018-10-10 Thread wt
okay i think i need to close this- not sure why but running it on my local machine produces a double but on a server it is coming as a decimal. Must be an issue of some sort with my local pc so i think we can ignore this. thanks though for getting back to me -- Sent from:

Re: odbc caches - cannot browse

2018-10-10 Thread wt
i would love some guidance on this. i have the 2.6 odbc setup and i can query it in excel 2016 but only if i manually type in the query. Excel won't show any of the tables like you would typically expect odbc connection is not configured to use a specific cache and no security is configured

Re: BUG - .net decimal type creating ignite table produces double

2018-10-10 Thread wt
hi i am referring to c# classes that have properties that are decimal types. If i create caches with those classes the data type in ignite is double. Now admittedly i am interrogating schema information using the rest meta but i would have though that the data types returned are not schema bound

2 questions about eviction and transactions

2018-10-11 Thread wt
hi I can't find additional information on evictions and transactions that i need to document. 1) does the eviction policies apply at a node level or cluster level. I understand with replicated it probably is a node level but for a partitioned cache how does it work 2) if i have 4 tables and 1

client probe cache metadata

2018-10-11 Thread wt
Hi The rest service has a meta method that returns fields and index info. I can't see another rest method that would show what a cache config is like (backup, atomic or transactional, if metrics tracking is enabled, and whatever other relevant cache config there might be. Can i get this from the

RE: 2 questions about eviction and transactions

2018-10-11 Thread wt
this is brilliant. thanks for this information. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite.net config (applying spring and .net config)

2018-08-30 Thread wt
I need to use the web console for rmdbs integration so i am using the config file that is generated and the project. What i am busy working on is writing a custom plugin that authenticates users. I need to setDiscoverySpi with the new authenticator but there doesn't seem to be a method in the

  1   2   >