Questions tagged [azure-search]

1

votes
1

answer
27

Views

Azure Search highlighting doesn't work for wildcards with scoring profiles

Azure Search supports highlighting with full text search which facilitates clients to locate the matched term in a returned document. I have provided a simple index schema below to illustrate the issue. { 'name': 'simple-index', 'fields': [ { 'name': 'key', 'type': 'Edm.String' }, { 'name': 'simple...
Ishan Srivastava
0

votes
0

answer
2

Views

Bing Custom Search - sort/order by file modification date

I have been asked by a client to see if Bing Custom Search can order results containing links to PDFs by file modification date. I know results can be ordered by the date the content was indexed (or re-indexed), but they are concerned with the actual age of PDF files as determined by the filesystem...
ZGuard
1

votes
2

answer
227

Views

Is there a way to “Expire” items in an Azure Search Index?

In Azure Search is there a mechanism to set an 'Expiration Date' on items within the index? I have a need for items to only be in the search index for a pre-defined period of time.
mynameiscoffey
1

votes
2

answer
127

Views

Hot to get Azure Search Service query key

I need list query keys from Microsoft.Search/searchServices using PoweShell or API. What I have investigate till now is: Get-AzureRmResource -ResourceType 'Microsoft.Search/searchServices/listQueryKeys' -ResourceGroupName 'resource-group-name' -ResourceName 'resource-name' -ApiVersion '2015-08-19'...
Leszek
0

votes
1

answer
6

Views

Filter on Collection(Edm.String) type fields in Azure Search

I have an index that has an Collection(Edm.String) type field as below which is facetable and filterable. Index definition But when I do a query with the payload as below for filtering: { 'count': true, 'search': 'Not able to connect to Azure SQL database', 'searchFields': 'Content,keyphrases', 'se...
1

votes
1

answer
351

Views

Escape single quotes in Azure Search query

I am having a single quote in the data in filter condition. Example: David O'Neil. So If we have give this in Search Explorer as, *&$count=true&$filter=Name eq 'David O'Neil' How can we escape that single quote in the filter. Update 1: If we use single quote to escape that one, 0 records are coming....
Arron
1

votes
2

answer
519

Views

Azure Search SDK Create DataSource

I've been created a datasource by Azure Search SDK. The Datasource from Azure sql which is a View. I tyr to setting the DataChangeDetectionPolicy and DataDeletionDetectionPolicy, but i can't understand how to set this two property. When i think this two property doesn't supported on the preview sdk...
kkman021
0

votes
0

answer
4

Views

How to customize the en.microsoft analyzer?

We are now using Azure search Microsoft language analyzers on some of language specific fields. In most of cases, it has better relevance than standard Lucene language analyzers. But we found an issue when verifying en.microsoft analyzer. The problem is, if the field value contains digits. The analy...
Youxu
1

votes
1

answer
170

Views

Using top with Azure Search Suggestions

I am building a search page with Azure Search. On my page, I have a search box. I want to provide suggestions to the users. In an attempt to do this, I'm using the Suggestions endpoint on my index. At this time, I have a request that includes the following query string: search=sta&suggesterName=site...
xam developer
1

votes
1

answer
253

Views

Tag parameters with commas in Azure Search tag boosting

We're using tag boosting on a scoring profile in Azure Search to boost results based on the number of intersecting strings. ie. Doc1 has { id: 1, name: 'thing', stuff:['1 stuff','2 stuff','3,4,5 stuff'] } Doc2 has { id: 2, name: 'thing2', stuff:['1 stuff','2 stuff'] } Searching with the scoring pa...
Fiddles
1

votes
2

answer
240

Views

Troubleshooting Azure Search poor performance

I am seeing erratic performance with an Azure Search Basic instance. Our index only has 1,544 documents and is 28MB in size, so I would expect searches to be very fast. Azure Application Insights is reporting 4.7K calls to Azure Search from our app within the last 12 hours, with an average response...
Kevin Krueger
1

votes
1

answer
371

Views

Azure search indexer failing with error message

My azure search indexer which reads from an sql table with Change Tracking, is failing with the following error 'Unable to cast object of type 'Newtonsoft.Json.Linq.JObject' to type 'System.String'.' If I reset the indexer, it'll start working fine. What is the root cause of the problem here?
harryjohn
1

votes
1

answer
398

Views

Search text “\**” throws error “Failed to parse query string.” but “\*”, “\*~” and “\~~” works

If the user starts a search, we automatically create a start with expression e.g. user input: 'Hello' => azure search input 'Hello*'. If the user types in a special characters like '+', '-', '!', '*', '~', etc. (Full list: https://msdn.microsoft.com/en-us/library/azure/mt589323.aspx#bkmk_syntax) we...
Magu
1

votes
1

answer
164

Views

Add additional columns to Azure Search Blob index

We are planning to configure Azure Search Index for Blob containers so the content of the documents can be indexed. But we need to add additional columns such as 'container name' to the index. As the indexer is automatically performing the indexing, how to customize it to add custom columns.
Sunny
1

votes
2

answer
356

Views

Azure Search Indexer cannot retrieve a GeographyPoint filed from a document in DocumentDB

I'm having an issue while trying to index a document stored in a DocumentDb collection. The datasource of the indexer was defined with a custom SQL to retrieve the changed documents. The document I want to index has a property called LocationGP which is a Microsoft.Spatial.GeographyPoint, and is map...
Maxolidean
1

votes
1

answer
97

Views

can azure search do facets with one to may relationships

If I have documents (lets say books) I want to search that have a facet (lets say genre) where the document can have many values for that facet, so for example a book could be both 'young adult', 'fiction', 'sci-fi' Can azure search faceting handle this situation and if so can it do it from simple s...
Gingemonster
1

votes
1

answer
320

Views

Azure Search statistics Power BI

I'm using storage account to gather Azure Search statistics with current settings by more than one week And Power BI to view reports. The issue is that even when I'm importing data for 20 days I can't see it in 'Search over time report', but only for one day regardless on period I'm selecting. What...
Roman Borovets
1

votes
1

answer
274

Views

DataFormat.Error Power BI Desktop

I'm using Power BI for analyzing Azure Search statistics. The raw data is gathered on storage account (blob) by Search traffic analytics tool. To import date I've used this tutorial. But on applying query changes I'm getting error. Any ideas how to solve it?
Roman Borovets
1

votes
1

answer
157

Views

Change indexer frequency in Azure Search

I've created an Index with azure search and made it cusom to run every 5 minute. I did this using the portal and it's based on a sql db. I'm would like to change the indexing frequency, but can't find any way to do this using the portal, is it hidden somewhere? or is the API the only way forward Bes...
Rasmus Christensen
1

votes
1

answer
131

Views

Azure Search, is it possible to use Suggestions and Profile Scoring in the same query

I have a search service which return a set of results for each character typed in the search box. For this I use the Suggestion service, to receive results base on sub string. Now I would like to order the results base on numerical values attached to each one of them. Is it possible to use Profile...
Guy Assaf
1

votes
1

answer
314

Views

Azure Search invalid base64 path in metadata using Blob Storage Indexer

I used Blob Storage Indexer to index my files in Azure Search. After performing a search, I was supposed to be able to determine the path of blob by decoding a base64 metadata string. From what I can tell, C# is unable to decode the returned base64. Here are sample base64 paths sent from Azure Sear...
Fernando Silva
1

votes
1

answer
399

Views

Implications of using AzureSearch SDK with static Dictionary of 30-40 ISearchIndexClients

I have an ASP.NET Web Application that uses 30-40 different search indexes across 5-6 search services (various clients are in different pricing tiers). Currently I am marshaling a new instance of the ISearchServiceClient followed by the appropriate ISearchIndexClient for the specific index needed ba...
INNVTV
1

votes
2

answer
169

Views

Azure Search Distance filter with variable distance

Suppose I have the following scenario: A search UI to allow individuals to find plumbers who are able to service their home location. When a plumber enters their info into the system, they provide their coordinates and a maximum distance they are willing to travel. The individual can then enter the...
Paul Hiles
1

votes
1

answer
88

Views

How can I health check probe an Azure Search service without using Azure Traffic manager?

I am using Azure Search and have search services set up in multiple regions for high availability. I would like to poll/probe the health of the services using an external load balancer to ensure that I am serving only healthy instances. What is the best way to do this with Azure Search? Is there a U...
pantryfight
1

votes
1

answer
193

Views

Azure Search - Difference between Upload & MergeOrUpload

What is the difference between the 2 methods Upload versus MergeOrUpload in Azure Search. They both do exactly the same thing. i.e. they both will upload a document if it does not exist and replace the document if it already does exist. Is there any performance differences that could be gained due t...
user2981411
1

votes
2

answer
1.2k

Views

Return records from azure search that match the exact search term only

So I'm new to Azure search and I'm only starting to figure it out. I have a search index that queries a pretty simple sql view for matching records. I'm having major trouble getting an exact match for the word I search for. Whenever I search I get records with the exact word only.. however I also ge...
some_randomer
1

votes
1

answer
270

Views

Change Tracking in an Azure SQL DB for Azure Search for non-dbo Schema

I am associating an Azure SQL DB Table to my Azure Search using an Indexer. I am setting this all up using Azure's website: https://portal.azure.com When I try and create the Indexer in Azure Search, I get the warning about 'Consider enabling integrated change tracking on your database.' However, I...
Jesse Sierks
1

votes
1

answer
52

Views

Azure Search - query within a specific field using the .Net SDK

We are attempting to build our API for our Azure Search index using the .Net SDK for Azure Search. We are trying to write the equivalent code for the searchFields parameter of the query found in the Rest API syntax for Azure Search (found via this thread: Azure Search; Search inside a specific fiel...
Stpete111
1

votes
1

answer
235

Views

In Azure Search Services, metadata_storage_path is wrong

I have indexed the content of a blob container in a Azure Search Service index, using indexers, via Azure Portal. When running queries in Azure portal, most of the documents have the correct metadata_storage_path but few do not. They have an extra character after the name, usually a '5'. It seems A...
user3429660
1

votes
1

answer
46

Views

Azure Search - import data from one field in a database record to two fields in a Search document

We've created an Azure Search index as such: { 'name': 'Ident0012', 'fields': [ { 'name': 'CaptureId', 'type': 'Edm.String', 'searchable': false, 'filterable': false, 'sortable': false, 'facetable': false, 'key': true, 'retrievable': true }, { 'name': 'Identifier', 'type':...
Stpete111
1

votes
1

answer
247

Views

Configure azure search IP to connect to On-prem DB

I am using Indexer to load data in Azure Index. I want to use on-premise database to copy data in azure index. I don't want to use ADF. Here I found that i need to allow azure search IP to connect to on-prem db. But I don't know how to configure that?
Jai
1

votes
1

answer
405

Views

Azure Search Instead of Elasticsearch

The existing application is running in elasticsearch. The functionality of the application covers. MLT search synonym search stopwords multilingual search Filtered search kibana dashboard uses aggregations to show the metrics in the dashboard. Is it possible to achieve all these functionality in azu...
Muthu
1

votes
2

answer
186

Views

Query / Filter Azure Search Edm.Collection by any of multiple strings

I'm trying to filter an azure search edm.collection to return results if any of multiple strings are in the collection. I can only get it working when querying for one item, which isn't good enough for my use case. I can't find syntax for querying multiple parameters. filter += 'FirmTypes / any (x...
Pete Herc
1

votes
1

answer
566

Views

Azure Search - Using double quotes in a search string

I have a requirement that my application should be able to search a string having a double quote in it. For example 22' Wood Log. Currently, searching for this string returns an error of query being failed. I understand that using quotes like 'abc' will give me results for only abc. But in the case...
Waleed Iqbal
1

votes
2

answer
77

Views

Azure Search - AzureSearch_SkipContent

I have some very large blobs, so I set AzureSearch_SkipContent on the blob row with the following code : if (b.Properties.Length >= 134217728) { b.Metadata['AzureSearch_SkipContent'] = 'true'; await b.SetMetadataAsync(); } But when I review the warning and errors I can see that the indexer has atte...
Steve Drake
0

votes
0

answer
3

Views

How to Add index to a List Column (Azure cosmos ) in Azure Search

I'm having a complex document in my Cosmos DB like below { 'id': 'e064a694-8e1e-4660-a3ef-6b894e9414f7', 'Name': 'Lidiya Lawrence', 'languageBatchResult': { 'id': 'Lidiya Lawrence', 'Languages': [ { 'name': 'English' } ] }, 'keyPhraseBatchResult': { 'Keys': [ 'Government of India', 'Training Co-ordi...
Jayendran
1

votes
2

answer
540

Views

Azure Search Highlight Partial Match

I have turned Hit Highlighting on and it is working well for entire word matches. But we append a wildcard character at the end of each word the user specifies and highlighting is not working on the partial matches. We are getting the results back, but the .Highlights object is null so no highlighti...
77Vetter
1

votes
1

answer
131

Views

Azure Search performance when using String vs DateTimeOffset for date values

Do comparison filters (i.e.: between, greater, less than etc.) perform as fast on (formatted-to) string properties as they do when targeting specific data types (DateTimeOffset)? For example, if I want to retrieve documents that have been modified after 2011-05-12, will modifiedDateTime gt 2011-05-1...
letlampa
1

votes
1

answer
73

Views

Azure Search Service search integers

Providing you have a simple index: public partial class SomeIndex { [Key] [IsFilterable] public string Id{ get; set; } [IsSearchable, IsFilterable, IsSortable] public string Name{ get; set; } [IsFilterable, IsSortable] public int SomeNumber { get; set; } How do I search the exact number matches for...
tom33pr
1

votes
3

answer
166

Views

Azure Search failing with latest update of Microsoft.Rest.ClientRuntime

I had a package update today for Microsoft.Rest.ClientRuntime v2.3.12 to v2.3.13 and my search stopped working. The symptoms are that the call to the client search would just hang. Looking at the data through Fiddler, I can see the request go out and come back, but my output window is showing Exce...
Matty

View additional questions