Cheburakshu created SOLR-11405:
----------------------------------
Summary: SQL errors out with some non-specified table/field in
query
Key: SOLR-11405
URL: https://issues.apache.org/jira/browse/SOLR-11405
Project: Solr
Issue Type: Bug
Security Level: Public (Default Security Level. Issues are Public)
Reporter: Cheburakshu
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}]}}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
