34,586 questions
1
vote
1
answer
41
views
How to use index to search if trim is used in search value
My Postgres 17 database has a large table with 245 columns containing an indexed column ribakood:
CREATE TABLE firma2.toode
(
...
ribakood character(20) COLLATE pg_catalog."default",
...
...
- 28k
1
vote
0
answers
37
views
How to change solr field type after data is already indexed?
One field name say field_one is indexed as indexed=false. But I want to change it to indexed=true.
I have also changed the schema.xml and reloaded the collection. Now, I am getting the error
cannot ...
- 493
-4
votes
0
answers
22
views
My nextjs personal portfolio website is not getting indexed by Google [closed]
I do have a personal website, kind of my personal portfolio with integrated blog, I am facing issue with indexing of pages of my website on google, I don't really know what the issue is, whatever I ...
- 3
0
votes
0
answers
25
views
+50
Efficiency of schema design for rocksdb - normalization and key compression considerations
I have a use case, for which I'm considering RocksDB. Part of the problem involves persistently storing values (with a meaningful ordering) associated with hierarchically structured labels. ...
- 2,008
0
votes
1
answer
49
views
Wanted to use "contains" operator in azure search service skillset and output the value to another field
I have an index which indexes all the documents from a particular sharepoint location.
The concern is that now I need to the custom "folder name" based on the i/p received in ...
- 11
0
votes
0
answers
52
views
Optimizing MySQL LIKE Query with Pattern Matching for Large Data(20M+ records) and FULL TEXT SEARCH not giving accurate results
Optimizing MySQL LIKE Query with Pattern Matching for Large Dataset (20M+ records)
I'm struggling with performance issues in MySQL while searching through a large table containing over 20 million ...
- 11
-2
votes
0
answers
48
views
index match with 2 column not working in 2016 excel [closed]
[see in the amount cell ][1]
[1]: https://i.sstatic.net/BGwxtjzu.png
please see image click on link
you will know not fetching amount correctly,
i also used {=INDEX(E3:E12,MATCH(1,(H2=B3:B12)*(H3=C3:...
1
vote
2
answers
49
views
How can I calculate averages and min max values in a climate data frame after Creating an Index on Date-time in Pandas
I have climate data dataframe in cs format but no headers, so I read data as follows:
df_MERRA_data = pd.read_csv(fname,delimiter=',',header=None)
df_MERRA_data.columns = \
['Date-time'...
3
votes
1
answer
54
views
How can I sort order of index based on my preference in multi-index pandas dataframes
I have a pandas dataframe df. It has multi-index with Gx.Region and Scenario_Model.
The Scenario_Model index is ordered in alphabetical order des, pes, tes. When I plot it, it comes in the same order. ...
- 1,730
-1
votes
0
answers
121
views
PySide6 QComboBox.setCurrentIndex() not working as documented [closed]
I am attempting to populate a PySide6 combo-box, then set the current index based on the contents of the combo-box.
def populate_fields_from_args(self):
for available_report in self....
2
votes
1
answer
91
views
In Torch for R, fitting a Dataloader object yields "Indexing starts at 1 but found a 0" error
I keep getting the error "Indexing starts at 1 but found a 0" when fitting a model where the input or output started life as R objects (vectors, matrices, or arrays), but only when using a ...
- 35
0
votes
1
answer
49
views
SQL Server ignores indexes
I have created a view (dbo.twhinr910100) WITH SCHEMABINDING on a table (dbo.twhinr110100), and some indexes in the view to optimize performances.
Everything worked like a charm on TEST server and the ...
- 13
-2
votes
1
answer
116
views
Can the index name in a `for` loop be pulled from an environment variable? [closed]
Bit of a crazy question, but I'm just wondering. Suppose, I have a for loop inside some function, but I want to specify the index name when I run the function. In this example,
I could set idxname &...
- 21.6k
0
votes
1
answer
35
views
Azure AI Search: Documents not available immediately after upload - how to check when indexing is complete?
I have python code that reads a document, divides it into chunks, stores them in an Azure AI Search vector database, and then tries to retrieve them. However, on the first run, the documents are not ...
- 31
0
votes
1
answer
26
views
Prevent duplicate use of value for another primary key?
I have this table that stores historical data of a record. Any update even with code and name fields should insert a new record of the same id but may have different values for code, name and ...
- 1,719