On 9/18/2015 8:33 PM, Shawn Heisey wrote:
The "field:*" syntax is something you should not get in the habit of
using. It is a wildcard search. What this does under the covers is
looks up all the possible terms in that field across the entire index,
and constructs a Lucene query that actually includes all those terms.
If you execute a search like this on a field that has millions or
billions of terms, Solr will find them all. It will use a ton of memory
and be quite slow.
Yes. I only specified * to see if it would return ANY results, because
searching on a fixed string does not.
For the problem with "Sunday":
What fieldType is used for "logtext"?
There is no fieldType defined in my solrconfig.xml, unless you are
referring to this line:
<str name="queryAnalyzerFieldType">text_general</str>
Should I have one?? Defined where?
If you are talking about the fieldType of this column in the PostgreSQL
database, it is "Text"...
We'll also need the full
definition of that fieldType,
Not sure what you want here... (Herein may lie my problem...)
and an example of the full text indexed
into that field for a document that should match, but doesn't.
Attached are 2 files: one where I used "*" and so it returned all
documents, but I only include the top 2 in my attachment. You can see
the first document contains the word "Wednesday". So I replaced "*"
with "Wednesday" and ran the query again. This is the second
attachment, showing zero results. The "logtext" field is what I search
on, and this field type is plain text, although I don't think I
specifically declare this anywhere.
Both attachments were run with debug on.
Thanks,
Mark
You should also check the "debugQuery" box on the Query tab, and give us
the "rawquerystring" and "parsedquery" values from the debug.
Thanks,
Shawn
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">1</int>
<lst name="params">
<str name="q">Wednesday</str>
<str name="indent">true</str>
<str name="wt">xml</str>
<str name="debugQuery">true</str>
<str name="_">1442626657279</str>
</lst>
</lst>
<result name="response" numFound="0" start="0">
</result>
<lst name="debug">
<str name="rawquerystring">Wednesday</str>
<str name="querystring">Wednesday</str>
<str name="parsedquery">logtext:Wednesday</str>
<str name="parsedquery_toString">logtext:Wednesday</str>
<lst name="explain"/>
<str name="QParser">LuceneQParser</str>
<lst name="timing">
<double name="time">1.0</double>
<lst name="prepare">
<double name="time">0.0</double>
<lst name="query">
<double name="time">0.0</double>
</lst>
<lst name="facet">
<double name="time">0.0</double>
</lst>
<lst name="facet_module">
<double name="time">0.0</double>
</lst>
<lst name="mlt">
<double name="time">0.0</double>
</lst>
<lst name="highlight">
<double name="time">0.0</double>
</lst>
<lst name="stats">
<double name="time">0.0</double>
</lst>
<lst name="expand">
<double name="time">0.0</double>
</lst>
<lst name="debug">
<double name="time">0.0</double>
</lst>
</lst>
<lst name="process">
<double name="time">0.0</double>
<lst name="query">
<double name="time">0.0</double>
</lst>
<lst name="facet">
<double name="time">0.0</double>
</lst>
<lst name="facet_module">
<double name="time">0.0</double>
</lst>
<lst name="mlt">
<double name="time">0.0</double>
</lst>
<lst name="highlight">
<double name="time">0.0</double>
</lst>
<lst name="stats">
<double name="time">0.0</double>
</lst>
<lst name="expand">
<double name="time">0.0</double>
</lst>
<lst name="debug">
<double name="time">0.0</double>
</lst>
</lst>
</lst>
</lst>
</response>
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">2</int>
<lst name="params">
<str name="q">*</str>
<str name="indent">true</str>
<str name="wt">xml</str>
<str name="debugQuery">true</str>
<str name="_">1442626473675</str>
</lst>
</lst>
<result name="response" numFound="9857" start="0">
<doc>
<str name="id">2007-03-21 12:43:25.0</str>
<arr name="category">
<long>16</long>
</arr>
<arr name="logtext">
<str>ZCZC CRWHCMTIR CES
TTAA00 KTIR DDHHMM
...FOR INTERGOVERNMENTAL AGENCY USE ONLY...
Hydromet Coordination Message
Ohio River Forecast Center, Wilmington, OH
843 AM EDT Wednesday, March 21, 2007
To: OHRFC WFOs
From: OHRFC
OHRFC QPF Discussion:
Tricky forecast this morning with the warm front moving northward across the
Ohio
Valley. Expect this feature to produce scattered showers, mainly across the
northern
and western basin. The conveyor of warm, moist air will skirt the western
basin, but
most of the really intense precipitation should remain west of the area through
12Z
Thursday. The ensuing cold front will bring the heavy rainfall into the Ohio
Valley
Thursday into Thursday night. The front then stalls parelleling the Ohio River,
and
another wave slides across late Friday, producing another round of moderate to
heavy precipitation. The front finally washes out by the weekend bringing a
respite from the unsettled weather.
OHRFC QPF Amounts through 12Z Thursday:
Rainfall will mainly be confined to the northern and western tiers of the
basin. Basin average amounts will generally range from a few hundredths up to
about a quarter inch, although isolated pockets withing the Maumee and Wabash
watersheds could see over a quarter inch. Elsewhere, a few showers over the
Appalachians will produce a few hundredths for the Kanawha.
$$
Myers
NNNN</str>
</arr>
<arr name="username">
<str>myers</str>
</arr>
<long name="_version_">1512693012333854720</long></doc>
<doc>
<str name="id">2008-04-01 22:50:58.0</str>
<arr name="category">
<long>16</long>
</arr>
<arr name="logtext">
<str>ZCZC CRWHCMTIR CES
TTAA00 KTIR DDHHMM
...FOR INTERGOVERNMENTAL AGENCY USE ONLY...
Hydromet Coordination Message
Ohio River Forecast Center, Wilmington, OH
650 PM EDT Tuesday, April 1, 2008
To: OHRFC WFOs
From: OHRFC
***The OHRFC will close at the usual time of 10PM this evening***
If there are any hydrologic concerns please call as soon as possible to allow
for sufficient time to run models and issue forecasts.
OHRFC QPF Discussion:
A cold front is currently along the eastern and southern edge of the basin at
this time. Some light rain showers continue along the front and across the
north with the upper level system. All amounts are light and will continue to
decrease as high pressure builds into the basin for a dry Wednesday for the
entire region.
OHRFC QPF Amounts:
A few hundredths of an inch across portions of middle TN and across western VA
into NC. Elsewhere, little or no rainfall is expected.
$$
JEH
NNNN</str>
</arr>
<arr name="username">
<str>heim</str>
</arr>
<long name="_version_">1512693012432420864</long></doc>
