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 < [email protected]> 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 <[email protected]> > 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*
