5 min Excel find duplicates without removing them

How to find duplicate values without removing them in Excel? (extendoffice.com) In Excel, the Remove Duplicates function can help users to quickly remove all duplicate values from a list. But in some times, you may only want to find and identify the duplicate values without removing them as below screenshot shown, how can you quickly […]

Measure your VM with typeperf (Pandas py) perfmon

Azure disk-types https://docs.microsoft.com/en-us/azure/virtual-machines/disks-types Ultra, Premium SSD, Standard SSD, Standard HDD. Max disk size 65,536 gibibyte (GiB) 32,767 GiB 32,767 GiB 32,767 GiB Max throughput 2,000 MB/s 900 MB/s 750 MB/s 500 MB/s Max IOPS 160,000 20,000 6,000 2,000 Premium SSD Azure premium SSDs deliver high-performance and low-latency disk support for virtual machines (VMs) with input/output […]

Python multicasting UDP wireshark

https://www.wireshark.org/ A multicast address is a logical identifier for a group of hosts in a computer network that are available to process datagrams or frames intended to be multicast for a designated network service. Multicast addressing can be used in the link layer (layer 2 in the OSI model), such as Ethernet multicast, and at […]

Apache Solr 7.5 The Standard Query Parser focus searching

http://lucene.apache.org/solr/guide/7_5/the-standard-query-parser.html Solr’s default Query Parser is also known as the “lucene” parser. The key advantage of the standard query parser is that it supports a robust and fairly intuitive syntax allowing you to create a variety of structured queries. The largest disadvantage is that it’s very intolerant of syntax errors, as compared with something like […]

Apache Solr 7.5 Index build with DirectUpdateHandler2 HTTP (with delete index)

http://lucene.apache.org/solr/guide/7_5/uploading-data-with-index-handlers.html Index Handlers are Request Handlers designed to add, delete and update documents to the index. In addition to having plugins for importing rich documents using Tika or from structured data sources using the Data Import Handler, Solr natively supports indexing structured documents in XML, CSV and JSON. The default in solrconfig.xml is an UpdateHandler: […]

Apache Solr 7.5 create core, alter schema and query for API data

With reference to previous tutorial: Core A single Solr instance, which represents a single Solr index. A core has a different set of configuration files and schema definitions than other cores. Now lets create a new core, after downloading and installing the files, have a look at the readme file in solr-7.5.0 directory (my pc; […]

Solr Terminology: Cores, Collections & Nodes

https://doc.lucidworks.com/lucidworks-hdpsearch/2.5/Guide-Solr.html Solr is the popular open source search solution. Solr can index content from many sources and has integration points for Apache Tika to index rich text documents (Office documents, PDFs, etc.), JSON files, CSV files and Solr-specific XML. Cores, Collections and Clusters Generally speaking, if you use Solr in standalone mode, you have a […]

Apache Solr 7.5 Build book_store index backup / restore

https://lucene.apache.org/solr/guide/6_6/making-and-restoring-backups.html If you are worried about data loss, and of course you should be, you need a way to back up your Solr indexes so that you can recover quickly in case of catastrophic failure. Solr provides two approaches to backing up and restoring Solr cores or collections, depending on how you are running Solr. […]

Apache Solr 7.5 Build book_store index insert/update/delete

We are starting from: Your Solr server is up and running, but it doesn’t contain any data yet, so we can’t do any queries, but we will use our own data and create our own index. in: https://lucene.apache.org/solr/guide/7_5/solr-tutorial.html#exercise-1   Quick recap: Start cloud mode: bin\solr.cmd start -e cloud We will create a collection called book_store […]

Apache Solr 7.5 (techproducts tutorial) 2

In this tutorial I have moved the environment outside the virtualbox. I installed the same version of Solr and JRE, and added the path for environment. And also created two bat files for easy start and stop of the server. I go over the steps in the tutorial below Index techproducts example data: https://lucene.apache.org/solr/guide/7_5/solr-tutorial.html#exercise-1 To […]