You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Cheburakshu (JIRA)" <ji...@apache.org> on 2017/09/26 16:56:00 UTC
[jira] [Created] (SOLR-11405) SQL errors out with some
non-specified table/field in query
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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org