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 : 
> I have created an ignite cache SQL table through java API.
> Data loaded from HBase in the table after creating it.(loading means just 
> fetched and inserted in ignite).
> 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.
> 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.
> 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>

Reply via email to