I have looked at the docs and it is not clear to me how to set-up a queryable table that can be loaded with a datastreamer. If I want to use the datastreamer and still have it queryable from a third party tool like Tableau what would I need to set-up. I tried one thing and it showed up in the DBeaver but under a schema of Test, that was my cache name, but I cannot query it as it says invalid schema. Is there some config when the cache is created that needs to be set so that it also generates TABLES that are queryable. Sorry for all the questions as I am trying to do a quick proof of concept for our users and need to load 10 million initially into a cache and have it queryable from SQL interfaces.
On Wed, Feb 27, 2019 at 8:14 AM Ilya Kasnacheev <[email protected]> wrote: > Hello! > > Please refer to this page: https://apacheignite.readme.io/docs/indexes > > In short, you can use CREATE TABLE or GetOrCreateCache > indexedTypes+annotations or QueryEntities. All of those are compatible with > DataStreamer as long as type name and field/column names match. > > By default caches do not have corresponding tables. > > Regards, > -- > Ilya Kasnacheev > > > вт, 26 февр. 2019 г. в 21:35, Mike Needham <[email protected]>: > >> Hi All, >> >> I have a cache that I have loaded using the DataStreamer and can confirm >> there is a cache created by using the ignitevisor utility with the cache >> command. I cannot query it from any JDBC tools and am not sure why. Do I >> need to use a CREATE TABLE syntax in order for this to work instead of the >> GetOrCreateCache<>(CacheName). Or is there someother thing on the config >> side that I am missiung >> >> Any help appreciated as I am just starting to evaluate this for a project. >> >> >> -- >> *Some days it just not worth chewing through the restraints* >> > -- *Some days it just not worth chewing through the restraints*
