No relationship between tables X and Y in Catalyst DataStore
As of now, you need to have a relation between two tables you are trying to join in ZCQL and the absence of this has caused you the issue. The condition that has to be used in a join query must be the ROWID of the first table to the foreign key of the second table.
Related Articles
Create the schema for a table in Catalyst DataStore using code
As of now, we do not have the support for creating table via code. The tables can only be created via the Catalyst Console and data for the same can be inserted from the code.
Catalyst Data Store tables are empty in production
We would suggest you to use the Catalyst CLI/Bulk Write API to perform the bulk write operation in your table in the production environment. You can export the same from development and import it into production. Please check this link for more ...
Integrating Catalyst with Zoho Analytics
You can use the Zoho Analytics REST API in the Catalyst Functions in order to push the data from Catalyst Datastore to Analytics to generate reports. We would suggest you to check out this tutorial which will provide you an idea on how things work in ...
Limit of text data type in Catalyst Data Store
The limit of text datatype in the Catalyst Datastore is 10000. If your message contains more than 10000characters, please consider creating a file in the FileStore and upload the content to it.
Multiline text fields in the Catalyst Data Store
You can create your application with multiline text and rich text fields and use the text datatype available in the Catalyst Datastore in order to save the contents of those fields. You can find the help documentation regarding the same here.