Anko
I’m trying to write a Table.Reader implementation for Snap.SearchResponse from the snap library (GitHub - breakroom/snap: An Elasticsearch/OpenSearch client for Elixir · GitHub) which talks to elasticsearch
This is what I think it should look like
if Code.ensure_loaded?(Table.Reader) do
defimpl Table.Reader, for: Snap.SearchResponse do
def init(result) do
columns = get_columns(result)
rows = get_rows(result)
{:rows, %{columns: columns}, rows}
end
defp get_columns(response) do
if response.hits.hits |> Enum.empty?() do
[]
else
hits = response.hits.hits
hits |> List.first() |> Map.fetch!(:source) |> Map.keys()
end
end
defp get_rows(response) do
hits = response.hits.hits
hits
|> Enum.map(fn hit ->
hit.source |> Map.values()
end)
end
end
end
and here is an Example Snap.SearchResponse
%Snap.SearchResponse{
took: 1,
timed_out: false,
shards: %{"failed" => 0, "skipped" => 0, "successful" => 1, "total" => 1},
hits: %Snap.Hits{
total: %{"relation" => "gte", "value" => 10000},
max_score: 1.0,
hits: [
%Snap.Hit{
index: "products",
type: nil,
id: "BH2lkY0BtfUXFCo5NxOU",
score: 1.0,
source: %{
"Country" => "Myanmar",
"Item Type" => "Beverages",
"Order Date" => "5/29/2016",
"Order ID" => "238846909",
"Order Priority" => "L",
"Region" => "Asia",
"Sales Channel" => "Offline",
"Ship Date" => "6/15/2016",
"Total Cost" => "284933.77",
"Total Profit" => "140360.58",
"Total Revenue" => "425294.35",
"Unit Cost" => "31.79",
"Unit Price" => "47.45",
"Units Sold" => "8963"
},
fields: nil,
explanation: nil,
matched_queries: nil,
highlight: nil,
inner_hits: nil
},
%Snap.Hit{
index: "products",
type: nil,
id: "BX2lkY0BtfUXFCo5NxOU",
score: 1.0,
source: %{
"Country" => "Costa Rica",
"Item Type" => "Cereal",
"Order Date" => "2/23/2017",
"Order ID" => "673583209",
"Order Priority" => "L",
"Region" => "Central America and the Caribbean",
"Sales Channel" => "Online",
"Ship Date" => "2/26/2017",
"Total Cost" => "830895.45",
"Total Profit" => "628546.05",
"Total Revenue" => "1459441.50",
"Unit Cost" => "117.11",
"Unit Price" => "205.70",
"Units Sold" => "7095"
},
fields: nil,
explanation: nil,
matched_queries: nil,
highlight: nil,
inner_hits: nil
},
%Snap.Hit{
index: "products",
type: nil,
id: "Bn2lkY0BtfUXFCo5NxOU",
score: 1.0,
source: %{
"Country" => "Cameroon",
"Item Type" => "Meat",
"Order Date" => "7/30/2014",
"Order ID" => "277272450",
"Order Priority" => "H",
"Region" => "Sub-Saharan Africa",
"Sales Channel" => "Offline",
"Ship Date" => "8/12/2014",
"Total Cost" => "3623195.15",
"Total Profit" => "568282.00",
"Total Revenue" => "4191477.15",
"Unit Cost" => "364.69",
"Unit Price" => "421.89",
"Units Sold" => "9935"
},
fields: nil,
explanation: nil,
matched_queries: nil,
highlight: nil,
inner_hits: nil
},
%Snap.Hit{
index: "products",
type: nil,
id: "B32lkY0BtfUXFCo5NxOU",
score: 1.0,
source: %{
"Country" => "Republic of the Congo",
"Item Type" => "Clothes",
"Order Date" => "9/23/2015",
"Order ID" => "593713462",
"Order Priority" => "H",
"Region" => "Sub-Saharan Africa",
"Sales Channel" => "Online",
"Ship Date" => "10/7/2015",
"Total Cost" => "66734.08",
"Total Profit" => "136745.28",
"Total Revenue" => "203479.36",
"Unit Cost" => "35.84",
"Unit Price" => "109.28",
"Units Sold" => "1862"
},
fields: nil,
explanation: nil,
matched_queries: nil,
highlight: nil,
inner_hits: nil
}
]
},
suggest: nil,
aggregations: nil,
scroll_id: nil,
pit_id: nil
}
so i’ve forked snap, added this code and loaded it in a livebook
{:ok, results} = Snap.Search.search(Elastic, "products", %{query: %{match_all: %{}}})
results
I would expect livebook to show me a data table, but instead it just shows me the full Snap.SearchResponse pasted above. I have tried added IO.puts in the Table.Reader init function but to no avail. Any ideas how i can debug this?
Trending in Questions
I having some trouble figuring out if I have set myself too strict of standards for my production server. Currently I can handle 75% of r...
New
Documentation
While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
New
Hello,
I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
Hi everyone,
I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding.
I sta...
New
So my question is quite simple and i have found no conclusive answer on forum, google or AI.
Should we use :erlang.float for Integer to ...
New
I recently noticed that Elixir’s Logger defaults its primary log level to :debug when no :logger, :level application configuration is pre...
New
I’m new to elixir and just tried to install the elixirLS extension for VScode(ium) and it is throwing some errors that I would like help ...
New
Other Trending Topics
Edit: 2026 May 15 - This post is archived.
Mob is alive!!
Main docs: mob v0.7.11 — Documentation
A bit of explanation for the slightly c...
New
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
I am happy to introduce the very α version of the new programming language compiled to BEAM.
Welcome Cure.
It has literally three kille...
New
Hobbes is a low-level distributed database for the Elixir programming language.
Hobbes provides a simple, safe, and scalable storage lay...
New
Hi everyone!
The first release candidate for the Expert language server project is now available!
We’ve published a press release detai...
New
A little off-topic, but I feel like people here have a good head on their shoulders.
I used to be quite good at making software. Was luc...
New
Latest Livebook Threads
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ai
- #ecto-query
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #metaprogramming
- #hex










Showing Posts 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
Anko
update:
works, so my Table.Reader works.. i don’t understand yet why it doesn’t show as tabular data in livebook
also works
jonatanklosko
In order for Livebook to render a struct in a special way, it needs to implement the
Kino.Renderprotocol. See kino_db/lib/kino_db.ex at 0de094fcefb2f28a5c413e95ce551adf00dcb5e7 · livebook-dev/kino_db · GitHub for example.Anko
Wow thanks
I had no idea this is what was wrong.
Do you have any thoughts on the best path forward for livebook + elasticsearch? It’s not exactly tabular data. I mean, it contains tabular data but it also has a great deal of metadata eg. aggregations shards etc.. as per the above example.
jonatanklosko
I didn’t really interact with ES in practice, so I don’t have a strong opinion what would be most useful. For queries I can imagine the score being quite relevant, so perhaps it should also be a part of the table.