【新サービス】 Spanner のダウンロード版である Spanner Omni が発表されました #GoogleCloudNext

$ docker volume create spanner

spanner

$ docker run -d --network host --name spanneromni \
    -v "spanner:/spanner" \
    us-docker.pkg.dev/spanner-omni/images/spanner-omni:2026.r1-beta \
    start-single-server

Unable to find image 'us-docker.pkg.dev/spanner-omni/images/spanner-omni:2026.r1-beta' locally
2026.r1-beta: Pulling from spanner-omni/images/spanner-omni
ffc3e3895e2e: Pull complete 
8f9df25c9e88: Pull complete 
17dbd5b98e16: Pull complete 
ae14a072e71d: Pull complete 
709f31676f12: Pull complete 
381d63cf8fe5: Pull complete 
df90e06afa57: Pull complete 
46a640d7d899: Pull complete 
2123a9354b10: Pull complete 
Digest: sha256:e98a088fa66d4a87dbb560d729bf21d998bb843f6018bd8dc118fe320e671886
Status: Downloaded newer image for us-docker.pkg.dev/spanner-omni/images/spanner-omni:2026.r1-beta
b1e3c38e5d25303eeb3aba28c8a074e3ec19ff6be92f9be83387cd4afc1969bd

$ docker ps

CONTAINER ID   IMAGE                                                             COMMAND                  CREATED          STATUS          PORTS     NAMES
b1e3c38e5d25   us-docker.pkg.dev/spanner-omni/images/spanner-omni:2026.r1-beta   "/bin/tini -- /googl…"   35 seconds ago   Up 30 seconds             spanneromni

$ docker exec -it spanneromni /google/spanner/bin/spanner databases create-sample-db retail

Created database: retail-sample and applied schema.
Inserted User Data.
Inserted Product Data.
Inserted Address Data.
Inserted Shopping Cart Data.
Inserted Payment Data.
Inserted Order Data.
Inserted Order Item Data.
Created sample database successfully.

$ docker exec -it spanneromni /google/spanner/bin/spanner databases list

NAME           STATE  VERSION_RETENTION_PERIOD  EARLIEST_VERSION_TIME        ENABLE_DROP_PROTECTION 
retail-sample  READY  1h                        2026-04-22T14:12:21.440307Z  false                   
spanner-info   READY  1h                        2026-04-22T13:14:38.849650Z  false                   

$ docker exec -it spanneromni /google/spanner/bin/spanner databases ddl describe retail-sample

CREATE TABLE Orders (
  OrderID INT64 NOT NULL,
  UserID INT64 NOT NULL,
  OrderDate TIMESTAMP,
  ShippingAddressID INT64,
  PaymentID INT64,
  TotalAmountUSD NUMERIC,
  OrderStatus STRING(MAX),
  OrderStatus_Tokens TOKENLIST AS (TOKENIZE_FULLTEXT(OrderStatus)) HIDDEN,
) PRIMARY KEY(OrderID);
・
・
・

$ docker exec -it spanneromni /google/spanner/bin/spanner sql --database=retail-sample

Welcome to Spanner-Cli Client.

Type 'help' or '\h' for help.
Type 'exit' or 'quit' or '\q' to exit.

spanner-cli>  

spanner-cli> SELECT ProductID, Name, Description, PriceUSD
FROM Products
WHERE SEARCH(Name_Tokens, 'phone')
ORDER BY PriceUSD DESC
LIMIT 10;

+-----------+---------------------------------+------------------------------------------------------------------------------------------+----------+
| ProductID | Name                            | Description                                                                              | PriceUSD |
+-----------+---------------------------------+------------------------------------------------------------------------------------------+----------+
| 201414    | Smith-Allen Mobile Phone        | This smith-allen mobile phone features high-resolution display and long battery life.    | 1086.15  |
| 197251    | Lutz-Howard Phone               | This lutz-howard phone features long battery life and advanced camera.                   | 974.94   |
| 301629    | Garza-Rogers Cell Phone Plus 69 | This garza-rogers cell phone plus 69 features 5G capability and high-resolution display. | 908.03   |
| 581741    | Brock, Phone                    | This brock, phone features wireless connectivity and advanced camera.                    | 830.75   |
| 377370    | Adkins, Cell Phone Plus 58      | This adkins, cell phone plus 58 features advanced camera and fast processing.            | 734.93   |
| 865179    | Jones, Cell Phone Pro 43        | This jones, cell phone pro 43 features advanced camera and long battery life.            | 709.21   |
| 407419    | Farley, Cell Phone              | This farley, cell phone features 5G capability and wireless connectivity.                | 625.71   |
| 988662    | Johnson Cell Phone Plus 28      | This johnson cell phone plus 28 features wireless connectivity and long battery life.    | 395.94   |
| 479201    | Jones Cell Phone Max 83         | This jones cell phone max 83 features advanced camera and fast processing.               | 391.59   |
| 230889    | Bean Cell Phone Ultra 49        | This bean cell phone ultra 49 features long battery life and high-resolution display.    | 389.04   |
+-----------+---------------------------------+------------------------------------------------------------------------------------------+----------+
10 rows in set (17.47 msecs)

