[
https://issues.apache.org/jira/browse/SOLR-11405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Cassandra Targett updated SOLR-11405:
-------------------------------------
Component/s: Parallel SQL
> 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)
> Components: Parallel SQL
> Reporter: Cheburakshu
> Priority: Major
>
> 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
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
