Find answers from the community

Updated last year

I am getting this error while using

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

6 comments

WWhiteFang_Jr

Seems like the schemas are not matching. Can you verify if the schemas are same in both the parts?

SShubham1696

@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?

WWhiteFang_Jr

It should create the schema on its own.
Could you verify once and see if it contains the correct schema.

SShubham1696

@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

WWhiteFang_Jr

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

SShubham1696

Actually i have followed this only and in this tutorial they have not showed how to use custom schema

Add a reply