Re: Failed to parse query SQL table not found issue

2023-04-26 Thread Stephen Darlington
You need to find out what the problem is before anyone can make a recommendation. Why are your nodes restarting? > On 26 Apr 2023, at 12:34, Abhishek Ubhe wrote: > > Ok, > I will remove the backup configuration setting of cache. But about you said, > > In the case of in-memory cluster, simulta

Re: Failed to parse query SQL table not found issue

2023-04-26 Thread Abhishek Ubhe
Ok, I will remove the backup configuration setting of cache. But about you said, *In the case of in-memory cluster, simultaneous restart of all nodescould be a reason. Also, you could look for the log messages aboutchanging of cluster topology and errors.* For the above case, what do you sugges

Re: Failed to parse query SQL table not found issue

2023-04-26 Thread Ilya Shishkov
> Is this maybe the case? This policy of K8s cause the loss of cache sql tables? In the case of in-memory cluster, simultaneous restart of all nodes could be a reason. Also, you could look for the log messages about changing of cluster topology and errors. As I see from the attached picture, you

Re: Failed to parse query SQL table not found issue

2023-04-26 Thread Abhishek Ubhe
Hello, *What is Ignite shell? Sqlline? - > *Yes sqlline. *It looks like all cluster nodes have failed or restarted. - >* May be because K8s pods are getting restarted as per container restart policy. *Is this maybe the case? This policy of K8s cause the loss of cache sql tables?* *How do you

Re: Failed to parse query SQL table not found issue

2023-04-26 Thread Ilya Shishkov
Hi, *After some days, I was unable to see the created cache on the Ignite > shell *which I have created and was able to see at first when node > started properly. What is Ignite shell? Sqlline? Now I am getting a *table not found exception* from API request for > fetching using ignite sql que

Re: Failed to parse query SQL table not found issue

2023-04-25 Thread Abhishek Ubhe
Hello Stephen, I did try changes you suggested above and I did get output. Thanks for that. But I am facing a different issue in meantime on my microservice which have following setup : - I have set up a kubernetes pod cluster where I have started *3 ignite nodes and deployed k8s pods *usi

Re: Failed to parse query SQL table not found issue

2023-04-20 Thread Stephen Darlington
In sqlline, you can type “!tables” (no quotes) to list all the tables. In general, the schema is the cache name and the table is the value type name, so you would need to write "select * from CACHE_NAME.HbaseTableType". > On 20 Apr 2023, at 06:38, Abhishek Ubhe wrote: > > Hello, > > I am faci