Find answers from the community

Updated last year

I am getting this error while using

At a glance

The community member is experiencing an error while using a query engine over an SQL database and is seeking a resolution. They have used the SQLTable schema from the llamaindex objects module to define the schema. Other community members suggest that the issue may be related to the schemas not matching between the different parts of the system. They advise the original poster to verify the schema and ensure it is correct. The community members also recommend following a tutorial on using SQLIndexDemo from the llamaindex documentation, which includes a Colab link to try it directly. However, the original poster notes that the tutorial does not show how to use a custom schema.

Useful resources
I am getting this error while using query engine over sql database for some of the queries. How can i resolve this. For defining schema I have used SQLTable schema from llamaindex objects module
Attachment
32e92081-2c9b-4edd-9646-37597fc03a88.jpg
W
S
6 comments
Seems like the schemas are not matching. Can you verify if the schemas are same in both the parts?
@WhiteFang_Jr Yes but I have picked schema using sqlTableSchema module of llamaindex. Doesn't it take schema automatically or I have to provide in context by myself?
It should create the schema on its own.
Could you verify once and see if it contains the correct schema.
@WhiteFang_Jr I checked but it does not consist of anything. I think it's having default values
Attachment
rn_image_picker_lib_temp_4188d10e-3576-4db6-ae5d-a84c51629f1e.jpg
This looks like a default schema,

You can follow this tutorial and there's a colab link as well for you to try directly on colab

https://docs.llamaindex.ai/en/stable/examples/index_structs/struct_indices/SQLIndexDemo.html
Actually i have followed this only and in this tutorial they have not showed how to use custom schema
Add a reply
Sign up and join the conversation on Discord