Hi Everyone, Just a doubt, but does the

ccoder_004

Hi Everyone, Just a doubt, but does the llama index only give answers based on data present in a vector database or a structured database? What If I want to run some general query eg "How many planets solar system have ", It gives me error :

"Transformed query given SQL response: None
I'm sorry, but there is no information available about Sony in the query results."

I want to run generalized queries too. I'm using SQLAutoVectorQueryEngine.

" query_engine_llm = SQLAutoVectorQueryEngine(
sql_tool, vector_tool, selector = LLMSingleSelector.from_defaults(), service_context=service_context
)"

Any help or guidance?

4 comments

LLogan M

The default prompts tell it to only use the context provided, so thats kind of expected

You might need to update the prompt templates for your query engines

LLogan M

https://docs.llamaindex.ai/en/stable/module_guides/models/prompts/usage_pattern.html#getting-and-setting-custom-prompts

ccoder_004

@Logan M : Can I define a separate Custom Engine for just llm and then use the selector to choose between base query and document-specific query.?

but then again, How will the code work with selector

LLogan M

You could define a custom query engine and do that yea. You would probably use a router query engine to wrap all that and route queries to the appropriate query engine

Add a reply

Find answers from the community

Hi Everyone, Just a doubt, but does the