Quick Tips: Apache Phoenix and Zeppelin
Quick Tips: Apache Phoenix and Zeppelin
Quick tips to keep in mind when querying Phoenix from Zeppelin and to quickly add graphics to Zeppelin tables.
Join the DZone community and get the full member experience.
Join For FreeThe open source HPCC Systems platform is a proven, easy to use solution for managing data at scale. Visit our Easy Guide to learn more about this completely free platform, test drive some code in the online Playground, and get started today.
When querying Phoenix from Zeppelin, you can display images and do other HTML right inside your query results.
For building an image:
%jdbc(phoenix)
select '%html <img width=50 height=60 src="' || profile_image_url ||
'">' as imgp,substr(inception,131,150) as inception,
substr(sentiment,0,60) as sentiment,
handle,substr(msg,0,60) as msg, time, location,
stanfordsentiment, followers_count, hashtags
from tweets where handle = 'hortonworks' and inception is not nullAs you can see, to add HTML you merely have to use '%html to start your HTML segment within your query. The syntax is very particular and you must encode quotes. The easiest option is to use double quotes for all HTML quotes inside your HTML sections. To add variables and other pieces, the concatenation operator in Apache Phoenix is the double pipe (||).
This will let you quickly add graphics to your Zeppelin tables.
References
Managing data at scale doesn’t have to be hard. Find out how the completely free, open source HPCC Systems platform makes it easier to update, easier to program, easier to integrate data, and easier to manage clusters. Download and get started today.
Like This Article? Read More From DZone
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}