Is that the most efficient way to load millions of rows from a database table into a cache? I guess I am not seeing how this would work for millions of rows in the source database. That also appears to be a JAVA only solution and it would be preferable to have it be usable for .NET as well as java and hopefully python.
On Thu, Mar 7, 2019 at 6:55 AM Ilya Kasnacheev <ilya.kasnach...@gmail.com> wrote: > Hello! > > What prevents you from reading rows from DB and feeding them to JDBC > prepared statement? > > Regards, > -- > Ilya Kasnacheev > > > чт, 7 мар. 2019 г. в 15:51, Mike Needham <needb...@gmail.com>: > >> And what if the data is already in a database table? I do not want to >> read from the table to write to a file to load a cache. >> >> On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev <ilya.kasnach...@gmail.com> >> wrote: >> >>> Hello! >>> >>> The preferred approach is to use Thin JDBC client: >>> https://apacheignite-sql.readme.io/docs/jdbc-driver >>> >>> Regards, >>> -- >>> Ilya Kasnacheev >>> >>> >>> пн, 4 мар. 2019 г. в 19:39, Mike Needham <needb...@gmail.com>: >>> >>>> Thanks for the links, If SET STREAMING ON is the preferred method, how >>>> would you do this in code rather than from a file with all the insert >>>> statements. >>>> >>>> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev < >>>> ilya.kasnach...@gmail.com> wrote: >>>> >>>>> Hello! >>>>> >>>>> You can see at this page: >>>>> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage >>>>> >>>>> And then substitite cache.put() with addData() and cache name will be >>>>> SQL_PUBLIC_{table name in caps} >>>>> >>>>> There are not many examples since this is being discouraged in favor >>>>> of SET STREAMING ON, actually: >>>>> https://apacheignite-sql.readme.io/docs/set >>>>> >>>>> Regards, >>>>> -- >>>>> Ilya Kasnacheev >>>>> >>>>> >>>>> пт, 1 мар. 2019 г. в 22:48, Mike Needham <needb...@gmail.com>: >>>>> >>>>>> I have looked at the documentation and the code samples and nothing >>>>>> is doing what I am trying to do. I want to be able to use the >>>>>> datastreamer >>>>>> to load 3 or 4 TABLES in a cache for an application that we use. If I >>>>>> create the tables using a create table syntax how do attach a >>>>>> datastreamer >>>>>> to the different caches if the cache name is PUBLIC for all of them? >>>>>> >>>>>> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev < >>>>>> ilya.kasnach...@gmail.com> wrote: >>>>>> >>>>>>> Hello! >>>>>>> >>>>>>> I have linked the documentation page, there are also some code >>>>>>> examples in distribution. >>>>>>> >>>>>>> Regards, >>>>>>> -- >>>>>>> Ilya Kasnacheev >>>>>>> >>>>>>> >>>>>>> чт, 28 февр. 2019 г. в 17:10, Mike Needham <needb...@gmail.com>: >>>>>>> >>>>>>>> Is there any examples that show the steps to do this correctly? I >>>>>>>> stumbled upon this but have no idea if it is the best way to do this >>>>>>>> >>>>>>>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev < >>>>>>>> ilya.kasnach...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hello! >>>>>>>>> >>>>>>>>> There's no restriction on cache name but setting it up for the >>>>>>>>> first time may be tricky indeed. >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> -- >>>>>>>>> Ilya Kasnacheev >>>>>>>>> >>>>>>>>> >>>>>>>>> ср, 27 февр. 2019 г. в 19:48, needbrew99 <needb...@gmail.com>: >>>>>>>>> >>>>>>>>>> OK, was able to get it working. Apparently the cache name has to >>>>>>>>>> be PUBLIC >>>>>>>>>> and it will create a table based on the object definition that I >>>>>>>>>> have. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> *Some days it just not worth chewing through the restraints* >>>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> *Some days it just not worth chewing through the restraints* >>>>>> >>>>> >>>> >>>> -- >>>> *Some days it just not worth chewing through the restraints* >>>> >>> >> >> -- >> *Some days it just not worth chewing through the restraints* >> > -- *Some days it just not worth chewing through the restraints*