pysolr icon indicating copy to clipboard operation
pysolr copied to clipboard

Thrift service / Solr SQL support ?

Open Tagar opened this issue 6 years ago • 6 comments

One of later Solr releases added Thrift service ..

Would be great if PySolr would have added Thrift support too.. My understanding it opens up a way to send SQL-like queries to Solr , not just REST API calls.

Thank you.

Tagar avatar Feb 06 '19 20:02 Tagar

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar May 07 '19 21:05 stale[bot]

@Tagar are you talking about the Parallel SQL Interface introduced in Solr 6.x?

Near the bottom of that page, they have some docs on how to access it via HTTP, so I'm not sure it requires Thrift.

jnovinger avatar Jun 03 '19 21:06 jnovinger

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Sep 01 '19 22:09 stale[bot]

@jnovinger just noticed your response

I realize my question might have been a bit confusing.

This is not directly related to Thrift.

I was just checking if we could use this python package to run some SQL queries against Solr cluster.

For example, see https://lucene.apache.org/solr/guide/6_6/parallel-sql-interface.html#basic-select-statement-with-limit

Thank you

Tagar avatar Sep 03 '19 18:09 Tagar

Would love to have support for /sql request handler. Add stmt=.

svanschalkwyk avatar Jul 22 '20 23:07 svanschalkwyk

SOLVED options = { 'stmt':'SELECT DISTINCT xxx FROM yyy'} res = solr1.search('*', search_handler='/sql', **options)

svanschalkwyk avatar Jul 23 '20 00:07 svanschalkwyk