daynebatten

daynebatten

-- Only 1 operation necessary to convert
select
    levenshtein('cat', 'bat'); --1
    
-- Similar and not-so-similar names
select
    levenshtein('christina', 'kristina'), --2
    levenshtein('josephus', 'kristina'); --8
    
-- Similar and not-so-similar pronunciations

daynebatten

-- With metaphone, a hard C and hard K both code to 'K'
-- Note that you specify a maximum encoding length, since metaphone can return long encodings
select
    metaphone('kristina', 100), -- KRSTN
    metaphone('christina', 100); --KRSTN

-- Metaphone thinks the GH is pronounced like 'laugh'
-- But double metaphone knows the GH is silent
select
    metaphone('hayleigh', 100), --HLF

daynebatten

-- Returns D620
select
    soundex('drake');
    
-- Returns B420
select
    soundex('blake');
    
-- Returns 2
select

daynebatten

CREATE EXTENSION fuzzystrmatch;

daynebatten

CombineFileInputFormat.setMaxInputSplitSize(job, 128000000);

daynebatten

"Private Selection"
"Kroger"
"Smithfield"
"Kellogg's"
"Ocean Spray"
"Keebler"
"Kraft"
"Purina"
"Coca-Cola"
"Monster"

daynebatten

/**
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0

daynebatten

if (fileBroken) {
  return 1.0f;
} else if (start == end) {
  return 0.0f;
} else {
  return Math.min(1.0f, (getFilePosition() - start) / (float)(end - start));
}

daynebatten

if (newSize == 0 || fileBroken) {
  key = null;
  value = null;
  return false;
} else {
  return true;
}