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