Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-373

Build a JDBC driver to access Solr

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: search, update
    • Labels:
      None

      Description

      Hello!

      Would it be a good thing to have a JDBC driver to access Solr? This would help people only knowing SQL syntax. And you can use things like Hibernate on top of that. Maybe this is a good alternative to Solrj. In the first run I would not allow any joins.

      I think of a SQL syntax like

      SELECT * FROM SOLR WHERE name='Albert' OR name='Einstein'

      which gets translated to a Solr query like

      q=name:Albert OR name:Einstein&fl=*

      What do you think?

      CU
      Thomas

        Issue Links

          Activity

          Hide
          yourabi Yousef Ourabi added a comment -

          Thomas,
          [ I'm not a solr-dev, these are just my thoughts / opinions ]

          I think that's a really horrible idea. That would promote the idea that solr is a relational database, and not a search index (inverted index). Here are my

          >> This would help people only knowing SQL syntax
          I think the query syntax is actually simpler than sql, anyone can pick it up in an hour or so of playing around with the documentation.

          >> In the first run I would not allow any joins.
          That's the entire point of a relational database, see first paragraph, solr/lucene is not a relational database.

          -Yousef

          Show
          yourabi Yousef Ourabi added a comment - Thomas, [ I'm not a solr-dev, these are just my thoughts / opinions ] I think that's a really horrible idea. That would promote the idea that solr is a relational database, and not a search index (inverted index). Here are my >> This would help people only knowing SQL syntax I think the query syntax is actually simpler than sql, anyone can pick it up in an hour or so of playing around with the documentation. >> In the first run I would not allow any joins. That's the entire point of a relational database, see first paragraph, solr/lucene is not a relational database. -Yousef
          Hide
          ryantxu Ryan McKinley added a comment -

          What do you see as the value for a JDBC driver? Are there good examples of packages that would "just work" if solr had a JDBC driver?

          Beyond a toy examples, stuffing a solr response into rows/columns will get very limiting very fast.

          Show
          ryantxu Ryan McKinley added a comment - What do you see as the value for a JDBC driver? Are there good examples of packages that would "just work" if solr had a JDBC driver? Beyond a toy examples, stuffing a solr response into rows/columns will get very limiting very fast.
          Hide
          ryantxu Ryan McKinley added a comment -

          I'll close the issue now... feel free to re-open it if you have a patch.

          In the future, it may be a good idea to pass ideas through the user groups to get some initial feedback.

          Show
          ryantxu Ryan McKinley added a comment - I'll close the issue now... feel free to re-open it if you have a patch. In the future, it may be a good idea to pass ideas through the user groups to get some initial feedback.
          Hide
          otis Otis Gospodnetic added a comment -

          Actually, a fun exercise around this might be interesting and might be more suitable for Lucene, a SQL SELECT to Lucene Query converter. I'm not sure if there is a real need for this, but it might be interesting to do this, and new ideas may come up during the development.

          Show
          otis Otis Gospodnetic added a comment - Actually, a fun exercise around this might be interesting and might be more suitable for Lucene, a SQL SELECT to Lucene Query converter. I'm not sure if there is a real need for this, but it might be interesting to do this, and new ideas may come up during the development.
          Hide
          iholsman Ian Holsman added a comment -

          another alternative would be to use something like sphinx (http://www.sphinxsearch.com/).
          While it isn't lucene, it might be better for your needs.

          Show
          iholsman Ian Holsman added a comment - another alternative would be to use something like sphinx ( http://www.sphinxsearch.com/ ). While it isn't lucene, it might be better for your needs.
          Hide
          arafalov Alexandre Rafalovitch added a comment -

          JDBC is now implemented as of Solr 6.

          Show
          arafalov Alexandre Rafalovitch added a comment - JDBC is now implemented as of Solr 6.
          Hide
          janhoy Jan Høydahl added a comment -

          Closing as "Duplicate" instead of "Later"

          Show
          janhoy Jan Høydahl added a comment - Closing as "Duplicate" instead of "Later"

            People

            • Assignee:
              Unassigned
              Reporter:
              tpeuss Thomas Peuss
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development