[SOLR-11405] SQL errors out with some non-specified table/field in query

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Parallel SQL
• Assignee: Unassigned
• Reporter: Cheburakshu
• Created: 26/Sep/17 16:55
• Updated: 08/Jun/19 15:24

Description

I get error when querying a table on /sql endpoint. The error is related to some query I previously executed. I am unable to execute any other queries on this table in /sql endpoint because of this error.

I am using Solr 6.6.1 on Ubuntu

http://35.199.170.234:8983/solr/piwik_log_conversion_item/sql?indent=on&stmt=select%20*%20from%20piwik_visit_log%20limit%2010&wt=json
{
"result-set":{
"docs":[

{ "EXCEPTION":"Failed to execute sqlQuery 'select * from piwik_visit_log limit 10' against JDBC connection 'jdbc:calcitesolr:'.\nError while executing SQL \"select * from piwik_visit_log limit 10\": At line 1, column 8: Unknown identifier 'piwik_site'", "EOF":true, "RESPONSE_TIME":45}

]}}