spanner-cli> WITH
 ReferenceProduct AS (
   SELECT ProductEmbedding
   FROM Products
   WHERE ProductID = 197251
 )
SELECT p.ProductID, p.Name, p.Description, p.PriceUSD
FROM Products p, ReferenceProduct rp
WHERE p.ProductID != 197251 AND p.ProductEmbedding IS NOT NULL
ORDER BY
 COSINE_DISTANCE(
   rp.ProductEmbedding,
   p.ProductEmbedding)
LIMIT 5;

+-----------+--------------------------------------+-------------------------------------------------------------------------------------------------------+----------+
| ProductID | Name                                 | Description                                                                                           | PriceUSD |
+-----------+--------------------------------------+-------------------------------------------------------------------------------------------------------+----------+
| 969693    | Watson-Chambers mobile device Max 38 | This watson-chambers mobile device max 38 features high-resolution display and wireless connectivity. | 125.23   |
| 733052    | Mathews Smartphone Pro 16            | This mathews smartphone pro 16 features high-resolution display and long battery life.                | 852.93   |
| 865179    | Jones, Cell Phone Pro 43             | This jones, cell phone pro 43 features advanced camera and long battery life.                         | 709.21   |
| 496922    | Lewis, mobile device                 | This lewis, mobile device features high-resolution display and fast processing.                       | 1079.22  |
| 301629    | Garza-Rogers Cell Phone Plus 69      | This garza-rogers cell phone plus 69 features 5G capability and high-resolution display.              | 908.03   |
+-----------+--------------------------------------+-------------------------------------------------------------------------------------------------------+----------+
5 rows in set (2.14 msecs)

spanner-cli> GRAPH ECommerceGraph
  MATCH (p:Products { ProductID: 197251 })<-[:OrderItems]-(o:Orders)
  MATCH (u:Users)
  WHERE u.UserID = o.UserID
  RETURN DISTINCT u.UserID, u.Email;

+--------+--------------------------+
| UserID | Email                    |
+--------+--------------------------+
| 543143 | michaeladams@example.org |
| 391704 | jameswaller@example.com  |
| 456    | user456@example.com      |
| 191161 | hwilson@example.com      |
| 131244 | waltersalec@example.net  |
+--------+--------------------------+
5 rows in set (31.2 msecs)

$ docker exec -it spanneromni /app/bin/spanner-console

2026-04-22T14:33:24.935897383Z main INFO Starting configuration JsonConfiguration[location=jar:file:/app/lib/shared-0.8.24.jar!/log4j2.json]...
2026-04-22T14:33:24.937904193Z main INFO Configuration JsonConfiguration[location=jar:file:/app/lib/shared-0.8.24.jar!/log4j2.json] started.
2026-04-22T14:33:24.941076327Z main INFO Stopping configuration org.apache.logging.log4j.core.config.DefaultConfiguration@55fe41ea...
2026-04-22T14:33:24.941767203Z main INFO Configuration org.apache.logging.log4j.core.config.DefaultConfiguration@55fe41ea stopped.
{ "ts": "2026-04-22 14:33:24.957", "level": "WARN", "svc": "BFF", "thread": "main", "requestId": "", "logger": "c.g.o.s.StartupConfig", "msg": "Unrecognized argument: " }
{ "ts": "2026-04-22 14:33:24.977", "level": "INFO", "svc": "BFF", "thread": "main", "requestId": "", "logger": "OmniDB", "msg": "Starting OmniDB BFF | version=0.8.24 | commit=8b530775" }
{ "ts": "2026-04-22 14:33:25.015", "level": "INFO", "svc": "BFF", "thread": "main", "requestId": "", "logger": "OmniDB", "msg": "Enabled features: [FeatureFlag(name=NONE, state=GA)]" }
{ "ts": "2026-04-22 14:33:25.098", "level": "INFO", "svc": "BFF", "thread": "main", "requestId": "", "logger": "OmniDB", "msg": "Autoreload is disabled because the development mode is off." }
{ "ts": "2026-04-22 14:33:27.502", "level": "INFO", "svc": "BFF", "thread": "main", "requestId": "", "logger": "i.m.c.i.p.PushMeterRegistry", "msg": "publishing metrics for LoggingMeterRegistry every 1m" }
{ "ts": "2026-04-22 14:33:27.550", "level": "WARN", "svc": "BFF", "thread": "main", "requestId": "", "logger": "i.m.p.PrometheusMeterRegistry", "msg": "A MeterFilter is being configured after a Meter has been registered to this registry. All MeterFilters should be configured before any Meters are registered. If that is not possible or you have a use case where it should be allowed, let the Micrometer maintainers know at https://github.com/micrometer-metrics/micrometer/issues/4920. Enable DEBUG level logging on this logger to see a stack trace of the call configuring this MeterFilter." }
{ "ts": "2026-04-22 14:33:27.592", "level": "INFO", "svc": "BFF", "thread": "main", "requestId": "", "logger": "OmniDB", "msg": "Application started in 2.543 seconds." }
{ "ts": "2026-04-22 14:33:27.806", "level": "INFO", "svc": "BFF", "thread": "DefaultDispatcher-worker-1", "requestId": "", "logger": "OmniDB", "msg": "Responding at http://0.0.0.0:15026" }

http://<IP Address>:15026