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 get "instance of Ignite"? -> * [image: image.png] On Wed, Apr 26, 2023 at 2:40 PM Ilya Shishkov <shishkovi...@gmail.com> wrote: > 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 query. > > > It looks like all cluster nodes have failed or restarted. > > > I am getting a *null instance of ignite.* I assume that I am unable to >> connect to the live instance running on that node. > > > How do you get "instance of Ignite"? > > Have you deployed the nodes as described in these instructions [1-3]? > > > 1. > > https://ignite.apache.org/docs/latest/installation/kubernetes/amazon-eks-deployment.html > 2. > > https://ignite.apache.org/docs/latest/installation/kubernetes/azure-deployment.html > 3. > > https://ignite.apache.org/docs/latest/installation/kubernetes/gke-deployment.html > > > > ср, 26 апр. 2023 г. в 09:42, Abhishek Ubhe <abhishekubhe0...@gmail.com>: > >> 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 *using -java commands. >> - In that routine after node started, I created the above CacheTable >> on the node and loaded data from hbase into the cache.table. >> - *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. >> - Now I am getting a *table not found exception* from API request for >> fetching using ignite sql query. >> - And also I tried to recreate the same cache using a regular java >> API script and run on that K8s pod where ignite is running >> - I am getting a *null instance of ignite.* I assume that I am unable >> to connect to the live instance running on that node. >> >> Please help me with this issue and suggest any things I need to do and >> test out. >> >> On Thu, Apr 20, 2023 at 1:52 PM Stephen Darlington < >> stephen.darling...@gridgain.com> wrote: >> >>> 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 <abhishekubhe0...@gmail.com> >>> wrote: >>> >>> Hello, >>> >>> I am facing the issue as below : >>> >>> 1. I have created an ignite cache SQL table through java API. >>> 2. Data loaded from HBase in the table after creating it.(loading >>> means just fetched and inserted in ignite). >>> 3. Now when I was trying to fetch data from the sql table I created >>> I am getting Failed to parse query and table not found exception. >>> 4. For more confirmation I connected to the ignite shell and checked >>> the list of tables. I get the above created table in the list. I can see >>> it >>> exactly created there by the same name. >>> 5. But when I fire my query on the table I get Error of failing to >>> parse the query and Table not found. >>> >>> I did not understand the above scenario. Please help me with this issue. >>> Please check out the attached screenshot for reference. >>> >>> >>> -- >>> *Regards,* >>> *Abhishek Ubhe* >>> >>> <Screenshot from 2023-04-19 18-50-23.png> >>> >>> >>> >> >> -- >> *Regards,* >> *Abhishek Ubhe* >> >> -- *Regards,* *Abhishek Ubhe*
