Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Operations
    1. Perform single + batch read on single + multiple dataset from script transform
    2. Perform single + batch read on DistributedCache single + multiple files from script transform
  2. Supported datasets tables for lookup
      Key
    1. KeyValueTable dataset
    2. ObjectMappedTable dataset
    3. CSV files treated as a list of key-value tablepairs
    4. ObjectMappedTable
  3. Optional caching with time-based expiration

Design

  1. LookupKV  Lookup interface 

    Code Block
    Objectinterface Lookup<T> {
      T lookup(String key);
      Map<String, Object>T> multiLookup(String[] key);
  2. Implement LookupKV in KeyValueTable and ObjectMappedTable
  3. lookup(String... keys);
      Map<String, T> lookup(Set<String> keys);
    }
  4. Implement Lookup in KeyValueTable and ObjectMappedTable
    1. KeyValueTable implements Lookup<String>
    2. ObjectMappedTable implements Lookup<StructuredRecord>
  5. DatasetConfigurer changes
    1. Add method: void useDataset(String datasetName);
  6. ScriptTransform changes
    1. Add configuration property for declaring lookup tables to use, properties for each table (e.g. dataset properties)

      Code Block
      "lookupTablestables": [
        {
          "name":"purchases",
          "type":"dataset",
          "properties": {
            "dataset":"purchases",
            "datasetPropertiesproperties": {{.. dataset properties ..},
        "enable.cache    "enableCache":"true",
            "cache.expirycacheExpiry":1234
          }
        },
        {"name":"ip2geo", "type":"file", "properties":{"file":"/data/ip2geo.csv"}}
      ]
    2. configure(): verify datasets / tables existtables (datasets and files) exist by calling DatasetConfigurer.useDataset()
    3. transform(): execute lookup methods in a transaction, provide LookupKV Lookup instance to script
      1. Options usage for lookup usage: 

        Code Block
        var result = context.getTablegetLookup("purchases").lookup(user);
        tables["purchases"].lookup(user);
        purchases.lookup(user);
      2. Options for multiLookup batch lookup usage:

        Code Block
        var result = context.getLookup("purchases").multiLookuplookup(["alice", "bob"]);
        // do something with result["alice"]
        // do something with result["bob"]

...