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

Parallel SQL - column not found error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 6.6
    • None
    • Parallel SQL
    • None

    Description

      Parallel SQL throws "column not found" error when the query hits multiple shards and one of shard doesn't have any documents yet.

      Sample error
      ==
      {"result-set":{"docs":[

      {"EXCEPTION":"Failed to execute sqlQuery 'SELECT sr_sv_userFirstName as firstName, sr_sv_userLastName as lastName FROM collection1 ORDEr BY dv_sv_userLastName LIMIT 15' against JDBC connection 'jdbc:calcitesolr:'.\nError while executing SQL \"SELECT sr_sv_userFirstName as firstName, sr_sv_userLastName as lastName FROM collection1 ORDEr BY dv_sv_userLastName LIMIT 15\": From line 1, column 9 to line 1, column 27: Column 'sr_sv_userFirstName' not found in any table","EOF":true,"RESPONSE_TIME":87}

      ]}}

      Attachments

        Activity

          People

            Unassigned Unassigned
            susheel2777@gmail.com Susheel Kumar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: